if else in select Statement

[DanielT]

Hi guys, I am new here. I need to put the below if else condition in select statement, is it possible?

if task_is_trunk = 1
(select branch_name from dbo.tblBranch where task_location_g uid = dbo.tblBranch.b ranch_guid) as location_name
else
(select location_id from dbo.tblCSLocati on where location_guid = dbo.tblCSTask.t ask_location_gu id) as location_name

Thanks!

[ck9663]

Your query might return multiple result sets. What are you trying to do with this code?

-- CK

[Bassem]

I think this would work "correctly" .
(select branch_name from dbo.tblBranch where task_location_g uid = dbo.tblBranch.b ranch_guid AND task_is_trunk = 1) as location_name
Union
(select location_id from dbo.tblCSLocati on where location_guid = dbo.tblCSTask.t ask_location_gu id AND task_is_trunk <> 1) as location_name

[DanielT]

thx for ur reply guys, I solved the problem by joining all those tables, and query as below

SELECT 	'location_name' = CASE
					WHEN t.task_is_trunk = 1 THEN
						dbo.tblbranch.branch_name
					ELSE
						dbo.tblCSLocation.location_id
					END