Thanks Phill.

I think i was able to make the query.

I was using join in wrong order as i should use Dev as driver table instead of addrs in join conditions....

• This reply was modified 5 years, 5 months ago by  pdsqsql.

Thanks Phill for your quick response.

Is it anyway you can guide to join Multiple tables from two databases?

I am trying with CROSS JOIN and also LEFT OUTER  JOIN.

I think Table...

I ran the query using your formatted query but it's just executing (running almost 7 minutes and still running) as looks like because of the CROSS JOIN, it's doing Cartesan...

Thanks for your response.

with column, it was throwing error when i tried to use CROSS JOIN so i just use schema and database name.

You can ignore the error as if...

Thanks Rookie.

This is our newly build Data warehouse and we are trying to load data from source DBs to destination DB-Staging DW.

Once it's loaded then we will be loading into...

Thank you all for your help!

Thanks everyone!

Thanks Sue.

What should be the ideal files and File size for small Sql Data Warehousing?

Thanks.

So i should use windows Group login and then create the Schema or i can use my windows login (i am part of that windows group) and create the schema?

That...

I'm planning to create like below but What will be the ideal DB script should be for Data Warehouse?

USE master;

GO

CREATE DATABASE ETLDB

ON

PRIMARY

(NAME = ETLDB_Dat1,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\ETLDB_dat1.mdf',

SIZE =...

Got it!

What do you prefer more AD account or sql user DB Owner?

Thank you!

Thanks Sue.

I know that as i have done couple of times but my question is when we have built the servers new and have to create the new databases and...

Sorry about it but your really appreciated!

Hi Alen,
I have posted table script, if it's what you are looking to help me out.
I tried with different way but getting some errors. Problem is when i...

Thanks but not sure about OUTPUT clause,  I will google it but if you have example that will be great.