My table as a PK(unique) of:

[InvoiceNbr] ASC,

[Line] ASC,

[SubLine] ASC,

[InvoiceDate] ASC,

[ShipDate] ASC

The process that creates the file to load to SQL does a FULL refresh of the data, meaning it does...

any examples of a compare script and output diff's?

Thanks.

I'm receiving from multiple data sources(machines\Lines) information that must be tested based upon a TESTID assigned to a

record type whether or not it falls between a TargetMin and TargetMax for...

Does the code look correct?

THanks.

Would it help if I post Capture_Inline_Quality ?

Thanks.

Not sure how to attack the set based operation from from the Import queue...

any suggestions examples

Anything else I can do for Debug...

Slowness...using cursor and maybe a better way to process other than -- sql agent jobs..

Thanks.

Any suggestions?

Thanks I can supply more info if needed..

I have the one record captured in $items |out-file "c:\sql.log"

Debug:

$items.rows.Count

# If data has been returned, do the export.

if ($items.rows.Count -gt 0)

$items.rows.Count   shows 0

Message:

0

There is no data to export.

Thanks.

Tried that but seems like the query from SQL returns no records, but if I use that query in SSMS data returns.

?

Thanks.

compare table values and create a file with diff's.

I would like to see diffs at the data-item level, this would help in the validation process.

Thanks.

Can that be driven from information schema tables so I don't have to hard code field names do the compares, how

about the decimal and float values?

any examples?

Thanks.

error converting string to float.