Professional Web Applications Themes

Grouping in SQL server 7.0 - Microsoft SQL / MS SQL Server

I am trying to get weekly and monthly rolling totals in a query that I am doing. Is there something similar to compute and compute by from 2000 in 7.0...

  1. #1

    Default Grouping in SQL server 7.0

    I am trying to get weekly and monthly rolling totals in a
    query that I am doing. Is there something similar to
    compute and compute by from 2000 in 7.0
    Guy Brown Guest

  2. #2

    Default Re: Grouping in SQL server 7.0

    COMPUTE & COMPUTE BY are in SQL 7.0 & 2000, though provided only for
    backward compatibility. However it is still recommended that you use ROLLUP
    & CUBE clauses for generating report-style resultsets that contain subtotals
    and totals.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

Similar Threads

  1. help with grouping
    By rere in forum Coldfusion - Advanced Techniques
    Replies: 4
    Last Post: July 21st, 08:41 PM
  2. Grouping Problem
    By Heather939 in forum Macromedia ColdFusion
    Replies: 4
    Last Post: June 14th, 08:03 PM
  3. Font grouping under OS X
    By Martin Sammtleben in forum Macromedia Freehand
    Replies: 5
    Last Post: May 24th, 12:27 PM
  4. Grouping
    By SRam in forum Informix
    Replies: 2
    Last Post: August 28th, 02:54 PM
  5. Grouping....SQL Server or VB Code?
    By CR Douglas in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 4th, 06:14 AM

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