Query Questionsss - SQL Server Forums

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)

Query Questionsss

Author

Topic

cal_bonjovi
Starting Member

3 Posts

Posted - 2010-12-20 : 04:48:23

i have a query with parameters, what i want is i want to give value to my parameter coming another table
example:
declare @PersonnelNumber int
declare @WageType int
declare @PayGroup nvarchar(40)

set @PersonnelNumber = 123
set @WageType = 7000
set @PayGroup = 'M'

instead of 123, i want to get its value from tableSource
instead of 7000, i want to get its value from tableSource
instead of 'M', i want to get its value from tableSource

then below this declaration query is a where a clause that uses the above parameters

like this one..but this is incorrect
set @PersonnelNumber = select personnelNumber from tableSOurce
set @WageType = select Wagetype from tableSOurce
set @PayGroup = select Paygroup from tableSOurce

Sachin.Nand

2937 Posts

Posted - 2010-12-20 : 04:52:45

select @PersonnelNumber = personnelNumber from tableSOurce

Remember the value of @PersonnelNumber will be set to any of the random value of personnelNumber from tableSOurce

PBUH

cal_bonjovi
Starting Member

3 Posts

Posted - 2010-12-20 : 04:57:51

how will i write that..

set @PersonnelNumber = Select @PersonnelNumber = PersonnelNumber from tableSource

????

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-12-20 : 05:34:07

You write it exactly how Sachin.Nand showed.

select @PersonnelNumber = personnelNumber from tableSource

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources