having problem with "in" statement

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

having problem with "in" statement

Author

Topic

pssheba
Yak Posting Veteran

95 Posts

Posted - 2008-02-03 : 12:05:33

Hi everyone,
My procedure recieves one parameter (myNumber) and declares variables as many as the "mynumber" value.
The code goes like:


IF(@myNumber=1)
 DECLARE @firstname='aa'
IF (@myNumber=2)
  BEGIN
    DECLARE @firstname='aa'
    DECLARE @secondname='bb'
  END

I get an error message indicating that a line 5 @firstname has already been declared.
Can anyone help me with forming that "if" statement ?
Thanks

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-02-03 : 12:26:36

[code]
DECLARE @firstname varchar(100), @secondname varchar(100)

IF (@myNumber = 1)
SELECT @firstname = 'aa'
IF (@myNumber = 2)
SELECT @firstname = 'aa', @secondname = 'bb'
[/code]

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out

pssheba
Yak Posting Veteran

95 Posts

Posted - 2008-02-03 : 13:36:17

Thanks a lot spirit1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources