Mr Brian Gale is correct, I saw no notification. Here is a possible solution – it relies in integer division:

DROP TABLE IF EXISTS #temptable;

CREATE TABLE #temptable
(
 ...

• This reply was modified 1 year, 9 months ago by Phil Parkin.

Can you please complete your question for desired results after

set @setValue=3

?

It sounds like it was generated by ChatGPT or similar – and there would be an issue if that...

Something like this, perhaps?

SELECT si.logdate
      ,srv01 = MAX (IIF(si.srvname = 'srv01', si.queueinfo, NULL))
      ,srv02 = MAX (IIF(si.srvname...

Did you actually create this article, or was it AI-generated?

I think it's because MS is forcing users to adopt TLS1.2. I had similar problems a few months ago.

If you mean within the proc itself,...

Nice. Thanks, Jeff, for reminding me that TRIM() could remove more than just beginning and trailing space characters

You mean, like this?

https://www.sqlshack.com/python-scripts-to-format-data-in-microsoft-excel/

Looks like it will work, but I haven't done it. If you do make it work, please post back here, as I'm sure others would be...

Welcome to the forum.

The horizontal / vertical stuff you are talking about is best done (if possible) in SQL, prior to the SSIS package being called. SSIS can easily export...

In this case I would start splitting the comment based on a space.

check "Tally OH! An Improved SQL 8K “CSV Splitter” Function"

and process the spliter results for the...

The point of testing against a very large dataset is to get an...

It's a piece of code which can be put into an SSIS Script Task and is therefore neither WinForms nor Console.

However, the MessageBox command does work when running the code...

There's not a syntax error. That is a run-time error., which is why I suggested debugging. Here is a possible solution:

//remove last , from row
strRow = strRow.Remove(strRow.Length...

There is an error in your script. 'Element cannot be found in a collection' is the error of interest. I'd suggest

a) Adding comprehensive error-handling if not already present. This may...