Can I pass the result of a select statement as a value for a parameter into a stored procedure?

XML or otherwise, assign the value to the variable before using the variable in the EXEC call DECLARE @UserName data type BEGIN SELECT @UserName = UserName FROM @MyTempTable WHERE UserId = @UserId EXEC dbo. GetUserData @UserName END.

XML or otherwise, assign the value to the variable before using the variable in the EXEC call. DECLARE @UserName data type BEGIN SELECT @UserName = UserName FROM @MyTempTable WHERE UserId = @UserId EXEC dbo. GetUserData @UserName END.

You'll need a temporary variable. DECLARE @username nvarchar(20) SELECT @username = Username FROM @MyTempTable WHERE UserId=@UserId exec dbo. GetUserData @Username.

Yeah I figured as much. In my situation it'd be a lot quicker if I didn't have to create temp variables for all my params so I though there might be a way to just do a select similar to how I presented it. – towpse Dec 16 '09 at 1:22.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.