SQl Server field anlysis, SP, Stored procedure

Hello We need a SQl Server Stored procedure to analyse some tables. We will have 2 tables with parameters that you will use. Table1 Name of tables to process You will have more then one record in this table. You have to process all of them. Table2 Table name (same as before) FieldName In this second table you will have 2 fields. For each table1 record, you can have form 0 to many records in table2. Example: Suppose that in table1 you have the record “Contact”. So you know you are going to process the table “Contact” 1st step You will create a new table with the same fields as “Contact” but with ALL field type=varchar(500). If the table already exist, you will drop and create it again. The new table name will be "original name"+"_Output". For our example it will be "Contact_Output" 2nd step You will populate the new table with the values we have in the original table, but with some changes: a) If a field/record is empty or ‘’ or len[field]<1, then you will populate the value “Empty” b) if in table2 a field is mentioned (for example [contact].[Name], then you will populate the value “filled”. This is because we do not want all "name" in our report. c) In other cases you will copy the original value. Our output will be one table for each record in table1. The output table will have the same row count as in original table. 3rd step You will add a new field “CountOutput” with the value 1. This is a a internal field I will se to count records. With this structure, I can count empty values, filled values or make some pivoting.