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/

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 1 year, 10 months ago by frederico_fonseca.