Incorrect Syntax near )

Ramco Ramco

In below code i am getting Incorrect Synatx near ) - +'''')'

set @query = 'select [BookId] [Book ID],BookTitle [Book],[ClosingStock], ' + @cols + ' from (select [BookID] ,BookTitle,
,(select closingstock from [View_Summary] where BookId = ''' + @BookID +'''')' from View_Calculate where (('''+@BookID+'''=''0'' OR [BookId] IN('+ cast(@BookID as varchar(Max))+')))) x pivot
( Max(Status) for StudentName in (' + @cols + ')) piv order by B';

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty3y ago

Try this

set @query = 'select [BookId] [Book ID],BookTitle [Book],[ClosingStock], ' + @cols + ' from (select [BookID] ,BookTitle,
(select closingstock from [View_Summary] where BookId = ''' + @BookID +''') from View_Calculate 
where (('''+@BookID+'''=''0'' OR [BookId] IN('+ cast(@BookID as varchar(Max))+')))) x pivot
( Max(Status) for StudentName in (' + @cols + ')) piv order by BookId';

Sachin Singh3y ago

Test this

set @query = 'select [BookId] [Book ID],BookTitle [Book],[ClosingStock], ' + @cols + ' from (select [BookID] ,BookTitle,(select closingstock from [View_Summary] where BookId = ' + @BookID +')'' from View_Calculate where (('''+@BookID+'''=''0'' OR [BookId] IN('+ cast(@BookID as varchar(Max))+')))) x pivot
( Max(Status) for StudentName in (' + @cols + ')) piv order by B';