You guessed it right.

I am already running a query and want to find the amount of time it will take to finish.

Thanks for the suggestions about logging at each step.

The...

Thanks. I'll try it out.

Dropping a database and creating a new one is an option. But, I was trying to avoid dropping the procedures and functions written for the database.

Performance of the table after deletion. I'll try out the index reorganizing and index rebuilding queries.

I am working on test databases, and I am frequently populating the tables and emptying...

yes it did work out... thanks Jack, Antonio for your help

i turned all string variables related to the dynamic query variable (@sql) to nvarchar(MAX) and i am getting the results....

did...

I think this is the problem...

i am trying to insert a few dates into the query. In the process I use this statement:

@sql = @sql +...

somewhat similar...

instead of executing

exec(@sql)

i am doing

print @sql

Also I printed out len(@sql) which returns me 4000

(@sql is declared as nvarchar(MAX))

Got it.

Thanks all. The explanation with AND/OR logic was a good one.

Made me feel completely stupid :hehe:

I did feel at the back of my mind that this question had something...

well there could be 10 rows with ID = 1 and another 10 rows with ID != 1

Thanks.

That was easy. Embarassing for me.

well that was pretty candid 🙂

i hope to see the feature in future..

thanks

Hey Lowell,

Thanks for the reply. That is very nicely explained. I have to try it out now.

Thanks again