:-) wish i was on sql2K, but still on 7.0
Mike -----Original Message----- From: Lomvardias Christopher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 3:14 PM To: CF-Talk Subject: RE: string parsing or list traversal One option would to be use a UDF (SQL2K). http://www.sqlteam.com/item.asp?ItemID=11499 Chris -----Original Message----- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 2:52 PM To: CF-Talk Subject: string parsing or list traversal Does anyone know how to traverse a list of prse a string in T-SQL inside a stored procedure? What I need to do i send a comma delimited list into a stored proc then loop over the list inserting each entry into a table. Any help would be appreciated. Thanks, Michael T. Tangorre ---------------------------------------- MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 ---------------------------------------- Golden Rule: "He who has the gold, makes the rules!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4