you are likely better off creating a separated list of emails into a temp table, do a split of the domain into its own column and then use it to...

why doesn't pivot work for you?

2 ways of doing it with pivot below

drop table if exists #data

select *
into #data
from (values (1, 'Swimming')
     ...

this isn't a Oracle forum - so you would be better off asking elsewhere dedicated to Oracle.

but (assuming this ain't spam) the answer is no there isn't a better way.

have a look at these https://www.webfx.com/blog/web-design/10-free-server-network-monitoring-tools-that-kick-ass/

my company, for some of their servers is now using https://www.zabbix.com/

ty with the path within double quotes - note that I didn't escape them below - but you will need to do that for sure (possibly a double double quote)

its all in this line

" , STRING_AGG(coalesce(t3.word, t2.value), '|') within group (order by t2.ordinal) as Modified"

plus the group by bt.original

string_agg converts from rows to a single column - and the...

install-module won't work for this - sqlps is not the same as sqlserver modules. if this was SQL 2022 you could tell SQL Agent to use SQLSERVER module instead of...

look at this link then https://www.pythian.com/blog/powershell-error-sqlps-ps1-cannot-loaded-running-scripts-disabled-system

but heed the advise on the bottom - do not use native SQL PowerShell and instead use a command file to run with the most...

• This reply was modified 2 years, 10 months ago by frederico_fonseca.

I didn't get it. the...

easy google - should always be first point of reference

https://blog.sqlauthority.com/2023/09/07/sql-server-resolving-the-ps1-cannot-be-loaded-because-running-scripts-is-disabled-error/#:~:text=The%20root%20cause%20is%20that,policy%20needs%20to%20be%20changed.

can you get used to post data in a consumable way - see on code below one way of doing it.

one way below to achieve what you need

            
November 18, 2023 at 7:08 pm
            
#4330218

            
            
                                                
        

the code you gave us is already doing it in "small" chunks - indeed its doing it on the smallest possible chunk size.

and that is what should not be done...

and something I've noticed - your SQL settings are default ones - you should change them - maxdop normally should not be set to zero, and Cost Threshold for Parallelism...

the issue should be clearer even for someone not experienced.

there is no index on the FIRST_NM - so for each update it needs to do a table scan.

add a index on...

That is a very ugly file. Guessing it came from a mainframe?

It may be faster and more supportable to learn some python to preclean and format the file than...