Post reply

sql copying column attributes of one table to another table

  • May 16, 2013 at 4:48 am

    #293968

    i have 2 tables

    one call it as dbo.t1 and another dbo.t2

    t1:

    P1 S1 B1 H1 S2 J1

    ______________________________

    b1 s1 b1 s1 b1 s1 ----these are the merged columns (like: H1 has b1 & s1, S2 has b1 & s1,

    ----------------------------------- J1 has b1 & s1)

    pj1 sk1 bu1 2 4 0 2 1 3 --- these r d values in d table

    t2:

    P1 S1 B1 Fun Val Loc

    ___________________________________

    pj1 sk1 bu1 H1 2 b1

    pj1 sk1 bu1 H1 4 s1

    --- --- --- S2 0 b1

    --- --- --- S2 2 s1

    --- --- --- J1 1 b1

    --- --- --- J2 3 s1

    t1 is the imported table from excel and t2 is the disired output table i need the column names of t1 as values in t2..

    please help me out

  • May 16, 2013 at 5:16 am

    #1615695

    There is no need to duplicate post.

    All replies better to go to original one:

    http://www.sqlservercentral.com/Forums/Topic1453408-391-1.aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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