Try and have as good a WHERE clause as possible.

Keep us updated.

and what if the same thing happens again.

Dont mind my asking but is this a interview question ?

Hi

So where did u get the error from? As pointed out it looks like a network error.

Hi

What will the user do inside the procedure? Thats what you should look into and grant permissions accordingly.

You can consider using schemas. You can grant the user the rights to...

You are welcome

check this out

http://www.sommarskog.se/dyn-search-2005.html

SP_EXECUTESQL executes in a different session and not in the session where it is called. i.e. if proc xyz contains a SP_EXECUTESQL statement then this is not executed in...

Hi

For Pivot and Unpivot look up BOL and the web. There are numerous examples. They are slightly complex but only slightly.

For putting the output of your Pivot query to...

Scott do you mean to say DTS.

Hi

How do you want to update your data.

One way would be to pivot the data and send the output to a excel file. Users can update the excel file...

Hi... Anybody who can shed some light on this.

Is your db case sensitive. In that case you can check if your are passing the value 'y' in upper case or lower case.

tags almost made me choose the wrong option.