View Single Post
 
Old October 27th, 2011, 03:14 PM
gfcb5624 gfcb5624 is offline
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2011
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Default

here is what I use and it works


Code:
Declare @IDProvider int = 123


Select * from TBL_Iso_Summary
where period_Month=9
and period_year=2011
and        (ID_Provider_Primary = @IDProvider OR (@IDProvider IS NULL OR @IDProvider = 0))
The Following User Says Thank You to gfcb5624 For This Useful Post: