Viewing 15 posts - 5,956 through 5,970 (of 9,712 total)
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
Jack Corbett (5/16/2011)
May 16, 2011 at 12:10 pm
Stefan Krzywicki (5/16/2011)
Brandie Tarvin (5/16/2011)
Stefan Krzywicki (5/16/2011)
SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for...
May 16, 2011 at 11:41 am
GilaMonster (5/16/2011)
Brandie Tarvin (5/16/2011)
Ray K (5/16/2011)
When I tried calling the SP, I got the 'Must declare the scalar variable "@Result".' message.
Declare @Result int;
Execute TestProc 'ID','Email', @Result output;
That's how you call...
May 16, 2011 at 11:37 am
Peter Trast (5/16/2011)
Brandie Tarvin (5/16/2011)
crookj (5/16/2011)
Ray K (5/16/2011)
WOTD: Rainy day and Monday"Always get me down...."
GAH!
Is that a word?
No, just a horrible song... some 70's music is best forgotten. Hey, I...
May 16, 2011 at 11:28 am
Stefan Krzywicki (5/16/2011)
SQL Server's not even mentioned, I guess we have a way to go in being considered suitable for very large databases. A...
May 16, 2011 at 11:26 am
Ray K (5/16/2011)
Brandie Tarvin (5/16/2011)
Ray K (5/16/2011)
Brandie Tarvin (5/16/2011)
What's going on with the @Plist thing? Why do you have that in the final execute?
Mainly force of habit -- I copy/pasted...
May 16, 2011 at 11:08 am
Ray K (5/16/2011)
Brandie Tarvin (5/16/2011)
What's going on with the @Plist thing? Why do you have that in the final execute?
Mainly force of habit -- I copy/pasted from some other code...
May 16, 2011 at 11:03 am
Ray K (5/16/2011)
When I tried calling the SP, I got the 'Must declare the scalar variable "@Result".' message.
Declare @Result int;
Execute TestProc 'ID','Email', @Result output;
That's how you call an output variable....
May 16, 2011 at 10:54 am
You might want to check the difference between your actual code and your posted code.
I've done that before. Changed my code to post on the forums and, in the...
May 16, 2011 at 10:42 am
Steve Jones - SSC Editor (5/16/2011)
We're trying to get the Rally here in Denver, so maybe we'll get some of you to come way out west 😉
Oh, I would definitely...
May 16, 2011 at 10:38 am
crookj (5/16/2011)
Ray K (5/16/2011)
WOTD: Rainy day and Monday"Always get me down...."
GAH!
Is that a word?
May 16, 2011 at 7:39 am
Ninja's_RGR'us (5/13/2011)
SanDroid (5/13/2011)
Ninja's_RGR'us (5/13/2011)
SanDroid (5/13/2011)
May 13, 2011 at 12:01 pm
Paul Randal (5/13/2011)
May 13, 2011 at 11:15 am
Viewing 15 posts - 5,956 through 5,970 (of 9,712 total)