I usually say that I take a bunch of raw information from several sources and juggle with it and organize it to make it look nice to generate reports for...

dwain.c (1/17/2014)

---

I agree that you've done some very thorough testing here. Excellent work!

I wasn't sure how...

You could use a NOT EXISTS, but I don't understand the part of multiple results are you'll be getting a single resultset.

It would be nice if you shared DDL, sample...

And remember the first step towards the paradigm shift of writing Set Based code:

"Stop thinking about what you want to do to a row... think, instead, of what you...

I don't have the rules for the 'Replacement' option, but here's the code that should work for the query as you have it now.

UPDATE t SET

Product_Status = CASE WHEN EXISTS(...

This is an example of a replacement for all the code posted to use the cursor.

UPDATE t SET

Product_Status = 'Available'

FROM Outlet.tblProductMaster t

WHERE Product_Status IS NULL

AND NOT EXISTS( SELECT *

FROM Outlet.tblProductMaster...

I'll try to explain using your original code.

USE [OutletRetail]

GO

/****** Object: StoredProcedure [Outlet].[sp_UpdateProductStatus] Script Date: 01/16/2014 19:58:47 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

--Updates Product status codes to Available...

You can use the Updgrade Advisor to validate possible upgrades.

http://technet.microsoft.com/en-us/library/ms144256.aspx

http://www.microsoft.com/en-us/download/details.aspx?id=29065&ocid=aff-n-in-loc--pd (found at the bottom of the page)

Have you tried the OUTPUT clause?

You could create the scripts for the tables with the option to script indexes (and probably other dependent objects).

You can use the script in a Execute SQL Task at the...

Being pedantic, you can't use any ddl statements with a cte.

Without being pedantic and trying to be useful, I assume you want to say DML. However, ctes work only for...

To use a cursor, you basically need to use a while loop.

If you're assigning values to your variables inside the loopp using select statements, you might want to reinitialize your...

Wow, someone revived a 5 year old thread. :w00t:

And if you don't want to do all the formatting work yourself, you can use something like http://poorsql.com to give you a readable code.

With the import/export data wizard, you have the option to save the SSIS package for later use. That way, you can use it as it is or do any modifications...