stored procedure to import csv

importer.sql

-- 取り込み用ローデータの削除 
DELETE [r_tbl];

-- データの取り込み実施
BULK INSERT [r_tbl] from 'raw.txt' WITH
(
	FIELDTERMINATOR = '\t', 
	ROWTERMINATOR = '0x0a'
);


-- 必要なカラムだけ型変換してインサート
MERGE 
	INTO [tbl] as T
	USING [r_tbl] as R
ON 	T.[user_id] = R.[user_id] 
WHEN MATCHED THEN
	UPDATE 
		SET T.[date] = R.[date]
WHEN NOT MATCHED THEN
	INSERT ([user_id],[date]) 
		VALUES (R.[user_id],R.[date);