Ian, Well the thing is I am asking why would, you want to do that in the first place. I guess I should have been asking from an application point of view, why would I write a SP that allows for an array of data to be saved, I guess not knowing why you would have an array of data in the first place is where I am coming from.
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: The last time I was inside a woman was when I went to the Statue of Liberty. ---------------------------------------------------------------------------- -------------------------- -----Original Message----- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, 6 December 2005 10:08 AM To: SQL Subject: RE: SQL Server SP Question 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 Well, my wild guess is that they are inserting text into varchar fields which have a max size of 8000 characters. To store text blocks larger then 8000, they are using multiple records. This is an old school text trick; our database does similar things in some places. Why they would choose this technique over a CLOB field is a matter of some speculation. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2416 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
