Run string query and store its answer to other variable and apply condition on it

See more:

SQL-Server-2005

SQL-Server

In sql server 2005 using store procedure with string query

My problem is that I have to run string query and store its answer to other int or string variable and put condition on it

e.g.

DECLARE @P_GetTableQuery VARCHAR(500)

SET @P_GetTableQuery =  ('SELECT COUNT(*)  FROM  '+  @P_tableName + '	WHERE ee_nEmployee = ' + @P_ee_nEmployee)


if @P_GetTableQuery =0 
begin
  do this
end
else
begin
 do this
end

How to do this? Need help.