> > Hey Bob (once again, thanks for the reply) -
> > I guess I should explain more of the problem and why I thought of the
> > solution: currently, the XML data I'm using (from files) is 1 XML file =
> > 1 HTML table = 1 'report', which works well and fairly quickly as no db
> > hits are required. I had already created the XML files at the start of
> > each month (more on that later). Now my clients are requesting multiple
> > XML 'reports' per ASP request. These XML 'reports' are static,
> > historical data, and rather than serve them up dynamically I figured
> > storing the results as an XML string in a table, hitting the db once for
> > all the required XML and then transforming the XML via existing XSLT -
> > this would also reduce my reliance on the file system and give better
> > portability at the expense of a larger db. I would do this XML table
> > insert stuff once a month (currently I churn out XML files for 2 hours
> > once a month). Phew!
> > Now, you've hit on a great solution mate, but infortunately 'text'
> > datatypes are invalid for local variables. My XML could be more than
> > 8000 characters long, so that precludes the use of varchar. Is it
> > possible to do a call like (below), and what would the syntax be?
> > >INSERT INTO t (id, largeXmlField) VALUES ('1', EXEC
> > >(originalSpToReturnXml param1, param2))
> > Thanks for your thoughts on the matter Bob!
> > Thomas Williams
> > *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> > Don't just participate in USENET...get rewarded for it!