selecting a date range using query

rekhasc

hi friends..

i am using sql server 2005 reporting services..
in database the table contains startdate row and enddate row...
i want the query which display all the contents between these dates... when i externaly pass the startdate and enddate

SELECT *

FROM tmpFilePendStatPost
Where seccd=@seccd
GROUP BY
HAVING (fromdate = CONVERT(smalldatetime, @stdt, 103) AND todate=CONVERT(smalldatetime, @enddt, 103))

but the above query will give only that date contents.... it doesnot display the contents which is present b/w these dates...
how to do this plz help me...

Sep 9 '08 #1

ck9663

Use WHERE instead of HAVING

WHERE fromdate = CONVERT(smalldatetime, @stdt, 103) AND todate=CONVERT(smalldatetime, @enddt, 103)
GROUP BY.....

-- CK

Sep 9 '08 #2

rekhasc

Use WHERE instead of HAVING

WHERE fromdate = CONVERT(smalldatetime, @stdt, 103) AND todate=CONVERT(smalldatetime, @enddt, 103)
GROUP BY.....

-- CK

but it ll display only that particular fromdate and todate reports, but i want the reports from that start date to enddate, i.e it should display the reports b/w these dates including the start and end date

Sep 10 '08 #3

ck9663

use >= (greater than or equal)

-- CK

Sep 10 '08 #4

rekhasc

use >= (greater than or equal)

Expand|Select|Wrap|Line Numbers

1. WHERE fromdate >= CONVERT(smalldatetime, @stdt, 103) AND todate <= CONVERT(smalldatetime, @enddt, 103)
2. GROUP BY.....

-- CK

Thank you very much for u r reply.. its working

Sep 11 '08 #5