<div>
You can do both those things via SQL Server table TRIGGERS where you check if the INSERTED value for the specific column is different that the DELETED the either populate the results column(or another table/column) with data or pipe the result out to a csv file - I would not recommend the second option with the CSV file.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx</a>
</div>


You can do both those things via SQL Server table TRIGGERS where you check if the INSERTED value for the specific column is different that the DELETED the either populate the results column(or another table/column) with data or pipe the result out to a csv file - I would not recommend the second option with the CSV file.

http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx [http://msdn.microsoft.com/en-us/library/ms189799(v=sql.105).aspx]

<div>
Thanks Jim, that is what I thought.
</div>


<div>
<div class="content wysiwyg-content">
There is a table that I have to work with that has data which is sorted by Bill To Manufacture Name (BillToMfgName) and a Manufacture Name (MfgName). &nbsp;Any time the BillToMfgName and/or MfgName changes I need to put the data in a new results section. &nbsp;Is there any way to do this? &nbsp;Or to write each of the results set to a new csv file?<br />
<br />
Thanks, John
</div>
</div>


There is a table that I have to work with that has data which is sorted by Bill To Manufacture Name (BillToMfgName) and a Manufacture Name (MfgName).  Any time the BillToMfgName and/or MfgName changes I need to put the data in a new results section.  Is there any way to do this?  Or to write each of the results set to a new csv file?

Thanks, John

MS SQL breaking script results into different files?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.