using varchar variable to query a table

• pramod.chauhan

  SSC Journeyman

  Points: 91

  More actions

  November 5, 2008 at 6:42 am

  #195455

  Hello All

  this query doesnot work.

  column employeeid has datatype char ()

  declare @ab varchar (100)

  set @ab='''483503'''

  select * from tm_temp_empmastall where employeeid=@ab

• dcordle

  SSC-Addicted

  Points: 469

  More actions

  November 5, 2008 at 7:08 am

  #894215

  You only need to wrap the value in single quotes:

  declare @ab varchar (100)

  set @ab='483503'

  select * from tm_temp_empmastall where employeeid=@ab

• pramod.chauhan

  SSC Journeyman

  Points: 91

  More actions

  November 5, 2008 at 7:58 am

  #894255

  i want multiple employeeids in @ab

  set @ab='483503,483504'

  and then

  select * from tm_temp_empmastall where employeeid in (@ab)

• J-F Bergeron

  SSCrazy Eights

  Points: 8593

  More actions

  November 5, 2008 at 8:43 am

  #894298

  Use dynamic SQL to complete your query, and you can send the amount of employee you want:

  Here's an example:

  DECLARE @SQL NVARCHAR(1000)

  DECLARE @ab NVARCHAR(100)

  set @ab = '''483503'',''483504'''

  SET @SQL = 'select * from tm_temp_empmastall where employeeid in ( ' + @ab

  + ' )'

  PRINT @SQL

  EXEC sp_executeSQL @SQL

  Hope this helps,

  J-F

  Cheers,

  J-F