this is what i have seen in each and every company i have worked in       ### the same people issues  ### all people including me ..prone to the...

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

these are my personal SSD s

#funniest thing#      is i do not rely on SSD s

nice powershell script ; have used SMO for my DB stuff in the past

<# as far as security is concerned #there is no security#  #>

feel GUI stuff is #way way#...

• This reply was modified 2 months ago by naumon765.

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 months 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 2 months, 1 weeks 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 2 months, 1 weeks 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 2 months, 1 weeks 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 2 months, 1 weeks ago by naumon765.
• This reply was modified 2 months, 1 weeks 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 2 months, 1 weeks ago by naumon765.
• This reply was modified 2 months, 1 weeks ago by naumon765.