Viewing 15 posts - 5,941 through 5,955 (of 9,712 total)
LutzM (5/18/2011)
GSquared (5/18/2011)
I put in the non-repeat bit because of the way Steve wrote his original Where clause. I just moved it into the Joins.
Gus: If this concept is...
May 18, 2011 at 12:49 pm
I don't see what's wrong with allowing matching since the question was "all possible combinations". <- EDIT: I believe it was the original question in the thread Steve referenced.
However, if...
May 18, 2011 at 12:36 pm
Boys, you should be ashamed of yourselves. Jeff Moden gave us a better way.
DECLARE @MaxTally int;
SELECT @MaxTally = Max(ID) FROM dbo.Combinations;
SELECT c.ID, t.N AS TallyID
FROM dbo.Combinations c
CROSS JOIN dbo.Tally t
WHERE...
May 18, 2011 at 11:21 am
Steve,
I actually have a table in an analytics database where I had to set something like this up, but the numbers are so small that I just entered them into...
May 18, 2011 at 11:09 am
Ray K (5/18/2011)
bcsims 90437 (5/17/2011)
May 18, 2011 at 11:01 am
Jim Murphy (5/17/2011)
Koen Verbeeck (5/17/2011)
And now I've reached the 5000-points milestone.W00t w00t! :w00t: 😎 :hehe:
Ahem.... Back to the tasks at hand... 😀
Excellent! Good job helping the community.
Wait. We're supposed...
May 18, 2011 at 4:56 am
jcrawf02 (5/17/2011)
May 17, 2011 at 12:52 pm
SQLRNNR (5/17/2011)
Ray K (5/17/2011)
bcsims 90437 (5/17/2011)
Daniel Bowlin (5/17/2011)
SQLRNNR (5/17/2011)
crookj (5/17/2011)
SQLRNNR (5/17/2011)
stickShift
clutch
hitter
pinch
Hmmm, should I spend $60 to take me and my dog to the Dodgers game on Bark in the Park...
May 17, 2011 at 11:20 am
Stefan,
I've actually had to do that at my work place. If those solutions don't work for some reason, let us know and I'll check my production environment to see what...
May 17, 2011 at 11:13 am
It also depends on how you have your environment set up. You can find it in Tools-> Options. I use "Open Empty Environment" so I don't have to log into...
May 17, 2011 at 11:00 am
reido70 (5/17/2011)
I dont know if stopping short of destroying the windows cluster and rebuilding it if there is a work around?
So far as I know, you can't go back without...
May 17, 2011 at 10:47 am
SQL Server 2008 Replication
If you're looking to upgrade, it comes free with SQL Server 2008.
May 17, 2011 at 10:42 am
Thanks, diamond, but I'm not enough of a geek to be able to easily translate that. Any chance you could explain what you just said using English examples?
May 17, 2011 at 7:08 am
Thank you, Ninja. I appreciate the new info. I will definitely dig around.
May 17, 2011 at 7:04 am
Oh, learning time.
I've never heard the phrase "untrusted constraint." Please explain.
May 17, 2011 at 6:56 am
Viewing 15 posts - 5,941 through 5,955 (of 9,712 total)