it would be a lot easier if you supplied DDL, Sample Data and your expected results.  Screen shots help, but not in setting up the data

After 50 replies, I believe forum rules officially declare this a post hijack 😉

we still use mainframe and AS400.  This is how we get files all the time.  Bulk Insert works well and fast.  I still have arguments with mainframers as they don't...

The output statement is wrong. I should've looked closer. When you do an update, it puts the old data into deleted table and the new data into inserted.  So it...

It looks correct.  What did your testing show?

on a merge, you can use $Action in an output statement to get what was inserted vs updated

can you provide some sample data of what you are seeing and how you would 'fix' them?

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

what indexes do you have on Lookups.dbo.tbl_SCT2_Relationships?  what does the execution plan look like?

Can you create 1 table with a BatchKey or some identifier to identify which records were loaded with which path.  Instead of Matrix_1 and Matrix_2 tables, have a MatrixID of...

this should generate the syntax you need for each table

;with cte as ( Select c.table_schema + '.' + c.table_name as Tablename, 'count(distinct('+ c.column_name + ')) as '...

You have a  date field that you are querying on.  Can't you check to see if the CreatedDate is > than that date.  That would mean it was created after...

It is returning an integer because count returns an integer value.  By adding the 0.0 to it, it does an implicit conversion to decimal.

I don't have any data returned when I run your query, but could you run something like this?

declare @i int = 200

select @i/60 as hours, @i %...

it would be nice to at least see what you've tried so far.

One approach would be to load the data to a staging table first, then you can manipulate to put into the main table.  You can have the datatype be a...