2023-05-01から1ヶ月間の記事一覧
``` DECLARE @testDate DATETIME = '2023-05-01'; select a.prod_date,case when b.qty is null then 0 else b.qty end as prod_qty FROM [testDB].[dbo].[cal_ori] aleft join [testDB].[dbo].[cal] bon a.prod_date = b.prod_date--where a.prod_date >= '…