Thread: Tempoary Variables in Stored Procedures

Hi all, I'm trying to create a procedure that contains a temp variable that I can use further in the procedure, so that I can use the result from the first query in the second query: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[GetDetails] @ID int, @IDName varchar(100), @tempvar varchar(100) as begin Select @IDName AS tempvar from tbl_main where tbl_main.id = @ID SET @tempvar = tempvar Select...

First there is no need for a variable. Write the query as:  Select l.username AS UName,  isnull(l.useremail,'NA') AS UEmail  from  tbl_login l  join  tbl_main m ON m.column_name = l.designation  where tbl_login.designation = @ID I here used m.column_name, as it is not clear to me what is the name of the column tbl_main. I also dropped the isnull around username, because...