yup .

select * from with (nolock) inner join dbo.cataddon_reportquery with (nolock) on cataddon_reportquery.userid = .loginname

I told steve about this and got an answer back that they were working on it...

Maybe the title "Execute the Output of a stored proc" threw you off .

At any rate, the only to fight this fire is with...

Nice to see you back here Frank .

You didn't remember that post from raj's thread??

It's a good thing that my name is also ray because I posted the exact same comment 20 mins before him.

Let me rephrase that. Won't allow the server to use an index SEEK.

Here's a full demo of such a task.

The other option would be to use something like a cursor or a while loop.

IF object_id('Data') > 0

DROP TABLE dbo.Data

GO

IF object_id('Target') >...

Can you post some sample data and the required output... will be hard to answer without that.

Yes there is :

dateadd(D, 0, datediff(d, 0, getdate()))

also don't use a function on a column on a where condition. You don't allow any indexes to be used in...

update tablename set fieldname = replace(replace(fieldname, '-', ''), '-', '')

What's the datatpye of the column?

select * from table1 where date >= '08-09-2005' and date < '09-09-2005'

It might very well be that, but I didn't keep the original code so it's hard to pinpoint the problem after the fact. But thanx again for the info.