what syntax can I use for "cd.PlanID = (('0549'),('0545'))". I want this 2 plans data only.

[sandy_xpac]

from reports.dbo.Datamart_ClaimDetails cd LEFT OUTER JOIN
Reports.dbo.vwPlan as pd on cd.PlanID=pd.PlanID
where apptdate between '07/01/2016' and '4/30/2017'
and cd.PlanID = (('0549'),('0545'))


It gives me a syntax error at cd.planID= (('0549'),('0545'))

 

[Greg Truby]

Heaven knows I'm not a SQL guru, but wouldn't you want:

[COLOR=#333333]from reports.dbo.Datamart_ClaimDetails cd LEFT OUTER JOIN[/COLOR]
[COLOR=#333333]Reports.dbo.vwPlan as pd on cd.PlanID=pd.PlanID[/COLOR]
[COLOR=#333333]where apptdate between '07/01/2016' and '4/30/2017'[/COLOR]
[COLOR=#333333]and (cd.PlanID = '0549' or cd.PlanID = '0545')[/COLOR]

or

[COLOR=#333333]from reports.dbo.Datamart_ClaimDetails cd LEFT OUTER JOIN[/COLOR]
[COLOR=#333333]Reports.dbo.vwPlan as pd on cd.PlanID=pd.PlanID[/COLOR]
[COLOR=#333333]where apptdate between '07/01/2016' and '4/30/2017'[/COLOR]
[COLOR=#333333]and cd.PlanID IN ('0549','0545')[/COLOR]

 

[sandy_xpac]

Heaven knows I'm not a SQL guru, but wouldn't you want:

[COLOR=#333333]from reports.dbo.Datamart_ClaimDetails cd LEFT OUTER JOIN[/COLOR]
[COLOR=#333333]Reports.dbo.vwPlan as pd on cd.PlanID=pd.PlanID[/COLOR]
[COLOR=#333333]where apptdate between '07/01/2016' and '4/30/2017'[/COLOR]
[COLOR=#333333]and (cd.PlanID = '0549' or cd.PlanID = '0545')[/COLOR]

or

[COLOR=#333333]from reports.dbo.Datamart_ClaimDetails cd LEFT OUTER JOIN[/COLOR]
[COLOR=#333333]Reports.dbo.vwPlan as pd on cd.PlanID=pd.PlanID[/COLOR]
[COLOR=#333333]where apptdate between '07/01/2016' and '4/30/2017'[/COLOR]
[COLOR=#333333]and cd.PlanID IN ('0549','0545')[/COLOR]

Hi Greg,

I tried the first code yesterday and it do not pull all the data BUT 2nd code works perfectly. Cheers mate

Thank you!