Hi,

I was like you few years back some where in 2001. I was like working on SQL Server & Oracle at the same time. I started my career as Database...

Hi,

Check out the belwo link

http://mallier.blogspot.com/2006/10/generate-insert-statement-in-sql-server.html

Thanks -- Vj

Hi,

You need to have loop condition in some place. It would be better to move this loop condition to database side otherwise you will run in performance issues. There is...

Hi,

Couple of points on yout query:

1) The No.Of Outer joins you have very high.

2) You are using isnull operation this avoids usage of Index.

3) Dont have case statements in WHERE...

Hi,

As suggested in earlier posts drop/disable the index and try to delete the data. Instead of deleting all the records at one shot try deleting in small chunks of it....