any thoughts of how to modify to meet requirements?

Thx.

This script works well except for handling the Identity Columns and TimeStamp column an instead of feeding it a Table Name I would like it just to read from schema...

• This reply was modified 4 years, 6 months ago by Bruin.

The copy will be ALL data from PROD copied back to TEST.. The issue is how to code the Identity Column and a TimeStamp column as

these wouldn't be include in...

just wanted to expand upon what I already was using.. maybe make it better by trapping what passed and failed.

Thanks.

It's reporting back errors, but not the FILE NAME that didn't process.

Thanks.

I added -append but still didn't get any output from the process for failed SP's

Thx.

Thanks for the template, I have it working sending the XML - email...

Thanks ALL!!!!

I can wrap the results of the dynamic pivot -  into the email?

Thanks

could I call SP from powershell and output to csv?

I was going to ask is there any easy way to port the output to an Xcel file?

Thanks.

Very cool, just what I was looking for...

Many Thanks for all replies...

On the pre-2017 is there any way to generate a Total record for each category?

Thanks for all replies..

I would just be using SQL to drive out this report possibly email to a group.

THanks

Would that code change if SQL2012 ?

Thanks for reply

parse the records based on position:

First record is always the UNB envelope:

field after the 2nd plus sign contains the sending partner ID, terminated by a colon.

field after the 4th plus...