s12

 Excel Data Overview

Step 1. Follow the mapped columns in below link . we have written for you . 

Excel Link: Excel

Step 2. You need to run below query in your ssms to find the columns name 

SELECT 

    table_catalog,

    table_schema,

    table_name,

    column_name,

 FROM 

    information_schema.columns 

WHERE 

      column_name LIKE 'CONSULTANT%'; -- as per the excel not found columns

/*-- Replace 'your_partial_column_name' with the partial or full column name you're searching for*/

Step 3. 

You need to serach one by one by changing where condition  values ( column name one by one). Excel has 46 columns, so you need to performance serach by 46 times. 

Step 4. Once you find some columns you can note down in excel table name , column name.

Step 5. Try to run the query like " select * from step 4 table 1"

Step 6. Look if there any columns available from below list so we can bring the join from the newly found table with   "FactTMFormDataDetail "

OperatorID Key

TaskID

DocumentID

RegionCode

OpratorID

Sample: 

select "missingcolumn1"  * from 

     FactTMFormDataDetail ft join 

    "newfoundtable" nt 

     on ft.DocumentID = nt.DocumentID

now more tables we can keep joining if we found the mapping keys.. 

Step 7. Now keep udpating the excel and it is done once you search allcolumn one by one.

Step 8. Now draft an email and send it

-----------------------------

Hello ,

I have search column names in entire database , I have not found all the columns. I am attaching the list. Can you pleae help me where I can get these missing columns. I have also attached query which are used to find column names. Also, for some  of the columns are found but unable to find mapping columns to bring data wtih FactTMFormDataDetail. 

add attachment :

script 

excel ( after you done wtih analysis)

 ------------------------------------