CREATE FUNCTION dbo.DISTINCT_STRING_AGG
(
@TableName NVARCHAR(128),
@ColumnName NVARCHAR(128),
@Separator NVARCHAR(10)
)
RETURNS NVARCHAR(MAX)
AS
BEGIN
DECLARE @SQL NVARCHAR(MAX);
DECLARE @Result NVARCHAR(MAX);

SET @SQL = '
SELECT @ResultOut = STRING_AGG(val, ''' + @Separator + ''')
FROM (
SELECT DISTINCT ' + @ColumnName...

in my past

have taken the #sql server# function and modified it to my needs

saved it as a  -user defined function-

hi

feel like CERTIFICATIONS and all is a waste of time/money/energy

learning new features and all when "big big CASH" is involved makes sense to me

no pun intended against any one

• This reply was modified 2 days, 19 hours ago by naumon765.

hi Jeff

took a look at your YOU TUBE video

nice extremely dense thick stuff

thanks Jeff

already tried it ages ago

did not like it "bold font huge font"

thumbs up

thanks Jeff

for your suggestion 

posted the code also

gif = viusal .. nice .. easy to understand

code = play around .... implement etc etc

• This reply was modified 1 weeks, 1 days ago by naumon765.

hi hope this helps

Tried with LLM where there is no need to write any code t-SQL or Java or Python etc etc 

Just dumped my data into LLM and started asking question...

had an idea  .. working in vast amounts of companies

a small set of people handle "end to end"

meaning from HR to Production Support to Development to meetings with clients COO...

• This reply was modified 1 weeks, 2 days ago by naumon765.

I love the way you framed this — treating digital work as if you had to do it yourself in the physical world. It’s a mindset that makes optimization feel...

• This reply was modified 1 weeks, 2 days ago by naumon765.

/*

DROP TABLE dbo.TestData; CREATE TABLE dbo.TestData ( Column1 VARCHAR(50));

INSERT INTO dbo.TestData (Column1) VALUES ('13.4.'),('16.8.7'),('13.4'),('134'),('45.67'),('123');

*/

SELECT * FROM TestData

SELECT

TRY_CAST(Column1 AS NUMERIC(10,2))

FROM

TestData

WHERE

LEN(Column1) - LEN(REPLACE(Column1, '.', '')) <= 1

• This reply was modified 1 weeks, 2 days ago by naumon765.
• This reply was modified 1 weeks, 1 days ago by naumon765.

thanks Pat  for your reply

Yup   ..  me personally have worked in many companies where i have seen bad architecture , horrible people management  , bad politics

just observed those things .....

• This reply was modified 1 weeks, 2 days ago by naumon765.
• This reply was modified 1 weeks, 2 days ago by naumon765.

hi hope this helps

i personally feel  "all people"  are fundamentally flawed

so the same patterns show up in each and every sh..t

question arises ... how do you fix peoples fundamental flaws

very...

• This reply was modified 1 weeks, 3 days ago by naumon765.

would you HIRE me .. ?? if so                   !#@!#^!$^!$&^

please do not get me "wrong"

i personally feel the whole system is flawed

why do  i say this ? if you are  fighting fires all the time

whats the point of choosing that...