Advertisement

03.25.2008 at 02:14PM PDT, ID: 23268682
[x]
Attachment Details

SQL Server 2000 - Store Proc - Variables causing script to not run but with no errors.

Asked by RGraniero in MS SQL Server

Tags: Microsoft, MS SQL Server, 2000

I have a stored procedure that builds a select statement by using variable handed to it from a VB6 program. The procedure first uses the variables to pull summed money data into several other variables declared in the proc. Then it uses those variables to build a select statement that will return a recordset to be used by the VB6 program in a Crystal report. The variable causing the problem is used twice. In the first part where it is used in the Where clause for specific lines on an order is where the issue is. There is already an order number variable used it works fine until I add the line number variable. If I hard code the line numbers in, it works but when I plug the variable in it returns nothing. In the second part where the Select is built the variable works fine.  I have attached the entire SP. The variable is @RecNos. The order number and line or record numbers are both text.Start Free Trial
Attachments:
 
SQL script for the Stored Proc
 
[+][-]03.25.2008 at 02:33PM PDT, ID: 21206474

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]03.25.2008 at 02:59PM PDT, ID: 21206671

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.25.2008 at 03:31PM PDT, ID: 21206884

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]04.02.2008 at 07:01AM PDT, ID: 21263084

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: MS SQL Server
Tags: Microsoft, MS SQL Server, 2000
Sign Up Now!
Solution Provided By: RGraniero
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628