RE: OT - MS SQL help

This was asked a few weeks ago on the SQL list ... here is the thread ... http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=256 &forumid=6&refresh=0 Dan -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2

Re: OT - MS SQL help

You could do it in SQL Server with a stored procedure and a cursor, although all things considered, it's probably faster and easier to do it in cf... I've thought about or wanted to do this myself on a number of occasions, but never been able to find a way to do it that wasn't way more effort than

RE: OT - MS SQL help

Ahh... so I was wrong... :) there's COALLESCE() in SQL Server and apparently somebody created a function to do it in Oracle... awesome... wonder if it merits changes to my cms data structure... > This was asked a few weeks ago on the SQL list ... here is the thread ... > http://www.houseoffusion