• You might have read the article but you missed the point. The idea is to provide tables and data in a consumable format. That means that the volunteers around here trying to help should be able to hit f5 and have a table populated with data. That way we can spend our time working on your issue instead of setting up the problem.

    Here is an example based on what you posted.

    if OBJECT_ID('tempdb..#Statistics') is not null

    drop table #Statistics

    CREATE table #Statistics

    (

    Status Varchar(30),

    Opco Varchar(30),

    Region Varchar(30),

    Country Varchar(30),

    Jan Decimal(3,2),

    Feb Decimal(3,2),

    Mar Decimal(3,2)

    )

    Insert #Statistics

    select

    'Absolute total',

    'OPCO1',

    'EMEA',

    'GB',

    0.3,

    1.3,

    0.7

    However, I have to agree with David. I don't think you are going to find much of a more efficient method of this than what he posted already. I can come up with some really convoluted ways of doing this but honestly what he posted is the simplest.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/