Professional Web Applications Themes

t-sql - Microsoft SQL / MS SQL Server

Hi I have table with below sql. Is there any way we can get result with hori..... and also with out creating temp tables or perm tables in one select statment. Thx create table test (month1 varchar(10),num int) insert test select 'march',3 select * from test month1 num ---------- ----------- jan 1 feb 2 march 3 Output need: jan feb march 1 2 3...

  1. #1

    Default t-sql

    Hi
    I have table with below sql.
    Is there any way we can get result with hori.....
    and also with out creating temp tables or perm tables in
    one select statment.
    Thx


    create table test (month1 varchar(10),num int)
    insert test select 'march',3
    select * from test
    month1 num
    ---------- -----------
    jan 1
    feb 2
    march 3


    Output need:
    jan feb march
    1 2 3
    sri Guest

  2. #2

    Default Re: t-sql

    WHAT THE H IS HORI

    "sri" <com> wrote in message
    news:053701c35180$8044eb90$gbl... 


    Tammy Guest

  3. #3

    Default Re: t-sql

    sri
    create table #t
    (
    month1 char(3),
    num int
    )

    insert into #t values ('jan',1)
    insert into #t values ('feb',2)
    insert into #t values ('mar',3)

    select max(case month1 when 'jan' then num end) 'jan',
    max(case month1 when 'feb' then num end) 'feb',
    max(case month1 when 'mar' then num end) 'mar'
    from #t


    "sri" <com> wrote in message
    news:053701c35180$8044eb90$gbl... 


    Uri Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139