Viewing 15 posts - 4,291 through 4,305 (of 10,144 total)
Koen Verbeeck (7/24/2013)
jcrawf02 (7/24/2013)
Koen Verbeeck (7/23/2013)
Lowell (7/23/2013)
Koen Verbeeck (7/23/2013)
Didn't know this site censored some words.Hum. Whaddayaknow...
Oh man,so you've been added into the naughty list, then right?
Probably, if I wasn't already...
July 26, 2013 at 6:43 am
HowardW (7/26/2013)
This sounds like a Paul White kinda thing!...
Do we have to put on pointy hats, form a circle, and chant? That's ok, it's friday and I've already set Alice...
July 26, 2013 at 6:40 am
IT researcher (7/26/2013)
ChrisM@Work (7/23/2013)
-- why use CHARINDEX? You don't need the character position, you only need to know if
-- one string exists...
July 26, 2013 at 2:20 am
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
July 24, 2013 at 8:41 am
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason...
July 24, 2013 at 8:21 am
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason is -...
July 24, 2013 at 7:51 am
pwalter83 (7/24/2013)
ChrisM@Work (7/24/2013)
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
Hi,
The reason is - The same...
July 24, 2013 at 5:55 am
Lowell has already asked but the question remains unanswered: why do you want to hold the same data in two places at once?
July 24, 2013 at 5:41 am
DECLARE @listStr VARCHAR(MAX)
SELECT @listStr = COALESCE(@listStr+',' ,'') + Name
FROM (SELECT DISTINCT Name FROM Production.Product) d
FOR XML PATH is also worth a look.
July 24, 2013 at 5:15 am
matt_garretson (7/23/2013)
July 24, 2013 at 4:15 am
smarinova (7/23/2013)
It is faster than a cursor and it's simpler to implement. The cursor processes one row at a time.
using a quirky update in a function - what do...
July 24, 2013 at 3:02 am
jerome.morris (7/19/2013)
Ok Chris, I think I understand, but when I remove the simple data based on my table and use the real table it returns no results
Have you solved this...
July 23, 2013 at 7:51 am
There are small differences in the row counts of some of the tables - generally, the "SQL" version tables have more rows than the "PROC" version. Was the "SQL" version...
July 23, 2013 at 7:48 am
Rob-350472 (7/23/2013)
There's a couple of maxes but no tops in...
July 23, 2013 at 6:07 am
Erland Sommarskog (7/23/2013)
SET col = CASE WHEN b.cnt >= 1
...
July 23, 2013 at 6:06 am
Viewing 15 posts - 4,291 through 4,305 (of 10,144 total)