If you're trying to avoid doing a group (loop) from the cfoutput tag to create that atty_rank, in your view, you could create a table variable (with SQL Server), and populate with unique atty info and rank list (your coalesce column), then return from that table variable. Probably faster on the SQL side than on the CF side.
Cheers, Kris > OK - how to force only *one* unique ID per returned results? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
