Yes,I need all the columns to be Inserted into another Table Actually as a refresh.

The clusteredIndex column is EngineResponseResultID

There is an Non clustered Index on Respondeddatetime and another non clusteredIndex...

I actually Used all the columns names in the SELECT and also there is only Clustered Index on the table and I treied removing NOLOCK.I Checked the Execution Plan...

Thankyou.

There is still space in tempdb drive.

Out of 209Gb , 130Gb is still available.

But still we are getting below message.

Msg 1105, Level 17, State 2, Line 200

Could not allocate...

Your code was close to what I needed except for the eventstartdate need to be in date format(Not just year or month or quarter number)

BEGIN

...

This Looks very good.I did not use case statements.So,this is much simpler.Im going to try this one.Thankyou:)

I Understand.Anyway I could solve it. Thanks

#

Thankyou Both for replies but I think i Where 1= 0 is what I was looking for.

Thanks&Regards

Dennis

NO !!

Okie ,Got it.

Now I have better understanding of @@spid and Context_Info better than before

Thank you once again Lowell 🙂

Thank you so much

But I have a question(It might be dumb,I'm not sure. I'm a beginner)

but the @@spid here returns the sessionid of the storeprocedure???(I was thinking since the current...