Well, It is not a good use of an SP for sure. Apart from physically being a mess - I can see no rhyme or reason for it to be done this way - you are gaining no speed gains or leveraging anything with beef within SQL Server.
If you need help on SQL Server, let me know! Currently studying for updated MCDBA exams.. N -----Original Message----- From: Andrew Scott [mailto:[EMAIL PROTECTED] Sent: 05 December 2005 22:50 To: SQL Subject: SQL Server SP Question Have sort of neglected what SQL Server can do for me, so I am now back into discovering this area of space. My question is that I came across this website, and although I know what the code is doing what I really don't understand is why anyone would do this at all. http://www.mindsdoor.net/SQLTsql/InsertTextData.html All feedback welcome, I am still learning the potential of SQL Server so I am interested in asking a lot of questions to learn. Regards Andrew Scott Analyst Programmer CMS Transport Systems Level 2/33 Bank Street South Melbourne, Victoria, 3205 Phone: 03 9699 7988 - Fax: 03 9699 7976 Quote: Demon: I'll swallow your soul!! I'll swallow your soul!! [Ash points his shotgun at the Demon's head] Ash: Swallow this ---------------------------------------------------------------------------- -------------------------- ----- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
