Change a variable based on the results

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Change a variable based on the results

Change a variable based on the results

Rate Topic

Display Mode

Topic Options

Author

Message

zuma01

Posted Thursday, December 16, 2010 3:16 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, February 08, 2013 2:05 AM
Points: 37, Visits: 164

Hi,

I am trying to change a variable based on the results of the same variable. Is this possible or do I need to go about this some other way.

Code below:

DECLARE @NextMonth AS nvarchar(7)
SET @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)

if @nextmonth = 'Jan-10' then @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()),+1, 2)
else s @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)

select @nextmonth

Post #1035716

Sachin Nandanwar

Posted Thursday, December 16, 2010 3:39 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:14 AM
Points: 238, Visits: 2,341

DECLARE @NextMonth AS nvarchar(7)
SET @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)

if @nextmonth = 'Jan-10'
set @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate())+1, 2)
else
set @NextMonth = LEFT(datename(mm, dateadd(month, 1, GETDATE())), 3) + '-' + RIGHT(datename(yy, getdate()), 2)

select @nextmonth

Post #1035727

zuma01

Posted Thursday, December 16, 2010 4:11 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, February 08, 2013 2:05 AM
Points: 37, Visits: 164

Excellent. Thanks for your help.

Post #1035737

« Prev Topic | Next Topic »

Permissions