"Mike" <m_gorgone@hotmail.com> wrote in message
news:1194024856.270802.43090@50g2000hsm.googlegroups.com...
> Hi everyone I'm using Reporting Services and in my Dataset's Query I'm
> want to use a variable in my IN clause that that holds the different
> values (strings) but I can't seem to get it to work. I've posted the
> SQL statement as it currently is and what I tried to do to get it to
> work.
>
> Thanks for any help in advance.
>
> Mike
>
> Current Statemenet:
> SELECT NumOfPhotos.NumberOfPhotos
>
> FROM NumOfPhotos
> INNER JOIN vewStatsInnerSummary ON
> (vewStatsInnerSummary.Batch=NumOfPhotos.Batch AND
> vewStatsInnerSummary.PhotoSet=NumOfPhotos.PhotoSet)
>
> WHERE vewStatsInnerSummary.Batch=@Batch
> AND vewStatsInnerSummary.PhotoSet=@PhotoSet
> AND vewStatsInnerSummary.Photoset<>'99'
> AND DATEDIFF(day,@ReportBeginDate ,statsdate) >=0
> AND DATEDIFF(day,@ReportEndDate,statsdate) <=0
> GROUP BY NumberOfPhotos
>
>
> What I tried:
> SELECT NumOfPhotos.NumberOfPhotos
>
> FROM NumOfPhotos
> INNER JOIN vewStatsInnerSummary ON
> (vewStatsInnerSummary.Batch=NumOfPhotos.Batch AND
> vewStatsInnerSummary.PhotoSet=NumOfPhotos.PhotoSet)
>
> WHERE vewStatsInnerSummary.Batch=@Batch
> AND vewStatsInnerSummary.PhotoSet IN (@PhotoSet)
> AND vewStatsInnerSummary.Photoset<>'99'
> AND DATEDIFF(day,@ReportBeginDate ,statsdate) >=0
> AND DATEDIFF(day,@ReportEndDate,statsdate) <=0
> GROUP BY NumberOfPhotos
>