Viewing 15 posts - 3,571 through 3,585 (of 3,957 total)
GSquared (5/17/2012)
Considering that you need to do two actions if you get a match (create new and cancel old), Merge isn't the right solution.
It is quite awkward that you cannot...
May 17, 2012 at 7:03 pm
dwain.c (5/17/2012)
An example would be a grocer who wishes to assemble for sale gift baskets consisting of various combinations of items that fall within a total cost range (so that...
May 17, 2012 at 6:46 pm
Mark-101232 (5/17/2012)
SELECT CASE WHEN n1.strcol IS NULL THEN 0 ELSE 1 END +
CASE WHEN...
May 17, 2012 at 6:28 pm
Jeff Moden (5/17/2012)
SQL Kiwi (5/17/2012)
Jeff Moden (5/17/2012)
Heh... I have the proof. I just haven't posted it. Time for someone else to prove it besides me. 🙂
Well that doesn't...
May 17, 2012 at 6:26 pm
SQL Kiwi (5/17/2012)
Jeff Moden (5/17/2012)
Shifting gears, just changing it to a While Loop using the exact same logic will make it more efficient.
It's not like you to make such a...
May 17, 2012 at 6:24 pm
sturner (5/17/2012)
"SET @sql = 'KILL @@SPID'EXEC (@SQL)"
Killing ones self is a depressing solution.
Ah yes, but suicide by SP is less depressing than say jumping off a building.
Perhaps there's another...
May 17, 2012 at 8:19 am
Jesse McLain (5/17/2012)
Jesse McLain (5/17/2012)
chris.stuart (5/17/2012)
I always enjoy reading the articles, but this one got me a bit stumped. Where would you actually use this?:unsure:
I used this method in an...
May 17, 2012 at 8:14 am
Jeff Moden (5/17/2012)
dwain.c (5/17/2012)
I get it! Change RBAR in your avatar to Dwain.C and there you have it.
Heh... considering the tagline in your signature, I do have to question...
May 17, 2012 at 8:11 am
Jeff Moden (5/17/2012)
dwain.c (5/17/2012)
May 17, 2012 at 8:06 am
Jesse McLain (5/17/2012)
chris.stuart (5/17/2012)
I always enjoy reading the articles, but this one got me a bit stumped. Where would you actually use this?:unsure:
I used this method in an algorithm to...
May 17, 2012 at 7:27 am
Jeff Moden (5/17/2012)
SQL Kiwi (5/17/2012)
It still seems that your issues are more with the author (and Craig Freedman) rather than me.
... apologies but you weren't meant to be the target...
May 17, 2012 at 7:16 am
grecci1077 (5/17/2012)
May 17, 2012 at 7:09 am
Grant Fritchey (5/17/2012)
Security of their systems, not the ones being built would be why you wouldn't want to give people permission to create stored procs. Still weird.
I've dealt with at...
May 17, 2012 at 7:07 am
Jan Van der Eecken (5/17/2012)
dwain.c (5/17/2012)
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE dbo.Test...
May 17, 2012 at 7:04 am
chris.stuart (5/17/2012)
I always enjoy reading the articles, but this one got me a bit stumped. Where would you actually use this?:unsure:
Oh my! So it's practical that you seek.
In my...
May 17, 2012 at 7:00 am
Viewing 15 posts - 3,571 through 3,585 (of 3,957 total)