Exec sp_MSforeachdb @command1='if ''?'' like ''XMP%'' 
Select a.FundGroupNumber,b.FundId, C.FundName, b.FieldValue
From ?..FundGroupInfo a, ?..FundCustomFieldDefinitions d
	join ?..FundCustomFieldValues b on  d.fieldId = b.FieldId
	join ?..FundInfo c on b.FundId = c.FundId
Where  d.FieldName = ''Fund Detail''
Order by b.FundId ASC'

quote:

---

Originally posted by sodeep

Use Dynamic SQL .

---

Exec sp_MSforeachdb @command1='if ''?'' like ''XMP%'' 
Select a.FundGroupNumber,b.FundId, C.FundName, b.FieldValue
From ?..FundGroupInfo a, ?..FundCustomFieldDefinitions d
	join ?..FundCustomFieldValues b on  d.fieldId = b.FieldId
	join ?..FundInfo c on b.FundId = c.FundId
Where  d.FieldName = ''Fund Detail''
Order by b.FundId ASC
UNION ALL'

quote:

---

Originally posted by sodeep

See this:
http://www.sqlservercentral.com/Forums/Topic546370-149-1.aspx

---

DECLARE @SQL VARCHAR(8000)
  SELECT @SQL = COALESCE(@SQL+'  UNION ALL'+CHAR(10),'')
      + REPLACE(
' SELECT ''**DBName**'' AS DB_Name,
        fundtransactionsource, createdbyuserid, fundtransactiontype,verifieddatetime,transactionid, 
        fundtransactionlineno, postingdate, tradedate, creationdatetime, fundid, accountnumber, 
	fundtransactionstatus, grossamount, netamount, shareamount
   FROM **DBName**..Fundtransactionlines
   WHERE postingdate = ''12/08/08'' 
   AND createdbyuserid NOT in (2,37,38,335)
   AND verifieddatetime is null'+CHAR(10),
        '**DBName**',Name)
   FROM master..Sysdatabases
   WHERE name like 'AMD%'

   PRINT (@SQL)

   EXEC (@SQL)