I can create a Sproc out of this and take @projectXml as 'Text' type instead of varchar(8000) which should solve the 8000 character limitation.
Sweet, that might work, i've never tried it using blobs.
"And most of the evils of society can, in fact, be cured through information. We have a society that has been disinformed and based on the disinformation has made irrational choices. And that's what I mean by 'ignorance.' People, who ordinarily might be smart, are deprived of the data by which to make a rational decision, don't have the data to do it."
Frank Zappa
Originally Posted by chocoloco
Reply With Quote