Viewing 15 posts - 7,156 through 7,170 (of 8,731 total)
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...
January 20, 2014 at 7:56 am
dwain.c (1/17/2014)
Dohsan (1/17/2014)
Dwain
Ándre, Ándre, Luís And O'Brien Had A Low-Budget 3D Printer In Washington D.C.
I wasn't sure how...
January 17, 2014 at 5:49 pm
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...
January 17, 2014 at 4:30 pm
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...
January 17, 2014 at 3:05 pm
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(...
January 17, 2014 at 2:27 pm
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...
January 17, 2014 at 2:03 pm
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...
January 17, 2014 at 1:46 pm
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)
January 17, 2014 at 1:32 pm
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...
January 17, 2014 at 1:07 pm
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...
January 17, 2014 at 1:03 pm
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...
January 17, 2014 at 12:52 pm
Wow, someone revived a 5 year old thread. :w00t:
January 17, 2014 at 11:17 am
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.
January 17, 2014 at 10:53 am
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...
January 17, 2014 at 10:26 am
Viewing 15 posts - 7,156 through 7,170 (of 8,731 total)