Post reply

Formatting help... Pivot?

  • January 12, 2009 at 4:43 am

    #129959

    Hi,

    Firstly, this is my first post so forgive me if its a little out of the ordinary 🙂

    Basically, I have a stored procedure that dynamically builds "custom properties" from within a series of tables. A standard result set would be:

    Property Name Property Value

    EmailAddress --- Myemail@myprovider.com

    MonthlyAmount --- 323.00

    NullableProperty ---- NULL

    The results of the stored procedure is a temporary table defined with a SQL_VARIANT data type in the property value column.

    What I want to do is format the results like a normal SQL query from a table, so to basically have the following format:

    EmailAddress MonthlyAmount NullableProperty

    myemail@myprovider.com - 323.00 --- NULL

    I've looked at the new PIVOT keyword, and wondering if you can help on how to do this?

    Thanks!

  • January 12, 2009 at 5:02 am

    #925187

    Yes you can achieve this using PIVOT!!

    Check out the BASIC example given in the following link:

    http://msdn.microsoft.com/en-us/library/ms177410.aspx

    -Vikas Bindra

  • January 12, 2009 at 5:12 am

    #925189

    You have to form the SQL like...

    SELECT [EmailAddress], [MonthlyAmount], [NullableProperty]

    FROM TableProperties T

    PIVOT( MAX( PropertyValue ) FOR PropertyName IN( [EmailAddress], [MonthlyAmount], [NullableProperty] ) ) P

    --Ramesh

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply