Group-By Across 2 Columns

• ftonyan

  Grasshopper

  Points: 23

  More actions

  January 26, 2011 at 8:39 am

  #232786

  Hi Thanks in advance for helping. Sorry if posted in the wrong place. I am new to the board.

  I have the following table:

  create table temp_vol (symbol nchar(10), dseqkey int, volume float)

  here are some values in the table:

  symbol dseqkey volume (no commas in the actual values)

  C20672 422,764,512

  F20672 47,144,600

  F20671 51,695,000

  C20671 371,950,496

  F20670 48,680,600

  C20670 654,208,512

  C20669 626,121,600

  F20669 93,489,504

  C20668 712,674,304

  The output I am seeking is a 2-day simple moving average ((volume dseqkey + volume dseqkey-1) / 2) for each symbol, for each dseqkey. I can get the moving average working for all symbols across one dseqkey. I can get the moving average working for all dseqkeys across 1 symbol. I cannot seem to get both working together.

  Thx again