Home Forums SQL Server 2008 T-SQL (SS2K8) Avoiding IF/ELSE RE: Avoiding IF/ELSE
elgatitto
Right there with Babe
Points: 756
More actions
November 15, 2012 at 11:36 pm
#1559628
You could think about something like this:
SELECT Comp.*
FROM #Companies AS Comp
LEFT JOIN #CompanyGroups AS Gr ON Comp.CompanyID = Gr.CompanyID
WHERE Comp.CompanyID = @CompanyID
OR GR.CompanyGroupID = @CompanyGroupID