SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE WaitCheckBil
	([BIL_NO] varchar(10), [USRS] varchar(43), [DATE] datetime)
;
	
INSERT INTO WaitCheckBil
	([BIL_NO], [USRS], [DATE])
VALUES
	('XC20090015', ';STO09;STO02;STO04;STO06;STO10;STO07;STO10;', '2020-09-15 00:00:00'),
	('XC20090016', ';STO09;STO02;STO04;STO06;STO10;STO07;STO10;', '2020-09-15 00:00:00'),
	('XC20090017', ';STO09;STO02;STO04;STO06;STO10;STO07;STO10;', '2020-09-15 00:00:00'),
	('XC20090018', ';STO09;STO02;STO04;STO06;STO10;STO07;STO10;', '2020-09-16 00:00:00')
;
4 rows affected

select * from WaitCheckBil


BIL_NO
USRS
DATE


XC20090015
;STO09;STO02;STO04;STO06;STO10;STO07;STO10;
2020-09-15 00:00:00.000

XC20090016
;STO09;STO02;STO04;STO06;STO10;STO07;STO10;
2020-09-15 00:00:00.000

XC20090017
;STO09;STO02;STO04;STO06;STO10;STO07;STO10;
2020-09-15 00:00:00.000

XC20090018
;STO09;STO02;STO04;STO06;STO10;STO07;STO10;
2020-09-16 00:00:00.000


CREATE TABLE Users
	([USR] varchar(5), [NAME] varchar(5))
;
	
INSERT INTO Users
	([USR], [NAME])
VALUES
	('STO02', 'John'),
	('STO04', 'Eva'),
	('STO06', 'Lisa'),
	('STO07', 'Boke'),
	('STO09', 'Nii'),
	('STO10', 'Alisa')
;
6 rows affected

select * from Users


USR
NAME


STO02
John

STO04
Eva

STO06
Lisa

STO07
Boke

STO09
Nii

STO10
Alisa


CREATE TABLE ExpectedResult
	([BIL_NO] varchar(10), [USRS] varchar(36), [DATE] datetime)
;
	
INSERT INTO ExpectedResult
	([BIL_NO], [USRS], [DATE])
VALUES
	('XC20090015', ';Nii;John;Eva;Lisa;Alisa;Boke;Alisa;', '2020-09-15 00:00:00'),
	('XC20090016', ';Nii;John;Eva;Lisa;Alisa;Boke;Alisa;', '2020-09-15 00:00:00'),
	('XC20090017', ';Nii;John;Eva;Lisa;Alisa;Boke;Alisa;', '2020-09-15 00:00:00'),
	('XC20090018', ';Nii;John;Eva;Lisa;Alisa;Boke;Alisa;', '2020-09-16 00:00:00')
;
4 rows affected

select * from ExpectedResult;


BIL_NO
USRS
DATE


XC20090015
;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;
2020-09-15 00:00:00.000

XC20090016
;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;
2020-09-15 00:00:00.000

XC20090017
;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;
2020-09-15 00:00:00.000

XC20090018
;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;
2020-09-16 00:00:00.000

BIL_NO	USRS	DATE
XC20090015	;STO09;STO02;STO04;STO06;STO10;STO07;STO10;	2020-09-15 00:00:00.000
XC20090016	;STO09;STO02;STO04;STO06;STO10;STO07;STO10;	2020-09-15 00:00:00.000
XC20090017	;STO09;STO02;STO04;STO06;STO10;STO07;STO10;	2020-09-15 00:00:00.000
XC20090018	;STO09;STO02;STO04;STO06;STO10;STO07;STO10;	2020-09-16 00:00:00.000

BIL_NO	USRS	DATE
XC20090015	;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;	2020-09-15 00:00:00.000
XC20090016	;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;	2020-09-15 00:00:00.000
XC20090017	;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;	2020-09-15 00:00:00.000
XC20090018	;Nii;John;Eva;Lisa;Alisa;Boke;Alisa;	2020-09-16 00:00:00.000