Re: SQL Server Syntax - Converting this CF Code

2007-03-14 Thread Andrew Peterson
Thanks - let me try that - a lot cleaner than I thought it would be. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR

Re: SQL Server Syntax - Converting this CF Code

2007-03-14 Thread Jim Wright
Andrew Peterson wrote: > Hi, > > I'd like to see how this is done, even though it is not necessary and I like > my ColdFusion thank you very much. Can someone give me a general idea of how > this code would look in SQL Server? It takes literally 5 minutes to write in > CF; but for me to put it

SQL Server Syntax - Converting this CF Code

2007-03-14 Thread Andrew Peterson
Hi, I'd like to see how this is done, even though it is not necessary and I like my ColdFusion thank you very much. Can someone give me a general idea of how this code would look in SQL Server? It takes literally 5 minutes to write in CF; but for me to put it into a SQL Server stored procedure