Professional Web Applications Themes

sequence number in a view - Microsoft SQL / MS SQL Server

[url]http://www.aspfaq.com/2427[/url] "Max" <alvarez-matt.net> wrote in message news:01d601c3417d$c083b3c0$a101280aphx.gbl... > Hi folks, > > I' like to display a sequence number in a view, something > like: > > Name SeqNo > ==== ===== > John 10 > Peter 20 > Mary 30 > > > Does anyone know how to generate a sequence number? > > Best Regards, > Max. > >...

  1. #1

    Default Re: sequence number in a view

    [url]http://www.aspfaq.com/2427[/url]



    "Max" <alvarez-matt.net> wrote in message
    news:01d601c3417d$c083b3c0$a101280aphx.gbl...
    > Hi folks,
    >
    > I' like to display a sequence number in a view, something
    > like:
    >
    > Name SeqNo
    > ==== =====
    > John 10
    > Peter 20
    > Mary 30
    >
    >
    > Does anyone know how to generate a sequence number?
    >
    > Best Regards,
    > Max.
    >
    >

    Aaron Bertrand - MVP Guest

  2. #2

    Default Re: sequence number in a view

    if name column has unique values you can try following

    select
    (select count(distinct name) from table where name <= a.name) * 10 RANK,
    name
    from table a

    Also refer to following url

    HOW TO: Dynamically Number Rows in a Select Statement
    [url]http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133[/url]

    --
    -Vishal
    "Max" <alvarez-matt.net> wrote in message
    news:01d601c3417d$c083b3c0$a101280aphx.gbl...
    > Hi folks,
    >
    > I' like to display a sequence number in a view, something
    > like:
    >
    > Name SeqNo
    > ==== =====
    > John 10
    > Peter 20
    > Mary 30
    >
    >
    > Does anyone know how to generate a sequence number?
    >
    > Best Regards,
    > Max.
    >
    >

    Vishal Parkar Guest

Similar Threads

  1. RAND() generating same number in rapid sequence
    By Jim Michaels in forum MySQL
    Replies: 2
    Last Post: April 25th, 09:02 PM
  2. Gap Sequence
    By Rita in forum PERL Modules
    Replies: 6
    Last Post: November 16th, 09:28 PM
  3. sort from the smallest number to the highest number
    By Boon Chong Ang in forum PERL Beginners
    Replies: 3
    Last Post: January 30th, 03:00 PM
  4. Sequence Number Generator in IDS 9.4
    By Cindy Lichtenauer in forum Informix
    Replies: 5
    Last Post: October 15th, 11:14 PM
  5. Wierd error when going to Design View from HTML view
    By VB Programmer in forum ASP.NET General
    Replies: 1
    Last Post: July 10th, 03:20 PM

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