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

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 2 months, 3 weeks 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