Hi,

declare @vchHomeTeam varchar(50),

        @vchAwayTeam varchar(50),

 @intGameId integer

select @intGameId = 1 

select

 @vchHomeTeam = team_name

from   

 Teams,

 Schedule

where  

 team_id = home_team_id

and  game_id = @intGameId  

select

 @vchAwayTeam = team_name

from   

 Teams,

 Schedule

where  

 team_id = away_team_id

and...

try this...

CREATE procedure dbo.xxx

@vchName varchar (50),

@vchPrefix varchar(50) output,

@vchFirstName  varchar(50) output,

@vchMiddleName  varchar(50) output,

@vchLastName  varchar(50) output,

@vchSuffix  varchar(50) output

as

set nocount on

declare @tiStringLength  tinyint,

 @tiSpaceLocator  tinyint,

 @tiPointer  tinyint,

 @tiCount  tinyint,

 @tiRecCount  tinyint,

 @vchStrHold  varchar(50),

 @vchOne  varchar(50),

 @vchTwo   varchar(50),

 @vchThree   varchar(50),

 @vchFour   varchar(50),

 @vchFive   varchar(50)

select @tiRecCount = 0

select @vchName = @vchName...