Query

• Srinivas-120709

  SSC Veteran

  Points: 273

  More actions

  May 3, 2005 at 10:52 pm

  #68985

  I have TEST table in database A,B and C.

  I choose the database from the listbox.

  I need the db to be passed to the query below :

  SELECT DISTINCT K.MAXCOM_ID FROM A.DBO.TEST

  The  A.DBO.TEST , the A is dynamic and can be B or C.

  Please say whether it is possible.

  Thanks in advance.

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  May 4, 2005 at 3:41 am

  #556700

  DECLARE @Query varchar(8000), @DBName varchar(20)

  SET @DBName = 'A' -- or 'B' or 'C', it should be parameter for your SP

  SET @Query = 'SELECT DISTINCT K.MAXCOM_ID FROM ' + @DBName + '.DBO.TEST'

  EXECUTE (@Query)

  _____________
  Code for TallyGenerator