Kris Jones wrote: > Take a look at the CROSS APPLY operator in T-SQL. I don't have direct access to the database itself, so will need to do this in Coldfusion. Can't use "Cross Apply" there, right?
This has got me totally befuddled at this point, to be honest... Gotta be some goof ball query of queries to pull this off, but I've spent almost two days on it now and nothing is working for me yet... __________ Information from ESET NOD32 Antivirus, version of virus signature database 5329 (20100731) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
