Results 1 to 4 of 4

Thread: Problem In Cursor

Threaded View

  1. #1

    Thread Starter
    Just Married shakti5385's Avatar
    Join Date
    Mar 2006
    Location
    Udaipur,Rajasthan(INDIA)
    Posts
    3,747

    Question Problem In Cursor

    Hi all
    I am facing some problem in cursor.


    Code:
    ALTER PROCEDURE [dbo].[Product_Despatch_Return]
    @Search_Transaction_ID int,
    @Search_Product_Name nvarchar(50)
    AS
    BEGIN
    	SET NOCOUNT ON;
    	DECLARE 	@QueryString nvarchar(MAX)
    
    SET @QueryString='SELECT Product_Transction.Transaction_ID AS Transaction_ID, Product_Transction.Transaction_Date AS Transaction_Date,Product_Transaction_Details.Product_Id AS Product_Id, Product_Master.Product_Name AS Product_Name,Product_Transaction_Details.Qty AS OrderQuantity,Product_Transaction_Details.Details_Id AS Product_Transaction_Details_Id FROM Product_Transction INNER JOIN  Product_Transaction_Details ON Product_Transction.Transaction_ID = Product_Transaction_Details.Transaction_Id INNER JOIN  Product_Master ON Product_Transaction_Details.Product_Id = Product_Master.Product_ID WHERE Product_Transction.Is_Deleted=0 AND Product_Transaction_Details.Is_Deleted=0 '
    	-- CHECKING THE @Search_Transaction_ID
    	IF NOT (@Search_Transaction_ID=NULL OR @Search_Transaction_ID=0)
    	BEGIN
    		SET @QueryString=@QueryString+ ' Product_Transction.Transaction_ID='+CAST(@Search_Transaction_ID AS NVARCHAR)
    	END
    	-- CHECKING THE @Search_Product_Name
    	IF NOT (@Search_Product_Name=NULL OR @Search_Product_Name='')
    	BEGIN
    		SET @QueryString=@QueryString+ ' Product_Master.Product_Name='''+@Search_Product_Name+''''
    	END
    
    	DECLARE C CURSOR FOR @QueryString ' Error is Here
    	OPEN C
    I am facing error in the next line.
    DECLARE C CURSOR FOR @QueryString ' Error is Here
    Incorrect syntax near '@QueryString
    Last edited by shakti5385; Dec 20th, 2007 at 12:09 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width