Viewing 15 posts - 6,226 through 6,240 (of 9,399 total)
crookj (4/17/2015)
Ed Wagner (4/17/2015)
SQLRNNR (4/17/2015)
Ed Wagner (4/17/2015)
BWFC (4/17/2015)
PronunciationArticulate
reticulated
Connected
Linked
In
April 17, 2015 at 11:00 am
SQLRNNR (4/17/2015)
Ed Wagner (4/17/2015)
BWFC (4/17/2015)
PronunciationArticulate
reticulated
Connected
April 17, 2015 at 8:11 am
Eirikur Eiriksson (4/16/2015)
Revenant (4/16/2015)
eccentricDBA (4/16/2015)
Eirikur Eiriksson (4/16/2015)
Ed Wagner (4/16/2015)
Eirikur Eiriksson (4/16/2015)
Ed Wagner (4/16/2015)
djj (4/16/2015)
Ed Wagner (4/16/2015)
CaterpillarTracktor
Construction
Build
Version
Conflict
resolution
New Year
Passed
Received
April 17, 2015 at 5:24 am
Eirikur Eiriksson (4/16/2015)
Ed Wagner (4/16/2015)
djj (4/16/2015)
Ed Wagner (4/16/2015)
CaterpillarTracktor
Construction
Build
Version
April 16, 2015 at 1:49 pm
djj (4/16/2015)
Ed Wagner (4/16/2015)
CaterpillarTracktor
Construction
April 16, 2015 at 12:51 pm
Correct. The WHERE clause in the OP said you wanted the rows where sname ended with a C. If you look at the rows in your sample table,...
April 16, 2015 at 6:52 am
That's no problem. Just take the query out of the function and place it in your stored procedure. Replace the @intRoot parameter with the hard-coded value 0 and...
April 16, 2015 at 6:38 am
There are several ways to go about solving this. Here's one that's an ITVF that uses a recursive CTE to pull the children of a parent with the path....
April 16, 2015 at 6:24 am
Nice question, Stewart. I don't generally like storing XML, but it's a cool concept.
April 16, 2015 at 5:45 am
Eirikur Eiriksson (4/15/2015)
Lynn Pettis (4/15/2015)
deprivedIaaS
Crippleware
April 16, 2015 at 5:28 am
This is a curious one. I'm wondering if the cursor is dynamic and the loop is contingent on the column being updated. Are there any triggers on the...
April 15, 2015 at 1:46 pm
whereisSQL? (4/15/2015)
crookj (4/15/2015)
Ed Wagner (4/15/2015)
SQLRNNR (4/15/2015)
Ed Wagner (4/15/2015)
Revenant (4/15/2015)
Eirikur Eiriksson (4/15/2015)
SQLRNNR (4/15/2015)
calumniateNOLOCK
Hint
Clue
colonel
Mustard (if I got the reference right)
Peacock
Feather
Duster
April 15, 2015 at 1:32 pm
Viewing 15 posts - 6,226 through 6,240 (of 9,399 total)