Adrian: Thank you. I just wanted to make sure it was efficient.
Andy ----- Original Message ----- From: Adrian Forbes - ITD Sent: 6/28/2004 4:39:02 AM To: [EMAIL PROTECTED] Subject: RE: [ASP] SQL Server Split - Part II > That's pretty much how we've done this when required. > > -----Original Message----- > From: Andy and Kim Mills [mailto:[EMAIL PROTECTED] > Sent: 25 June 2004 8:10 > To: [EMAIL PROTECTED] > Subject: [ASP] SQL Server Split - Part II > > > Hello Guys: > > I got a Stored Procedure working to do what I wanted, but I have a feeling > it is an amateurish type procedure. > > I was wondering if anyone could let me know if this is a pretty good > procedure, or one that needs some improving. I am going to list the > procedure below and would appreciate any help you might be able to provide: > > CREATE PROCEDURE dbo.InsertUserApplications > @UserID Integer, > @String Varchar(1000) > > AS > > DELETE FROM tblUserApplications WHERE UserID = @UserID > DECLARE @AppID Varchar(2) > > WHILE LEN(@String) > 0 > BEGIN > SET @AppID = LTRIM(SUBSTRING(@String, 0, CHARINDEX(', ', @String))) > SET @String = RIGHT(@String, LEN(@String) - CHARINDEX(', ', > @String)) > IF LEN(@AppID) = 0 > BEGIN > SET @AppID = LTRIM(@String) > INSERT INTO tblUserApplications(UserID, > ApplicationID) > VALUES (@UserID, @AppID) > BREAK > END > ELSE > INSERT INTO tblUserApplications(UserID, ApplicationID) > VALUES > (@UserID, @AppID) > END > GO > > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > > > The contents of this email and any attachments are sent for the personal attention > of the addressee(s) only and may be confidential. If you are not the intended > addressee, any use, disclosure or copying of this email and any attachments is > unauthorised - please notify the sender by return and delete the message. Any > representations or commitments expressed in this email are subject to contract. > > ntl Group Limited > > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
