declare @SDate datetime,
@EDate datetime
select @SDate=cast(datepart(year,getdate()) as nvarchar(4)) + '-' + cast(datepart(month,getdate()) as nvarchar(2)) + '-1'
select @EDate=cast(datepart(year,getdate()) as nvarchar(4)) + '-' + cast(datepart(month,getdate()) as nvarchar(2)) + '-' + cast(datepart(day,getdate()) as nvarchar(2))
|
