Viewing 15 posts - 19,291 through 19,305 (of 26,490 total)
Gianluca Sartori (8/11/2009)
SELECT *
FROM TableA
LEFT JOIN TableB
ON (TableA.ID1=TableB.ID1 AND TableA.ID2=TableB.ID2...
August 11, 2009 at 9:05 am
lnelson (8/11/2009)
Segment1 (nvarchar(50), null)
Segment2 (nvarchar(50),null)
national_identifier(nvarchar(50), null)
The actual data contained in these fields is typically numbers. The national identifier contains social...
August 11, 2009 at 8:47 am
mtassin (8/11/2009)
Lynn Pettis (8/10/2009)
mtassin (8/10/2009)
I'm sure she wasn't hinting at you. I am pretty sure I have an idea or two who she was thinking about as she wrote...
August 11, 2009 at 8:38 am
Paul White (8/10/2009)
GSquared (8/10/2009)
August 11, 2009 at 8:20 am
Can you explain what you are looking for or why it is important to do this?
August 10, 2009 at 4:36 pm
mtassin (8/10/2009)
GilaMonster (8/10/2009)
mtassin (8/10/2009)
And who determines who should be in the group? If it's forum ranking alone, there are several people (who shall remain unnamed) with over 1000 points and...
August 10, 2009 at 4:03 pm
Or something like this. Uploaded as an attachment as I am having problems posting it directly.
August 10, 2009 at 3:36 pm
Are you inserting a new row or updating the existing row (ie there is only one row in the table)?
August 10, 2009 at 2:56 pm
Totally different subject! I suddenly can't wait to get home tonight (not that I don't look forward to going home :-P)!
We just received some letters from Kassondra. Looking...
August 10, 2009 at 2:52 pm
WebTechie38 (8/10/2009)
I have a big database that needs to be backed up. The combination of the .mdf and the .ldf should be around 55 GB or so. The...
August 10, 2009 at 2:25 pm
timothyawiseman (8/10/2009)
Andy DBA (8/10/2009)
August 10, 2009 at 2:19 pm
John Paul (8/10/2009)
returns one row per Country Code with three porttypes import type columns
For each class the ports import...
August 10, 2009 at 2:05 pm
True, but we work with what we are given, wether here on SSC or at work. 😉
August 10, 2009 at 1:55 pm
jacroberts (8/10/2009)
Lynn Pettis (8/10/2009)
LP (8/10/2009)
jonwolds (8/10/2009)
Some points in this article no longer apply, some are mis-leading and some are just incorrect. Please read with caution.
Absolutely agreed. Very dangerous article espesially...
August 10, 2009 at 1:45 pm
Not only that, it looks like we could completely drop the #ProductDetail table, as it adds nothing to the query from what I can see.
August 10, 2009 at 1:39 pm
Viewing 15 posts - 19,291 through 19,305 (of 26,490 total)