Viewing 15 posts - 6,121 through 6,135 (of 9,722 total)
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
Craig,
If you still need assistance, what's the problem with the problem number?
I'd go for the error table & email, if I had time to work it. But if you don't,...
April 7, 2011 at 5:29 am
Wow. I wonder if they had permissions to reprint that article. I found it yesterday at Simple Talk.
Or maybe it was the guy at Simple Talk who needed permissions:
http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/%5B/url%5D
Lowell:...
April 7, 2011 at 5:01 am
Stefan Krzywicki (4/6/2011)
Brandie Tarvin (4/6/2011)
Stefan Krzywicki (4/6/2011)
April 6, 2011 at 11:18 am
Viewing 15 posts - 6,121 through 6,135 (of 9,722 total)