Viewing 15 posts - 2,626 through 2,640 (of 3,957 total)
ChrisM@Work (10/4/2012)
<snip>Heh nice one, Dwain! I know where you got this idea from 😉
Actually, I was going to post nearly exactly the same thing as yours but you beat me...
October 4, 2012 at 7:07 pm
This must be a side effect of:
EXEC sp_dbgofast
After all, if the Prod system doesn't have to wait for locks, then it must be running faster right?
Seriously, I have no idea....
October 4, 2012 at 6:32 pm
[wistfully]
If only you could make the SQL Server reach out and determine whether a file exists on the client.
[/wistfully]
October 4, 2012 at 6:26 pm
Here's another way:
WHERE LEN(LastName) - 1 = LEN(REPLACE(LastName, '/', ''))
October 4, 2012 at 6:21 pm
Eugene Elutin (10/4/2012)
dwain.c (10/4/2012)
...
This is kinda obscure too.
SELECT IDENTITY(INT,1,1) AS N
INTO #t
FROM (VALUES($),($),($),($),($),($),($),($),($),($))a(N)
CROSS JOIN (VALUES($),($),($),($),($),($),($),($),($),($))b(N);
There I go thinking about fortune and glory again! Well fortune anyway. 😛
No way you...
October 4, 2012 at 6:12 pm
Just goes to show that threads may die off in our memories but they live on forever in the heart of Google! 😛
October 4, 2012 at 6:11 pm
Eugene Elutin (10/4/2012)
ChrisM@Work (10/4/2012)
Eugene Elutin (10/4/2012)
ChrisM@Work (10/4/2012)
No undocumented vapourtables, no sort:
SELECT n = a.n+b.nFROM (VALUES(0),(10),(20),(30),(40),(50),(60),(70),(80),(90))b(n)
CROSS JOIN (VALUES(1),(2),(3),(4),(5),(6),(7),(8),(9),(10))a(n)
😉
No sort? I would suggest to add ORDER BY, otherwise order is not guaranteed,...
October 4, 2012 at 7:39 am
Jeff Moden (10/4/2012)
October 4, 2012 at 6:48 am
I had a bit of an epiphany today that I thought I would share. I figure, if Mr. Magoo can use tricks to speed up the solution, I can...
October 4, 2012 at 6:43 am
If it's a learning expedition you're on, try this:
SET DATEFORMAT DMY
DECLARE @ImportDate VARCHAR(8) = '10122012'
SELECT CAST(STUFF(STUFF(@ImportDate, 5, 0, '-'), 3, 0, '-') AS DATETIME)
,CAST(CAST(10000*(@ImportDate%10000) +
...
October 4, 2012 at 1:03 am
BTW. Did you try running this?
DECLARE @ImportDate VARCHAR(8) = '10122012'
SELECT CONVERT(VARCHAR(8),@ImportDate,112)
You'll notice absolutely no change to the string being converted. That's because it is already a VARCHAR(8), i.e.,...
October 4, 2012 at 12:45 am
Tava (10/4/2012)
the CAST(STUFF(STUFF syntax worked but trying to do it as a convert like if possible similar to how i currently have it.
It works but you don't want to use...
October 4, 2012 at 12:37 am
You can try something like this:
SET DATEFORMAT DMY
SELECT CAST(STUFF(STUFF('10122012', 5, 0, '-'), 3, 0, '-') AS DATETIME)
SET DATEFORMAT MDY
Replace the literal date with your ImportDate.
October 4, 2012 at 12:17 am
Jeff Moden (10/3/2012)
It's been fun to watch the permutations in this discussion. Thanks for the article and the followups, Dwain.
You might be interested to know I'm working on a...
October 3, 2012 at 9:10 pm
n00bDBA (10/3/2012)
i just found a Jon K script that im guessing.. no guessing it says it right there.. ill stop being blind!.. it throw out a very nice...
October 3, 2012 at 7:40 pm
Viewing 15 posts - 2,626 through 2,640 (of 3,957 total)