[thelist] Quick SQL Assistance...

Rob Smith rob.smith at lexjet.com
Fri Nov 17 08:26:43 CST 2006


I've got two columns of type INT: Month, and Year. 

i.e. 

Month          Year

1                     2005

2                     2006

3                     2006

4                     2007

5                     2007

 

I also have a start time parameter and an end time parameter. I need a
WHERE statement that combines the two columns as a datetime format so I
can invariably say:

 

Convert(datetime,([Month]/1/[Year])) BETWEEN @StartTime and @EndTime

 

Is there a way I can make the above happen?


Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236




More information about the thelist mailing list