Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Common table expression defined but not used.

Home
Forums
SQL

Common table expression defined but not used.

Akhter HUssain

Akhter HUssain

6yAsked Jun 9, 2020, 3:08 AM2.2kSQL

Getting following error

Msg 422, Level 16, State 4, Line 9

Common table expression defined but not used.

with vals
as
(
select I_QTY as Iss From tbl_Issuance where I_Type='Issue'
union all
select I_QTY as Ret1 From tbl_Issuance where I_Type='Return'
)
select Iss - Ret1 as difference

6 Replies

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

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Jignesh Kumar6y ago
Accepted answer
You can use this one if you want to use CTE else you cand without CTE direct
with vals
as
(
declare @Iss int, @Ret1 int
set @Iss = (select sum(I_QTY)  From tbl_Issuance where I_Type='Issue')

set @Ret1 =(select sum(I_QTY)  From tbl_Issuance where I_Type='Return')
select   @Iss as Iss, @Ret1 as Ret1
)

select Iss- Ret1 as difference from vals
+2
Akhter HUssain6y ago
Please have a look not executing
with vals
as
(
select I_QTY as Issue T From tbl_Issuance where Code='Issue'
union all
select I_QTY as Return  From tbl_Issuance where Code='Return'
)

select Issue - Return   as difference
Select * from vals;
0
Akhter HUssain6y ago
Yes
0
Jignesh Kumar6y ago
Select * from vals; But your query for union all also look different. I think you want difference of both issue type
0
Akhter HUssain6y ago
How it will use in select statement
0
Jignesh Kumar6y ago
You have created cte but you have not use in your select statement
0