I am current;y using MSSQL 2005 express version with the compatibility level set at 90.
I have successdully run the quey and recieve the results in a grid but as soon as I enter this in a view window, SQL closes with the message that SQL has stopped working.
My view reads as follows
;with Oe_Comp_Ord AS (SELECT OrdNo_LineNo, OrdNo, CustNo, CustName, WineCode, WineDesc, Loc, OeQtyOrd, LotNo, LotQtyAlloc,
Row_number() OVER (partition BY OrdNo_LineNo ORDER BY OrdNo) AS rowid,
(CASE WHEN (Row_number() OVER (partition BY OrdNo_LineNo ORDER BY OrdNo) > 1)
ELSE OeQtyOrd END) AS NewQty
Any help would be good
View Complete Post