Viewing 15 posts - 31,786 through 31,800 (of 59,102 total)
patrickmcginnis59 (11/28/2011)
Jeff Moden (11/27/2011)
...There should only be one an only one column in common between the two and that should be the SalesOrderID...
In my experience, SQL Server doesn't enforce unique...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 11:47 am
Post withdrawn... Books Online was totally wrong about what would happen on something and I'm testing more on the subject of datatype precedence.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 11:10 am
Post withdrawn... Books Online was totally wrong about what would happen on something and I'm testing more on the subject of datatype precedence.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 10:35 am
Eric Niemiec (12/3/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 10:02 am
David Moutray (11/29/2011)
A CLR function, if practical, would probably be better.
Heh... "better" how? I don't believe it will be any faster than STUFF. Of course, my opinion isn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 9:50 am
Now all we need to know is the true reason why someone would want to do this especially since, as Michael Valentine Jones pointed out, the last row updated could...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 9:40 am
opc.three (11/30/2011)
Jeff Moden (11/29/2011)
opc.three (11/29/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 9:15 am
SQL_By_Chance (10/13/2011)
CREATE PROCEDURE EXAMPLE (@parameter)---- To illustrate how I intend to Use Execption Handling inside my Cursor
AS
BEGIN
BEGIN TRY
DECLARE @TABLENAME VARCHAR (10)
DECLARE DROPTABLE CURSOR
FOR SELECT...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 9:10 am
John Mitchell-245523 (12/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 9:02 am
dw.bi (12/1/2011)
For the tree in image(attached), assuming that the RED BLOCKS...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 4, 2011 at 8:55 am
hugo-939487 (12/2/2011)
Ik don't understand the BuildTestHierarchy stored procedure.
In my database I get the Employee table, but I don't see any column of type hierarchyid.
Do I have to do some...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2011 at 8:45 pm
Dev (12/3/2011)
Kit G (12/3/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2011 at 8:38 pm
Just a point of interest... Michael is correct. Anything you can do to stay away from character based conversions on these types of calculations will increase the performance of...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2011 at 7:50 pm
den_sidr (12/2/2011)
is it possible to map estimated plan (its parts) to currently running query?
for example i have a simple query has been running for 5 minutes...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2011 at 7:44 pm
Evil Kraig F (12/1/2011)
Ugh, nasty. You need a row-repeater. Which means... To the TALLY!
BWAAA-HAAA!!!! Beer popsicles... Dust Bunnies... nicely done Tally Table solutions... and a sense of...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2011 at 7:34 pm
Viewing 15 posts - 31,786 through 31,800 (of 59,102 total)