Viewing 15 posts - 421 through 435 (of 479 total)
Of course, I suppose the real point of the question was to draw attention to the fact that (1) was wrong and (2) was inaccurate. But it would have been...
March 6, 2008 at 7:26 am
My personal gripe is the way the View Designer in SSMS crams as many fields as possible on one line (with arbitrary breaks) and puts the JOINs at the ends...
March 3, 2008 at 4:45 am
Thanks Steve.
For info, it was down at about 9:30am GMT (UK) Monday morning. Not sure what time this corresponds to wherever the server is (since it could be almost...
February 26, 2008 at 3:52 am
Adam Haines (2/19/2008)
DECLARE @IDString VARCHAR(MAX)
SET @IDString =
(SELECT (ID) + ','
FROM MYTABLE
--WHERE FILTER CAN GO HERE
FOR XML PATH(''))
This leaves a trail comma. I usually do something likeDECLARE @IDString VARCHAR(MAX)
SET @IDString...
February 22, 2008 at 6:17 am
February 19, 2008 at 3:40 am
I always reckon it's a good QotD if I learn something either from it or from the resulting discussion. In this case, I need to go off and look at...
February 14, 2008 at 8:54 am
Hi Tom
I agree and was mainly pointing out that the 'Transaction Data'/'Master Data' distinction is vague and arbitrary in many cases.
If you need to enter Line Items on a new...
February 14, 2008 at 2:43 am
Hi Christian
I agree that APPLY must be counted as part of the FROM clause, since it's the only place it can be used.
So I think the correct answer should have...
February 13, 2008 at 7:47 am
I think most people would agree that in alomost all systems that use them, 'Purchase Orders' are Transaction data rather than Master data, however, it's not difficult to come up...
February 13, 2008 at 7:11 am
Christian Buettner (2/13/2008)
Um, question:Shouldn't it be executing once per row in the FROM clause too?
Example:
SELECT * FROM dbo.MyTable T CROSS APPLY dbo.MyFunction(T.fielda)
Grazias!
I think in this context the CROSS APPLY clause...
February 13, 2008 at 5:13 am
jcrawf02 (2/6/2008)
Chris Morris (2/6/2008)
jcrawf02 (2/6/2008)
Because we just have to be different. I'm going to go get my 'twelve barley-corns, round and dried' to measure something now . . .
Nah,...
February 6, 2008 at 8:58 am
James A. Lawrence (2/5/2008)
or...Select convert(char(10),getdate(),101)
Of course I'd use convert(char(10),getdate(),103)...
Which raises a question I haven't found an answer to:
Why does America (and nowhere else) write dates in their traditional order, i.e....
February 6, 2008 at 2:56 am
Viewing 15 posts - 421 through 435 (of 479 total)