Thread
:
SQL Select All Items where one meets the criteria
View Single Post
#
4
(
permalink
)
05-10-2008, 03:12 PM
Plamen Ratchev
Posts: n/a
Re: SQL Select All Items where one meets the criteria
Add one more condition to the main WHERE clause to return only the correct
years:
WHERE G.fiscal_year >= @FiscalYear
AND EXISTS(...
HTH,
Plamen Ratchev
http://www.SQLStudio.com
Plamen Ratchev