SQL Server Union Error: Incorrect syntax near the keyword Declare

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on May 05, 2020 06:00 AM
Forum: SQL Server
Answer: 1
Views: 5513

when i try i get this error Msg 156, Level 15, State 1, Line 9 Incorrect syntax near the keyword 'Declare'.

SELECT        Expressed, admno
FROM            dbo.Archivedreports
WHERE        (Class NOT LIKE N'PRE%')
GROUP BY Expressed, admno
HAVING        (Expressed IS NOT NULL)

union

declare  @type nvarchar(50)
Declare @TestVal nvarchar(50)
select @type=ExamType from ExamType where stream ='ALL'
SET @TestVal = @type

SELECT       @TestVal, admno
FROM            dbo.GENERALDATA
WHERE        (Class NOT LIKE N'PRE%')
GROUP BY @TestVal, admno
HAVING        (@TestVal IS NOT NULL)

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on May 05, 2020 06:07 AM
Report

Hi makumbi,

Write your DECLARE statement before the union query and remove the GROUP BY from second query.

Refer below query.

SQL

DECLARE @TestVal NVARCHAR(50)
SELECT @TestVal=ExamType FROM ExamType WHERE stream ='ALL'

SELECT        Expressed, admno
FROM            dbo.Archivedreports
WHERE        (Class NOT LIKE N'PRE%')
GROUP BY Expressed, admno
HAVING        (Expressed IS NOT NULL)
UNION
SELECT       @TestVal, admno
FROM            dbo.GENERALDATA
WHERE        (Class NOT LIKE N'PRE%')

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

SQL Server Union Error: Incorrect syntax near the keyword Declare

Company

Explore

Follow us

Contact Us