Viewing 15 posts - 91 through 105 (of 6,486 total)
As far as finding the offending character, your best bety might be.. to cheat 😛 . As in - export the data using BCP to a XML file and open the...
December 17, 2018 at 9:54 am
December 15, 2018 at 11:29 am
December 14, 2018 at 9:50 am
December 10, 2018 at 8:55 am
December 5, 2018 at 7:34 am
December 5, 2018 at 7:27 am
December 4, 2018 at 3:04 pm
Try breaking it into pieces:
with runningtotals as (
select part_id, [order],onhand, RequiredQuantity, sum (requiredQuantity) over (partition by part_id order by [order] Rows unbounded preceding) runningqty
from...
December 3, 2018 at 12:33 pm
December 3, 2018 at 7:30 am
December 2, 2018 at 1:35 pm
November 30, 2018 at 8:06 pm
November 30, 2018 at 5:14 pm
Viewing 15 posts - 91 through 105 (of 6,486 total)