UPDATE m_user SET user_mst = SUBSTRING(user_id, 3) WHERE user_id LIKE '00%';
SELECT [対象年],[対象月],[社員番号],[氏名], STRING_AGG ( [JOBNo.], ',') as JOBNo FROM [xxxDB].[dbo].[t0004_外注一覧] t1 left join t0001_案件_売上項目 t2 on t1.社員番号=t2.商品コード where 対象年=2022 and 対象月=9 group by 対象年, 対象月, 社員番号, 氏名
SELECT job, AVG(uriage) from emp where job IN ('A','B', ...) group by job;
SELECT job, AVG(uriage) from emp group by job having job IN ('A','B', ...) ;
select newid() nid,* from <hoge> order by nid
select * into <hoge> from <hage>
insert into <hoge> select * from <hage>
hoge>と<hage>の項目が合っていることが前提。values()や項目指定などを使って合わせる
len( replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(kekka,'0', '') , '1', ''), '2', ''),'3',''), '4',''),'5',''),'6',''),'7',''),'8',''),'9',''),'.','') ) > 0