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
:-)
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
http://www.showstopperonline.com
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 3:23 PM
To: CF-Talk
Subject: RE: string parsing or list traversal
:-)
wish i was on sql2K, but still on 7.0
Mike
-Original Message-
From
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
Yep...
I think this is exactly what you are looking for:
http://www.sqlteam.com/item.asp?ItemID=256
Eric Dobris
-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
, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 3:42 PM
To: CF-Talk
Subject: RE: string parsing or list traversal
I don't see why you'd have any problems doing this:
Try something
:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 3:01 PM
To: CF-Talk
Subject: RE: string parsing or list traversal
Sorry, I messed up the instr function ( I don't think it's supported in
SQL2K) I think you can use the charindex function instead. Also make
sure to add an ending comma like Issac
Oops Sorry.
Rick
-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 22, 2003 4:32 PM
To: CF-Talk
Subject: RE: string parsing or list traversal
It has to do with feeling safe on the road when
you are surrounded by these monsters that you cannot see
8 matches
Mail list logo