I need to select *from (parm)_NAME and use the data in that table for the report.

• BKW

  Ten Centuries

  Points: 1350

  More actions

  August 28, 2008 at 9:51 am

  #197592

  I need to do a report where the user will select from a parm list: MTN, ACC, MKT

  I have tables like:

  MTN_NAME

  ACC_NAME

  MKT_NAME

  MTN_DETAIL

  ACC_DETAIL

  MKT_DETAIL

  I need to select *from (parm)_NAME and use the data in that table for the report.

  This may be simple but I'm new at this and don't know how to write the query.

  :unsure:

  Changinagain

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  August 28, 2008 at 10:38 am

  #864566

  BKW - have you thought of creating a dynamic T-SQL statement such as

  CREATE PROCEDURE Dbo.GetIT

  @TableName VARCHAR(5)

  AS

  DECLARE @Sql VARCHAR(50)

  SET @Sql = 'SELECT * FROM ' + @TableName + '_Name'

  PRINT @Sql -- print to be sure it is correct

  EXECUTE @Sql -- add this to execute after verifying it is correct

  Run as

  dbo.getit 'mystu'

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]

• BKW

  Ten Centuries

  Points: 1350

  More actions

  August 28, 2008 at 10:58 am

  #864583

  I'll try that, thx

  Changinagain