Invalid SQL Syntax

  •  09-04-2007, 6:49 PM

    Invalid SQL Syntax

    I have a stored procedure called 'spD_DefectsByStateAndSeverity' which is defined as follows:

    CREATE PROCEDURE [dbo].[spD_DefectsByStateAndSeverity]
    (
        @ProjectID int = NULL
    )
    AS
    SELECT * FROM Defects

     When I try to create a custom report and enter the following SQL Command:

    spD_DefectsByStateAndSeverity @ProjectID = 437

    I get an error saying:

    "The SQL statement you entered is invalid."

     I don't understand how this could be invalid.  Any help would be great thanks in advance.
     

     

     

View Complete Thread

© 2002 - 2007, Axosoft, LLC. All Rights Reserved. | Privacy
Bug Tracking | Defect Tracking Videos | Help Desk Software