Say it ain't so Joe. Which ANSI Standard should the OP use? The OP seems to have difficulty with how to join tables even though he knows the...


RESTORE DATABASE YourDB FROM DISK='Path to backup here'

If you want to overwrite an existing database

WITH REPLACE

If you need...

If the columns ending with "ID" are the related columns:

SELECT
     EmpID
   , StdID
   , HRID
   , RecDate
   , RecDate
   , VaFrmDate
   ,...

We need more info to respond, like; Do these tables have a relationship to each other? We would just be making a guess otherwise.

I think what you want is something like:

IF EXISTS(SELECT * FROM sys.tables WHERE name = 'Orders')
    SELECT *
    FROM Orders;


Use SQL Server's IsNull Function for each column in the select list which means you have to list the columns not SELECT *.

SELECT
     IsNull(mailAddress, ' ') AS...

Are you inserting the data in from a query in each database, iQMPlatformDemo , iQMPlatformDemo_1, iQMPlatformDemo_2... into a table in iQMGlobal?
Try:

DECLARE
     @sql1 nvarchar(100)='USE ?'
   , @sql2...

What do you want the procedure to do? Insert some data in a table from tables in a set of databases on your SQL Server Instance? Please remember we know...

Can you please explain again what you want to accomplish?

You don't need to create it, it still ships with SQL Server. You can use it to do what you want calling it from your code.

I would try using sp_MSForEachDB

Why not create a stored procedure or inline table function?