Write conditional INNER JOIN in SQL Server Query

Vasanth

SOLVED CLOSED ACTIVE ANSWERED
User: Vasanth
Posted: on Jul 09, 2015 03:34 AM
Forum: SQL Server
Answer: 2
Views: 11311

I am having two tables and i am passing particular value. I need to put inner join based on that value. If the value is empty, no inner join else i need to perform inner join. I am not preferring dynamic query.

Kindly let me know is there any other way to achive this.

Thanks

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

Shubh4m

0 5

Reply
ANSWER
User: Shubh4m
Replied: on Jul 12, 2015 10:55 PM
Report

Dynamic SQL // :

DECLARE @Query1 varchar(max),@Query2 varchar(max), @Variable varchar(20),@Flag varchar(20)
SET @Variable = '''TEST'''
SET @Flag = 'asd'
SET @Query1 = 'SELECT * FROM DATA WHERE VOUCHERNO ='+@Variable
SET @Query2 = 'SELECT * FROM DATA D INNER JOIN MR000 M ON D.BookNo = M.MasterID WHERE VOUCHERNO ='+@Variable

BEGIN
IF(@Flag<>@Variable)
	BEGIN
		EXEC(@Query2)
	END
ELSE
	BEGIN 
		EXEC(@Query1)
	END
END

This Might Help!

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

Write conditional INNER JOIN in SQL Server Query

Company

Explore

Follow us

Contact Us