Viewing 15 posts - 6,121 through 6,135 (of 9,725 total)
Scope creep.
(and, lemme tell you, Mr. Scope is definitely creepy. @=)
April 11, 2011 at 11:09 am
Steve Jones - SSC Editor (4/11/2011)
Happy Monday. :hehe:
HA! As if.
Cluster down again. Much scrambling to get things working before the BU showed up.
Does it count as murder if...
April 11, 2011 at 10:41 am
That's what I figured. But fortunately, that's not a problem for me today.
April 11, 2011 at 8:58 am
Jeff Moden (4/7/2011)
Brandie Tarvin (4/7/2011)
April 8, 2011 at 12:10 pm
My only issue with sorting was making sure I didn't have two copies of the same record with the errors flipped (Ship Date; Sale Date vs Sale Date; Ship Date)....
April 7, 2011 at 11:11 am
Update from the front. I have replaced my multiple inserts with an UNPIVOT. Rather than compare 15 different columns as listed above, I've done the following:
ALTER TABLE DT.Staging
ADD...
April 7, 2011 at 9:27 am
I got my parents copies of The Shadow radio show for their anniversary many years back. They loved it. It was one of those things they'd listen to when they...
April 7, 2011 at 8:27 am
Jeff, He's questioning opc.three's script solution (not Lowell's XML solution).
April 7, 2011 at 8:25 am
opc.three (4/7/2011)
Brandie Tarvin (4/7/2011)
Or maybe it was the guy at Simple Talk...
April 7, 2011 at 8:17 am
Okay, so repeating what I have...
CREATE TABLE dbo.#TempErrors (DocID int, FieldType varchar(20), ErrorDetail varchar(400));
GO
INSERT INTO dbo.#TempErrors (DocID, FieldType)
SELECT DocID, 'DocumentNumber'
FROM MyStagingTable
WHERE 'DocumentNumber'IS NULL OR 'DocumentNumber'='';
/* repeat ad naseum for...
April 7, 2011 at 8:16 am
Stefan Krzywicki (4/7/2011)
Brandie Tarvin (4/7/2011)
Turning attention to a different media... Anyone remember Captain Carrot and the Zoo Crew?
Absolutely, that first series was great. I like that they still get occasionally...
April 7, 2011 at 8:01 am
Oh, duh. You're right and Lowell's right, of course. And that works so much better then the other stuff I've come up with.
Sorry, guys. Don't mean to be difficult. I'm...
April 7, 2011 at 7:49 am
Turning attention to a different media... Anyone remember Captain Carrot and the Zoo Crew?
April 7, 2011 at 7:39 am
Lowell (4/7/2011)
April 7, 2011 at 6:20 am
Stupid question. Does COALESCE *have* to use a variable in order to work correctly?
I'm trying a basic SELECT statement where I've replaced the variable with the column name. It's not...
April 7, 2011 at 5:46 am
Viewing 15 posts - 6,121 through 6,135 (of 9,725 total)