I am glad it helped. The best is always try to keep away from Loops or Cursors. Set Based Operation is very powerful and flexible. If you have any condition...

You can do it with a single Set based operation. You can Update using alias. It can be something like this.

Update a

Set a.dept = b.department,

a.Employee_Status = b.EmployeeStatus_AIT,

a.EMP_Division = b.SortField,

a.Employee_First_Name =...

I would love to have my name on the internet so that prospective interviewers know that I am not just a BS guy. And that I know my stuff. But...

Thanks Anirban:). I tried. I did miss couple of things like others have pointed out. I have to keep in mind to cover all bases when I write my next...

Hi JJ, Thanks for the compliments. Maybe I could write it as a supplement of this article. I really did not think about it. Thanks for pointing it out.

You can do it easily by making the DB mode to Simple, then shrink the DB and bring it bac to full mode. If you have Log shipping set up,...

Are you sending emails using the Database itself or using an Application? If it is an application, You can do one single query that joins to the other table.

You...

On the contrary it helps the Acid property. As long as you get the right Data, you are doing good. You are actually getting the last committed data. From the...

Actually if the committed value was 0 and it is going to be updated to 10000000, then when you select the row, you will get 0.

You will get the...

Darn... At least is there a work around without me having to write an app that will connect to DB and then open a file and write it?

If you are setting this as a Job, you can just use the Tool itself to say to write to a file. In the Job Step Properties, there is an...

Writing to a file. Thats all.

It is a stored Proc that is being called from a SQL Job.

Thanks a lot Alin. This is my second one. My third article is coming out on April 7th. It is about Row Level Version in SQL 2005

Fixed it for now by doing an sp_recompile for the stored Proc. But it might still creeep up again. So any advice is appreciated.