SP - Using query results in another query?

[sknyppy]

I'm just getting started using stored procedures so this may be a silly question.

In query1 I get a list of ModuleIDs.
In query2 I get the modulenames using the ModuleIDs from query1. Can this be done or do I need to use 2 SPs?

Thanks,
Dave

--------------------
CREATE PROCEDURE spUserPreferences
@Username [varchar] (50),
@ModuleList [varchar] (30) OUTPUT
AS
SELECT Username,ModuleIDs
FROM UserPref
WHERE NTUsername = @Username

SET @ModuleList =spUserPreferences.ModuleIDs

SELECT ModuleName
FROM allModules
WHERE MID IN(@ModuleList)
GO
---------------------

 

[kim1]

Hi,

You can combined as many select statement into one select statement.

Try this out:

SELECT UserName, ModuleIDs, ModuleName
FROM UserPref, allModules
WHERE UserPref.NTUsername = @Username
AND UserPref.ModuleIDs = allModules.MID

Kim