Just for fun, like a Christmas turkey, lots of STUFFing :hehe:

SELECT
REPLACE(
STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(STUFF(
STUFF(Column1,58,0,'|')
,55,0,'|')
,52,0,'|')
,49,0,'|')
,46,0,'|')
,43,0,'|')
,40,0,'|')
,37,0,'|')
,34,0,'|')
,31,0,'|')

WITH cte (Ig,DATE_,TOTAL,RunningTotal,Debit) AS (
SELECT Ig,DATE_,TOTAL,
  SUM(TOTAL) OVER (PARTITION BY Ig ORDER BY SIGN(TOTAL) DESC,DATE_),
  SUM(CASE WHEN TOTAL < 0 THEN -TOTAL ELSE 0...

WITH cte (Ig,DATE_,TOTAL,RunningTotal,Debit) AS (
SELECT Ig,DATE_,TOTAL,
  SUM(TOTAL) OVER (PARTITION BY Ig ORDER BY DATE_),
  SUM(CASE WHEN TOTAL < 0 THEN -TOTAL ELSE 0 END) OVER (PARTITION BY...

How many negative values will there be per Ig

WITH cte (Ig,DATE_,TOTAL,RowNum) AS (
SELECT Ig,DATE_,TOTAL,
  CASE WHEN TOTAL < 0 THEN 1
   ELSE ROW_NUMBER() OVER (PARTITION BY Ig ORDER BY DATE_ ASC)
   END
FROM #TempStk
)

Use a Data Flow Task with OPENROWSET in an OLE DB Source and output to a Recordset Destination

I'd be interested in Auditing read/access/usage of a table 🙂

Untested but something like this

SQL.CommandText = "INSERT INTO [MyDatabase].[dbo].[MyTable] ([my_id]) VALUES (@my_id)"
SQL.ActiveConnection = Cn
SQL.Parameters.Append SQL.CreateParameter("@my_id", adVarChar, adParamInput, 50, Value)
RowNum = 1
While Sheets("Sheet1"),Cells(RowNum,5).Value...

Do you mean the values in the column for all rows in the spreadsheet?