Heh... "Do We Need to Learn Linux?"

I guess the obvious joke here would be "GOOD SIR!!! CONTAIN YOURSELF!!!"

My take on it all this is not only "No" but "Hell No".

First of all, it would be a security violation to have a bunch of "unknowns" running a bunch...

Thank you for the readily consumable test data.  Details for one solution are in the comments in the code below...

--===== One solution.
     --...

I don't know much about SSIS but there MUST be some easy way to do the following in SSIS just like it's easy in T-SQL.

  ...

--===== Test string 
DECLARE @String VARCHAR(8000) = 
' ;T41,Vending,9000011;T42,Laundry,9000012;T43,Car Wash,9000013;T44,Amusement,9000014;T45,Promotion,9000015;T46,Transit,9000016;T47,Other,9000017;T73,?,9000011'
;
--===== Solution
   WITH cteSplit1 AS
(--==== Split the groups out based on the ";" delimiter, not returning...

Are they mostly ColumnStore or RowStore?

Even Grant will tell you that's just scratching the surface on such things.  Before you use one of them, you really need to study the documentation.

I've not had to work with ColumnStore yet but that sounds perfect, Eric.

I notice that even if we don't restart SQL Service, the data of sys.dm_exec_query_stats( sys.dm_exec_sql_text() and sys.dm_exec_query_plan() ) will be reset or removed/refreshed. when the data of...

... Eric, maybe I didn't understand your meaning then when you said: "so for everyone to mount a flag in their front yard seems to me like...

Hi Jeffrey,

The data type is date time because when I use query wizard to put filter and choose a date - the SQL code says:

WHERE

pr_time_attendance.h_date >=...

Wow... ok.  I raise my drink to all of you, thank my lucky stars that I "know" all of you, and be incredibly thankful that we all live in a...

Hi Jeffrey,

Sorry for asking a noob question but why should I change the code if it is working for me? Is Jeff's more resource-efficient?

Also maybe my Microsoft Report Builder...

Ah. Yep.  I can see change a quantity to a negative or positive... I read it that the OP wanted to change the ID "number" to negative or positive, which...

Indexes with high logical fragmentation mean little in an OLTP environment.  In a lot of cases, it doesn't matter too much in non-OLTP envirionments, either.  As an (at first) necessary...