[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