Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mary_itohan
Posting Yak Master
191 Posts |
 Posted - 2008-09-09 : 00:30:11
|
Hi All,Whats the best way to achieve this ?I have a SP that runs of a .net page that builds up a csv file in an custom split function. This CSV string is to be further processed.It then returns a status code to the calling .net page to free the wait time by the calling page. PROBLEM VS SOLUTION (Whats the best way to achieve this ? )Before the @return is sent back to the calling .net page...1. Do I save the CSV file into a varchar(max) column and delete it after execution is complete ?OR2. Do I rebuild the csv all over again ?(A trigger calls a SP to process the CSV values that had a status of 0)If option 1 is better, once the processing has been done the column is deleted.If option 2 is chosen, then the calling SP has to do a select in the table and rebuild the string, before processing the valuesWhats the best option here ?thanks Yes O ! |
|
|
|
|
|
Storing data in varchar(max)