sql-server-2012

[Solved] How to select specific data between Quotes (“)

by

this is Ugly, but will eventually work: COLUMN = ‘jksjdksls#$#[email protected]@kskjfjf,”123,456,789″ lsnslkdswfnslsjfls’ left( right(COLUMN,len(COLUMN)-instr(COLUMN,””””)), instr( right(COLUMN,len(COLUMN)-instr(COLUMN,””””)), “”””) -1 ) –> 123,456,789 This is what is done: We take this string ‘jksjdksls#$#[email protected]@kskjfjf,”123,456,789″ lsnslkdswfnslsjfls’ find the first occurence of ” with instr(COLUMN,””””) –> returns 24 take the right end of the string with. Therefore we need to take … Read more

[Solved] SQL Server Rounding issue

by

First check datatypes: SELECT ‘0.458441’, system_type_name FROM sys.dm_exec_describe_first_result_set(N’SELECT 0.458441′, NULL, 0) UNION ALL SELECT ‘10.000000’, system_type_name FROM sys.dm_exec_describe_first_result_set(N’SELECT 10.000000′, NULL, 0) UNION ALL SELECT ‘5.000000’, system_type_name FROM sys.dm_exec_describe_first_result_set(N’SELECT 5.000000′, NULL, 0); ╔═══════════╦══════════════════╗ ║ value ║ system_type_name ║ ╠═══════════╬══════════════════╣ ║ 0.458441 ║ numeric(6,6) ║ ║ 10.000000 ║ numeric(8,6) ║ ║ 5.000000 ║ numeric(7,6) ║ ╚═══════════╩══════════════════╝ Query … Read more