Viewing 15 posts - 5,956 through 5,970 (of 9,715 total)
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
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
Viewing 15 posts - 5,956 through 5,970 (of 9,715 total)