No such option is available from within SSMS, as far as...

Are you changing the file extension from .xls to .xlsx, by any chance?

I suspect that there is some configuration on the server where the script is working which overrides the default (and invalid) path. It is unlikely that the SQL script is...

No problem, thanks for posting back.

PS, that's not a row, it's a column 🙂

Like this?

SELECT  SUM(TxQty*AvgCostOld) AS TotalTransactionCost
FROM     tblimInvTxHistory
WHERE  TxDate > '2020-08-25'
AND         TxCode = 'ADJ'

If you are going to SUM over a collection of rows, you need to define the grouping to SUM over.

All rows? By item? By date?

Makes it easier. Try this.

SELECT CalcTextName = CASE
                   ...

OK, so the requirement now is "remove any square brackets and any text they may contain", is that correct?

None of your revised test data matches this requirement:

If the square bracket is found at the beginning of string and is followed by '-' then I want  entire text after...

The drivers that Jeff refers to are not installed by default.

The 2010 versions are here.

The 2016 versions are here.

(I can't remember which version he prefers.)

I'd throw my hat into the ring, if it weren't for...

      ,Efficiency = CASE
                  ...

Glad you got it working. The use of the // and * wildcards makes the query processor 'look' for matches everywhere in the selected document path, not just on the...

You mention SSDT – are you hoping to create an SSIS package to do this, or something else?

This is a big task, even for an experienced developer.

SSIS packages are not...