Viewing 15 posts - 6,106 through 6,120 (of 9,715 total)
You probably didn't see my edited comment.
Check the Server / Instance's "remote query timeout" property. This can be found by right-clicking the server\instance name, navigating to Properties, the clicking on...
April 12, 2011 at 7:52 am
This .net application, is it making a Web Service call or is it a direct programmed connection string?
Is there a firewall between the PC this app runs on and the...
April 12, 2011 at 7:37 am
I think this cursor suits Stefan's needs best.
DECLARE OMG_NotAnotherCursor CURSOR GLOBAL_SCREAM BACKWARD_FACING
STATIC_THE_SUPERHERO PESSIMISTIC DB_LOCKDOWN
FOR
SELECT Superpower
FROM dbo.JusticeLeague
WHERE SupType = 'Lightning'
OPEN OMG_NotAnotherCursor
FETCH LAST FROM OMG_NotAnotherCursor
INTO @WhatsThisVariableForAgain
WHILE...
April 12, 2011 at 5:58 am
Stefan Krzywicki (4/11/2011)
GilaMonster (4/11/2011)
Stefan Krzywicki (4/11/2011)
Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing it to...
April 11, 2011 at 11:56 am
Peter Trast (4/11/2011)
Brandie Tarvin (4/11/2011)
Scope creep.(and, lemme tell you, Mr. Scope is definitely creepy. @=)
Is it possible to stop?
Sure it is. Just remove everyone's system access. Then they can't give...
April 11, 2011 at 11:35 am
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
Viewing 15 posts - 6,106 through 6,120 (of 9,715 total)