This is the Landing Page
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.