then the ""MAIN""" question is

PRACTICAL implementation  ( how ??? )

not exists "preferred"  "better in all sorts " over left join

“Everything I Needed to Know Used to Be Found in One Book”

I’ve worked in the software industry since 1998.

Back then, learning was different.

If you had one solid book, enough curiosity,...

hi

my query = worst

Paul White / Steve Query  = Best

DECLARE @s varchar(max)='1,2,4,5,7,8,11,12,13,15,17,19,20'

;WITH n AS
(
SELECT 1 x
UNION ALL
SELECT x + 1
FROM n
WHERE x < 20
)
SELECT x
FROM n
WHERE ',' + @s + ',' NOT LIKE '%,' + CAST(x...

• This reply was modified 3 days, 4 hours ago by naumon765.

hi hope this helps

drop table if exists #abc

create table #abc ( col1 varchar(100) )

insert into #abc values 
(' 1,2,4,5,7,8,11,12,13,15,17,19,20')

select * from #abc

t-sql  solution

;WITH x AS

(

SELECT v =...

hi hope this this helps

hi hope this helps

SAMPLE DATA

DROP TABLE IF EXISTS dbo.SampleData;

GO

CREATE TABLE dbo.SampleData

(

Col1 VARCHAR(20)

);

GO

INSERT INTO dbo.SampleData (Col1)

VALUES

('A'),

('B'),

('A10'),

('A20'),

('B05'),

('A10Q'),

('A30P'),

('B05X'),

('A10QA'),

('B05XY'),

('A10QA01'),

('A10QA02'),

('B05XY99'),

('C'),

('C03'),

('C03C'),

('C03CA'),

('C03CA01'),

('D07'),

('D07M'),

('E99ZZ01');

GO

T-SQL solution

SELECT

   Col1,

      CASE WHEN LEN(Col1) >= 1 THEN LEFT(Col1,1) END AS Level1,...

hi

hope this helps

DROP TABLE IF EXISTS SampleData;

CREATE TABLE SampleData

(

col1 VARCHAR(max)

);

INSERT INTO SampleData (col1)

select 'NYSTATIN SUSP 500000 UNIT = 5 ML (1 5 ML CUP)'

UNION ALL

Select 'NYSTATIN SUSP 0.75 UNIT =...

hi

hope this helps

DROP TABLE IF EXISTS SampleData;

CREATE TABLE SampleData

(

col1 NVARCHAR(max)

);

INSERT INTO SampleData (col1)

select 'Sarat'

union ALL

select 'qwerty'

union ALL

select 'AS123werTy'

t-sql solution

select

col1

,case when

col1 COLLATE Latin1_General_CS_AS <> lower(col1 COLLATE Latin1_General_CS_AS) then...

hi hope this helps

DROP TABLE IF EXISTS SampleData;

CREATE TABLE SampleData

(

col1 NVARCHAR(max)

);

INSERT INTO SampleData

(col1)

select '10.4.'

union all

select '12.1.4'

union all

select '13.789'

union all

select '90.1'

t-sql solution

select * from sampledata where len(col1) - len(replace(col1, '.',...

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

hi hope this helps

CREATE TABLE locations (

id INT PRIMARY KEY IDENTITY(1,1),

latitude FLOAT NOT NULL,

longitude FLOAT NOT NULL

);

INSERT INTO locations (latitude, longitude)

VALUES

(45.123456, -111.123456), -- Center point

(45.200000, -111.200000), -- Nearby

(45.500000, -111.500000), --...

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