Viewing 15 posts - 16 through 30 (of 851 total)
Interesting teaser; I'll be more interested to review the substance. Particularly in combination with patterns and also in relation to the MS BI stack.
July 17, 2013 at 2:32 am
All I can say to that is that it's a good thing that SQL isn't intended to be a parser, and thus we don't have to worry about handling CSV...
March 2, 2013 at 1:22 pm
rd8202 (3/1/2013)
Instead of the CTE, can't you just put the CTE's SELECT statement inside the WHERE clause?
You can do it that way; it's really just a syntactical change. There's...
March 1, 2013 at 1:52 pm
jimmyzimms (3/1/2013)
March 1, 2013 at 1:47 pm
jimmyzimms (3/1/2013)
March 1, 2013 at 10:37 am
Passing XML as the parameter is actually another good use-case for a similar technique, and I've done this where I was dealing with an object-level interface. In that way,...
March 1, 2013 at 10:31 am
The most common reason I use much the same approach (even to the point of using Jeff's code too) is in passing multi-value parameters from SQL Server reporting services into...
February 28, 2013 at 11:44 pm
Lynn Pettis (2/7/2013)
Better advice, yes, but hard to follow if the boss says you must use them.
declare @success bit;
exec CurriculumVitae_prepare;
while (1=1) begin
exec Job_Apply @isWhileRequired = 0,...
February 8, 2013 at 2:27 pm
TheSQLGuru (1/16/2013)
January 16, 2013 at 11:02 pm
paul.j.kemna (1/11/2013)
The original query was actually written in 2005 where the DATE data type did not exist.
Ah. I didn't spot that, since you posted in a SQL Server 2008...
January 11, 2013 at 2:04 pm
One possible reason why there are no rows going into the second table is that you have the multicast in the wrong place. The multicast needs to happen before...
January 11, 2013 at 12:25 pm
If all you are doing is copying the data from one instance to another, then I would agree that replication is probably a far better solution. It sounds to...
January 11, 2013 at 12:20 pm
Am I missing something? SQL Server 2008 has the "date" type; casting a datetime to date will remove the time component and then you can compare dates with dates,...
January 11, 2013 at 12:17 pm
Paul,
A great introduction to the topic, thank you. I'm curious: is there a follow-up planned?
Things I liked were that you related the process of the design to solving a...
January 11, 2013 at 12:06 pm
Stefan Krzywicki (1/11/2013)
krowley (1/11/2013)
I need to figure out how to setup my SQL Server Management Studio to do intelisense then.
It should work with the 2005, but maybe not with the...
January 11, 2013 at 11:59 am
Viewing 15 posts - 16 through 30 (of 851 total)