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.

This is what my script looks like.

THis is where the error is coming from:

$Row.StdMargin_Pct = $_.StdMargin_Pct

$global:currenttime= Set-PSBreakpoint -Variable currenttime -Mode Read -Action { $global:currenttime= Get-Date }

Write-host "Starting...