dynamic sql in a table-valued function

• erics44

  SSCertifiable

  Points: 6311

  More actions

  May 18, 2010 at 2:20 am

  #386950

  Hi

  I would like to create a table-valued function where the database used is dependant on a variable passed. So for example

  create function dbo.fn_TableFunction(@database as char(5))

  Returns table as

  return

  (

  select

  field1

  , field2

  From

  @database.dbo.tblTable1

  )

  this obviously doesnt work but i dont know of an alternative. I cant use a stored procedure as I want to select the results in another query.

  Thanks in advance

• erics44

  SSCertifiable

  Points: 6311

  More actions

  May 18, 2010 at 2:31 am

  #1168651

  this has been resolved

  thanks