Thank Guy's 

This is going to take me some time to implement. I will let everyone know what happens.
Thanks,
David

Hi Jeff, and frederico,

This is functionally as a DW. 

Here is the result for the query, I had to type 

The two queries look like one query. It is dedicated standard edition, 2014 database is runing in 2012 compatiblity, 2 processor 16 core each
RAM 512GB. Storage is on NetApp.

The above table is 5 results from a the above query. I just have taken the top 1 record from each number field the database file is 13 TB +

Hi Jeff and Sue,
Yes the 13 TB file is the mdf file. I just started working with the database yesterday. The last batch had growned the data base from...

Thank You, Sue and Ryan
The database is 13 TB in size already. They do alot of batch loading! I know that i am going to have to add a...

Hi All,
My
Where Clause does not seem to work correctly.
It works on first use but it keeps adding an duplicate entry not susre why.
I am going to...

Hi Allen,
Thank You for the reply. I used your reply as a research topic. I found more detailed answers on other sites as well as SSC. Here is my...

Hi Lynn,
Thanks for the response! I ended up changing the Table Type and stored procedure
Here is the table type:
CREATE TYPE [dbo].[Test_IMS_ADUSER_TMP] AS TABLE(
    [EmployID] [bigint]...

Hello Steve,

I than you for the Dynamic query it works. Once I added a few primary keys to the DB and added several covered indexes.
The query above...

This doesn't do the trick either. I got both of these queries from the site mentioned above.
This seems like it shoulf be a straight forward kind of thing.The first...

Well Basicly, I want a catch all query. I am to create a report that get all values from the query and if the user wants to use one or...

HI Sue

It does not appear to be insync that is good. I do not have the rights to do much of anything here.
I created the DEV environment...