Skip to end of metadata
Go to start of metadata

This is the Landing Page

1 Comment

  1. Unknown User (hbfvpyr)

    My comment is actually a question and I'm not sure if this is the right place to post this. If we are using SQL Server 2008 R2, why can't we use, in a query

    the line, for example, sum(T1.[Quantity]) OVER (PARTITION BY T2.[FrgnName] ORDER BY T1.[ItemCode] Running_Total. The error that comes up is:

    1.) [Microsoft][SQL Server Native Client 10.0] [SQL Server]Incorrect syntax near 'order'.

    2). [Microsot][SWQL Server Native Client 10.0][SQL Server] Statement 'User-Defined Values' (CSHS) (s) could not be prepared.

    I am attempting to run a 'Running Total' on certain items that have been ordered for a certain 'CreateDate' period without having the running_total repeating on

    everyline like it does now. Thank you.