Stored Procedure Help

[patelaashish]

Hi,

I have written the below stored procedure but whenever i try to execute it it comes up with the error:

Msg 170, Level 15, State 1, Procedure PAGE_COUNT, Line 10
Line 10: Incorrect syntax near ')'.


Stored Procedure is as follows:

CREATE PROCEDURE PAGE_COUNT
@BNAME NVARCHAR(50)
AS
BEGIN
----QUERY FOR THE TOTAL COUNT WITHOUT SEPARATOR
DECLARE @PAGECOUNT INT
SET @PAGECOUNT = (SELECT COUNT(IMGTABLE.BATCHID) FROM IMGTABLE WHERE (BATCHID = @BNAME))
----QUERY FOR THE SEPARATOR COUNT
DECLARE @SEPARATORCOUNT INT
SET @SEPARATORCOUNT = (SELECT COUNT(BARCODETABLE.BATCHID) FROM BARCODETABLE WHERE (BATCHID = @BNAME))

[srinit]

Hi,

I have written the below stored procedure but whenever i try to execute it it comes up with the error:

Msg 170, Level 15, State 1, Procedure PAGE_COUNT, Line 10
Line 10: Incorrect syntax near ')'.


Stored Procedure is as follows:

CREATE PROCEDURE PAGE_COUNT
@BNAME NVARCHAR(50)
AS
BEGIN
----QUERY FOR THE TOTAL COUNT WITHOUT SEPARATOR
DECLARE @PAGECOUNT INT
SET @PAGECOUNT = (SELECT COUNT(IMGTABLE.BATCHID) FROM IMGTABLE WHERE (BATCHID = @BNAME))
----QUERY FOR THE SEPARATOR COUNT
DECLARE @SEPARATORCOUNT INT
SET @SEPARATORCOUNT = (SELECT COUNT(BARCODETABLE.BATCHID) FROM BARCODETABLE WHERE (BATCHID = @BNAME))

Hi
Error is at select statement
Try like this
[code]
SELECT @PAGECOUNT =COUNT(IMGTABLE.BATCHID) FROM IMGTABLE WHERE (BATCHID = @BNAME))

[bharadwaj]

boss try this
CREATE PROCEDURE PAGE_COUNT

@BNAME NVARCHAR(50)
as
BEGIN
----QUERY FOR THE TOTAL COUNT WITHOUT SEPARATOR
DECLARE @PAGECOUNT INT
SET @PAGECOUNT = ( select COUNT(IMGTABLE.BATCHID) FROM IMGTABLE WHERE (BATCHID = 1))
----QUERY FOR THE SEPARATOR COUNT
DECLARE @SEPARATORCOUNT INT
SET @SEPARATORCOUNT=( select COUNT(BARCODETABLE.BATCHID) FROM BARCODETABLE WHERE (BATCHID = @BNAME))
end

[patelaashish]

thanks for the help.

It worked.