Re: Multiple DISTINCT

you really should alias those columns to something else. both 'Month' and 'Year' are built in functions in CF and as such, are reserved words. On 1/17/07, coldfusion. developer @ att. net coldfusion. developer @ att. net <[EMAIL PROTECTED]> wrote: > Your comments gave me the answer I was looking

Re: Multiple DISTINCT

Your comments gave me the answer I was looking for! Thank you so much! It just needed to be changed to ... SELECT DISTINCT MONTH(recw_assign_month) AS month, YEAR(recw_assign_month) AS year FROM dbo.tbl_recipe_monthly_winner WHERE (recw_assign_month <> '') >I am confused... Is tha

RE: Multiple DISTINCT

I am confused... Is that not working? Or are you asking if it is a good idea? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECT

Re: Multiple DISTINCT

[EMAIL PROTECTED] wrote: > I'm so sorry, but this is my favorite forum and they are so many sharp people > out here and I know I can get a quick answer to what shoud be a sql question. > I want to pass two values to distinct in a query. How do I do that? > > I want to pass both MONTH(recw_assi