That query was not functioning properly.

The below query is actually pulling back the proper data. However, when I use 'ALL' as my variable, it is running the query twice (the way I have my IF statement setup) any ideas on how to beat this?

Begin

declare @idnum varchar

select @idnum = 1

declare @TC varchar(50)

select @TC = 'BUY'

select B.GroupDetail, C.SecID, C.TransCode, C.Quantity, B.GroupId, C.PortfolioID

FROM ERTutTransactions C

INNER JOIN FinalGroupDetail B

ON C.PortfolioID = B.PortfolioID

AND B.GroupId = @idnum

WHERE TransCode = @TC

IF @TC = 'all'

BEGIN

select B.GroupDetail, C.SecID, C.TransCode, C.Quantity, B.GroupId, C.PortfolioID

FROM ERTutTransactions C

INNER JOIN FinalGroupDetail B

ON C.PortfolioID = B.PortfolioID

AND B.GroupId = @idnum

END

END