[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. 


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
rob.smith at lexjet.com
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

More information about the thelist mailing list