Posted by Dinesh on 08/30/07 10:18

Hi experts,

I am working on SQL server 2005 reporting services and i am getting a
problem in writting a query.

Situation is given below.

There is one table in database Named Child

Now i have to find the All childrens whoes Age is 13 years Base on
Some given parameter.

If User select Augus 2007 then It has to calculate the Childs who born
in August 1994 And if he select September Then query

should show only those child Who born in September 1994 and so
on..... And use can select another year month also like

August 2009 ...


I am writting the following query

Select Child_Name, DOb from Child
where ((CONVERT(DateTime, A.Date_Of_Birth, 103) >= @ Parameter1
And (CONVERT(DateTime, A.Date_Of_Birth, 103) <= @Parameter2)

If i know already month and year then i can write easily parameter1
and parameter2 But since these are comming from user so i m not
finding how to handle this.


Now please suggest me what i have to write in Where statement I think
a lot but not getting any idea about it.



Any help wil be appriciated.

Regards
Dinesh

• Next in forum: Re: Help Needed For Date field (Age) Calculation In SQl query
• Prev in forum: Re: SET NO_BROWSETABLE ON ?
• Thread view: Help Needed For Date field (Age) Calculation In SQl query

[Reply to this message]