Change all the double-quotes to single quotes.. Silly books on line ....
WG > -----Original Message----- > From: Luce, Greg [mailto:[EMAIL PROTECTED]] > Sent: 27 November 2002 14:39 > To: CF-Talk > Subject: OT: T-SQL > > > I'm trying to learn to run T-SQL scripts in Query Analyzer like I can with > Oracle in SQL Plus. In the Books Online I found a nice example of a cursor > loop running a report against the pubs db. I paste this script into Query > Analyzer and hit go and get 5 different errors. Here's the script, you can > find it in books online with keyword "cursors, Transact-SQL": http://www.fusionauthority.com/ads.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
