declare @EndDate varchar(50)
set @EndDate = '2014-11-17'
declare @monthend varchar(50)
set @monthend = 'select' + ' '+ 'MONTH('+ ''''+@EndDate+''''+')'
declare @flag int
set @flag = exec @monthend
select @flag
if @flag ='11'
I want to store result comes from dynamic query @monthend into variable @flag.and use the value @flag in the if else condition.
Jitendra KumarPosted Dec 10, 2014, 11:52 PM
You've probably tried this.
declare @EndDate varchar(50)
set @EndDate = '2014-11-17'
declare @monthend nvarchar(50)
declare @flag int
set @monthend = 'select @val = MONTH('+ ''''+@EndDate+''''+')'
EXECUTE sp_executesql @monthend , N'@val int OUTPUT', @val =@flag OUTPUT
Select @flag as 'Flag'
if @flag = 11
begin
print 11
end
Rahul SharmaPosted Dec 12, 2014, 9:27 AM