SQLTeam.com Forums - Latest posts

I would create an extra field with HASHBYTES with all the fields of the CSV-file, something like this:

SELECT HASHBYTES(
'SHA2_256',
CONCAT_WS('|',
Date,
Amount,
Description,
etc etc
)
) AS RowHash

When you load 2 files in 2 tables you can use ROWNUMBER to select the one you need and ignore the others.

What’s a reliable way to avoid duplicate transactions when importing CSV files into a small expense-tracking application?

For example, suppose two exports cover overlapping dates. Some transactions appear in both files, but neither file provides a unique transaction ID.

Matching the date, amount, and description seems like a reasonable starting point. However, t...

Quick question for anyone who's done this: We have dozens of Legacy SSIS packages loading SQL staging tables that need to go to Fabric OneLake. Opening every .dtsx package to copy out data flows and transform logic line by line is going to take months. How are other teams speeding up thr SSIS conversion phase ?

We ran into the exact some performance lag with subreports in paginated nesting them kills load time. It's almost always better to combine them ino to a single report with multiple tables/datasets if you can.

For passing multi vale params into stored procs, STRIGN_SPLIT or using dynamic SQL/ PowerQuery or import.

Also, if you are dealing with 100 RDL files, we u...

nice