SELECT FROM Table where the table name is in a variable SQL

Question

How do I save the result of my exeuction into a variable? I want to save the integer given by the count into a variable

    DECLARE @count INT

    SET @sqlString = 'SELECT COUNT (DISTINCT process) FROM @tableName
        + ' WHERE process =''' + @process + '''' + 'AND stage ='
        + '''' + @varStage+ ''''

        PRINT @sqlString
    SET @count = EXEC (@sqlString)

This is my idea, but the last line does not work.

possible duplicate of Assign result of dynamic sql to variable — Tanner
– Tanner, Commented Jun 25, 2014 at 15:39

huMpty duMpty · Accepted Answer · 2014-06-25 15:49:19Z

1

EXEC doesn't return the count value, you need to select @count within the statement


 Create Table #Temp(Number int)
 DECLARE @count INT

    SET @sqlString = 'Insert Into #Temp SELECT COUNT (DISTINCT process) FROM @tableName
        + ' WHERE process =''' + @process + '''' + 'AND stage ='
        + '''' + @varStage+ ''''

  PRINT @sqlString
  EXEC (@sqlString)

  Select @count = Count(*)
  From #Temp

edited Jun 25, 2014 at 15:49

answered Jun 25, 2014 at 15:43

huMpty duMpty

14.5k14 gold badges64 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SELECT FROM Table where the table name is in a variable SQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related