Sorry I wasn't explicit enough. I may be off base here, but if I want to lookup the last X number of records based on their GUID or Identity, is...

I, too, am getting #Error when running my report. I'm trying to get the name of the month and year to display in my header. The year part...

Thanks Tommy, it works!! Now, what if I need to see results for more than one table by executing the temp sproc only once? i.e.

Exec #TSQL_Search...

Tommy,

Thanks for the headsup. However, in sql 2005, I executed the sproc as exec #TSQL_Search 'ReportProcessing' (ReportProcessing being the Db) where there are a bunch of sprocs but the...

Although I'm using MSSQL Server Mgmt Studio, I'm querying DB's in 2000 and 2005. Why?

I just tried to run the code but I'm getting error msg:

Msg 170, Level 15, State 1, Line 10

Line 10: Incorrect syntax near '('.

Msg 156, Level 15, State 1, Line...

yup, that was it. Beautiful. thx.

Thx,

Never heard of the SWITCH function but I'll give it a go.

BTW, what's BOL?

thx fellas.

I see where you're coming from, however, I'm still passing one result set into the report. As for the filters, I have two tables referencing the same dataset only...

Thans all for your knowledgeable suggestions. However since Jack's and Toolman's didn't work, and since my code is a complex stored proc that creates five temp tables within, I...

Thanks for the help. However I entered the expression exactly the way you worded it in the table properties/filter section, but when I try to run the report I get...

thx,

Now I need to convert getdate() as 2008-08-06 00:00:00

What's the best syntax I can use?

JOhn

And how would I do that? Meaning what modifications do I need to make to my code?

thx,

John

Thanks to both, I'll look into this.