Viewing 15 posts - 5,956 through 5,970 (of 9,725 total)
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
Found the problem.
The mapping table has duplicate new product numbers. I didn't see it because there are so many new products, and so few dups. And the dups each have...
May 17, 2011 at 6:44 am
The problem is, we don't understand what you mean by N+1 JOIN conditions. Real life examples would help us give you the proper code. We're not asking about company data....
May 17, 2011 at 6:33 am
Viewing 15 posts - 5,956 through 5,970 (of 9,725 total)