I don't have any data to try this with, but you may also try this approach: 

SELECT topics.topic_id, topics.topic_title, posts.post_time

FROM tbl_topics topics

   INNER JOIN( SELECT DISTINCT TOP 5 tbl_posts.topic_id,...

Is this what you want?

DECLARE @t TABLE( Field1 varchar(10))

INSERT INTO @t VALUES( 'Admit')

SELECT * FROM @t

Yeah, but there are like thousands, so I was hoping for some internal function, (quick and dirty select, you know?).  Short of something nice like that, I may have to...

My initial reaction is two-fold.  One, are you jumping between databases?  Two, is the BETWEEN @Date + '00:00:00' working? 

What error are you getting? 

SELECT @t will give you a result. 

SELECT * FROM @t is treating @t as a Table Variable...

Thanks, but it errored. 

Server: Msg 1540, Level 16, State 1, Line 1

Cannot sort a row of size 8098, which is greater than the allowable maximum of 8094.

I can do...

Me too.  (Generally when I have used CHARINDEX, I subtract one for replacement or parsing...) 

Have you tried including the no_output parameter?

xp_cmdshell {'command_string'} [, no_output]

Not the best solution, but should work. 

(Thanks sue)

Glad to help.  I did not know your tables, so I just had to wing what I saw. 

Here is a possible way to do it dynamically so you do not have to hardcode the Project Code: 

(chances are good you can do this more efficiently through an...

I had to re-write this so I could understand it a bit better.  I believe your change is superior and accomplishes the same thing.  Basically, you use a direct join...

I am hoping you have some knowledge of the datatypes that could be passed in. 

Use IF statements with the various "IS" functions, (ISDATE, ISNUMERIC, ISNULL...) to test and you...

That's true too.  If that table has a "most recent date", (or something like that) you can do it as an INNER JOIN( SELECT Address, MAX( RecentDate) FROM EmployeeAddress GROUP...

Take u3.CHECKDATE out of your GROUP BY