have you ensured to see if TCP is enabled as a protocol on the SQL Server Configuration Manager

and are you sure there are no firewall rules preventing you from accessing...

you have already been given an answer on your original thread https://www.sqlservercentral.com/forums/topic/txt-file-pipe

page bump

very very disappointed at this unholy situation. How is it possible that Jeff is wrong!!!!

nothing you can do really within sql other than cleaning up after loading.

you may be able to get the data cleaned in excel itself (ask the owner of it to...

and on long run having a key-value table end up being better for this type of things as you always end up requiring more entries added, so better to just...

as you have been advised before we need you to post create table DDL, insert statements into the tables required, and what you tried - while a image is good...

duplicated of https://www.sqlservercentral.com/forums/topic/sequentially-update-a-column-with-a-decrementing-value

this isn't a Oracle site - you better off asking elsewhere

first of format your code - it is showing as a single line.

second - use a staging table and do the dedup from it within your code.

if you don't know...

try and get on your developers mind that SQL Server LIKES to have a clustered table on each table. Ideally a UNIQUE clustered index.

so as a rule of thumb, if...

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/