SELECT 	
	d.ObjectId,
	d.[Date], 
	sdh.[Date],
	sdh.Code
FROM dbo.Document d 
join (
	select top  1  dh.Document , dh.[Date], s.Code
	from dbo.DocHistory dh 
	INNER JOIN dbo.DocState ds ON dh.State = ds.ObjectId
	INNER JOIN dbo.State s ON ds.StateName = s.ObjectId AND s.Code IN ('VS','MD','TR','TD','AZ')
	where dh.Document = d.ObjectID
	order by dh.[Date] desc
) sdh on sdh.Document = d.ObjectID

SELECT 	
	d.ObjectId,
	d.[Date], 
	sdh.[Date],
	sdh.Code
FROM dbo.Document d 
join (
	select top  1  dh.Document , dh.[Date], s.Code
	from dbo.DocHistory dh 
	INNER JOIN dbo.DocState ds ON dh.State = ds.ObjectId
	INNER JOIN dbo.State s ON ds.StateName = s.ObjectId AND s.Code IN ('VS','MD','TR','TD','AZ')
	where dh.Document =  [b]1 [/b]
	order by dh.[Date] desc
) sdh on sdh.Document = d.ObjectID