By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with cte1 as
(
select 1 as Appid, 'A' as value1, 'B' as value2
union all
select 2,'C','D'
),
cte2 as
(
select 1 as Appid, 'A' as value1, 'B' as value2
union all
select 2,'X','D'
)
, cte3 as (
select cte1.*,cte2.* from cte1 join cte2 on cte1.Appid!=cte2.Appid
) select
Msg 102 Level 15 State 1 Line 15
Incorrect syntax near 'select'.
Declare @str Nvarchar(MAX) ='Minneapolis c0 02/14/18'
SELECT left(@str,len(@str)-11)
| (No column name) |
|---|
| Minneapolis |
Declare @str Nvarchar(MAX) ='Minneapolis c0 02/14/18'
select substring(@str,1,11)
| (No column name) |
|---|
| Minneapolis |
Declare @str Nvarchar(MAX) ='Minneapolis c0 02/14/18'
SELECT REPLACE(@str, 'c0 02/14/18', '');
| (No column name) |
|---|
| Minneapolis |