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
Query Questionsss
Posted - 12/20/2010 : 04:48:23
