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 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 PROTECTED] > >Sent: Wednesday, January 17, 2007 12:11 PM >To: CF-Talk >Subject: Multiple DISTINCT > >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_assign_month) AS Month & >YEAR(recw_assign_month) AS Expr2as the DISTINCT values and not just >recw_assign_month. > >I have ... > >SELECT DISTINCT recw_assign_month, MONTH(recw_assign_month) AS Month, >YEAR(recw_assign_month) AS Expr2 >FROM dbo.tbl_recipe_monthly_winner >WHERE (recw_assign_month <> '') > >Thanks. > >D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266766 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4