Viewing 15 posts - 33,751 through 33,765 (of 59,102 total)
PaulB-TheOneAndOnly (6/9/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2011 at 5:03 am
Animal Magic (6/9/2011)
Jeff Moden (6/9/2011)
An OPENROWSET through either JET or ACE drives will handle this automatically.
Thanks Jeff. ill take a look at that also.
I think i have managed to...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2011 at 4:56 am
PaulB-TheOneAndOnly (6/8/2011)
General structure should looks like:
SELECT
list-of-colums-to-be-returned
FROM
list-of-tables
WHERE
...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2011 at 4:30 am
ash0550 (6/8/2011)
I am a bit unsatisfied with the explanations provided in different tutorials.
Could some one...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2011 at 4:26 am
An OPENROWSET through either JET or ACE drives will handle this automatically.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2011 at 4:23 am
Elliott Whitlow (6/7/2011)
On most of my systems I disable xp_cmdshell...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 9, 2011 at 4:21 am
opc.three (6/8/2011)
Elliott Whitlow (6/7/2011)
On most of my systems I disable xp_cmdshell and don't allow its use..+1000
-1000 😉
Why all the FUD about xp_CmdShell? Done properly, it's an incredible tool.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 8, 2011 at 10:40 pm
rfr.ferrari (6/3/2011)
Jeff Moden (6/2/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 7, 2011 at 7:18 am
m_cg (6/6/2011)
DECLARE @date DATETIME, @number INT
SET @date = '2011-01-06 00:00:00'
SET...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 7, 2011 at 7:14 am
jmaloney-1117255 (5/31/2011)
Jeff Moden (1/1/2009)
gryphonsclaw (1/1/2009)
DECLARE @myVar varchar(MAX)
SET @myVar = ''
SELECT @myVar = @myVar + mycolumn + ' '
FROM...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2011 at 10:25 am
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll need...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2011 at 10:02 am
WayneS (6/4/2011)
Craig Farrell (6/4/2011)
If Jeff is willing to put his name on the line, something he considers quite valuable, to prove a point with numbers... it's worth listening to.
+1000.
+...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 5, 2011 at 9:56 am
Are you all set on this or do you still need help?
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2011 at 2:09 pm
Almost forgot... I love the idea of having the NextDay column in there because it makes it so easy to join on dates with times while still being SARGable in...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2011 at 1:25 pm
Knut Boehnert (8/16/2010)
Two things that made it only good for me is the "typical" fact that the date calculation works only for the US (and Canada). The other is...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 4, 2011 at 1:19 pm
Viewing 15 posts - 33,751 through 33,765 (of 59,102 total)