Here is my take on the solution.  Let me know if you see any issues.

WITH    SortedData
AS    (
    SELECT    Id, Pro, Type, Qty1, Qty2, ModifiedDate,
        ROW_NUMBER() OVER (PARTITION BY...

One thing to check is whether the login used for the SQL Agent has permissions to see the table in question, and to use the sp_send_dbmail procedure, and to create...

I know the question has been answered, and the solution in this case did not need to run a statement on every database.  However, that functionality is sometimes needed, and...

I think you are trying to delete from Table1 where matching rows exist in Table2. If that is correct, then I think this is what you want:
delete...

The first thing to check is what indexes are being used to return data in each of the queries.  My guess is that there are good indexes in the transactional...

Look at the number of unique - distinct - values in the columns you are using.  If there are not records in the table that have the same value, then...

OK, attempt #2.  The CTE tells which rows are first and last in their block, the "Blocks" query puts those values into ranges, which can then be joined to the...

I took a stab at this one.  I needed sample data, so I generated it using the following code.  Because RAND is used with a predictable seed, the values will...

By the way, the above code assumes no nulls in the Reading and Consumption fields.  If there can be nulls, then the code should be adjusted to account for them...

SELECT    P_Number,
    Date,
    MAX(CASE WHEN Extension = '' THEN Reading ELSE '' END) + ';' +
    MAX(CASE WHEN Extension = 'P' THEN Reading ELSE '' END) + ';' +

I'll present two methods that I found to get the data.  Thanks for posting the DDL; it was very helpful to have something to use for testing.  If my solutions...

I don't understand what you mean by "versioning purpose".  Perhaps others don't either, which may be the reason that no one else has responded to your question.  Please explain further. ...

If you know the names of the 35 tables, you should be able to build your table first, with the 35 column names you want to use.
CREATE    --...