Viewing 15 posts - 1 through 15 (of 93 total)
Actually, there is a 6th book in the trilogy. "And Another Thing", written by Eoin Colfer.
From Wikipedia:
The Hitchhiker's Guide to the Galaxy
The first five novels in the Hitchhiker's "trilogy"...
April 2, 2015 at 5:53 am
Why all the complication with REPLACE(REVERSE(STUFF(REVERSE ...
I typically do this to get a comma separated list:
SELECT STUFF((SELECT ',' + name AS [data()]
FROM sys.columns
WHERE OBJECT_NAME(object_id) = @TableName
ORDER BY column_id
FOR XML PATH('')),...
March 30, 2015 at 5:53 am
Thank you Luis. That seems to do the trick, at least in a small test. Overnight will tell.
September 24, 2014 at 11:17 am
Now I'm really confused.
I'm testing this out in BIDS, right? Watch the appropriate boxes turning green. Start, then Task B, then LRT. Then BIDS says the package...
September 24, 2014 at 10:13 am
John Mitchell-245523 (9/24/2014)
I think you need to change the precedence constraint between C and D so that it evaluates to True on Success OR if @Variable = True (where @Variable...
September 24, 2014 at 9:34 am
I should mention: this is on 2008 R2. Also, the actual task flows are much more complicated, especially the right hand side. There are many more tasks and...
September 24, 2014 at 8:26 am
I would tell newcomers: Don't be afraid to ask for help. I've seen too many people (especially new graduates) struggling for what turned out to be days because they...
April 18, 2014 at 5:27 am
I would say that "it depends". Years ago I worked in product development environments, where the software had to be installed into the customers existing environment. So yes,...
March 6, 2014 at 6:19 am
BXRWXR (2/24/2014)
How is this different from plain old EXEC(@SomeSQLStatement)?BR
One big difference is that with sp_ExecuteSQL you can define parameters external to the @SomeSQLStatement variable, thereby reusing the dynamic sql with...
February 24, 2014 at 9:38 am
Jim P. (1/23/2014)
djackson 22568 (1/23/2014)
January 23, 2014 at 2:12 pm
Thanks guys. Cross Apply did the trick. I seem to have a block on that; it just never occurs to me to use Cross Apply.
Cheers,
Tom
January 23, 2014 at 7:18 am
I taught Introduction to Programming for a couple of semesters (evening, adult bachelors level). One of the things I emphasized was having well-commented code, but I would mark down...
January 21, 2014 at 6:11 am
Gary Varga (1/16/2014)
Luis Cazares (1/15/2014)
Tom Bakerman (1/15/2014)
Luis Cazares (1/15/2014)
In my experience, doing just enough to complete a job has resulted (most of the times) in errors that require extra work...
January 16, 2014 at 7:10 am
Thank you Craig, exactly what I was trying to say as well.
January 15, 2014 at 1:48 pm
Luis Cazares (1/15/2014)
In my experience, doing just enough to complete a job has resulted (most of the times) in errors that require extra work and more time invested than just...
January 15, 2014 at 10:53 am
Viewing 15 posts - 1 through 15 (of 93 total)