Computing desk | ||
---|---|---|
< February 8 | << Jan | February | Mar >> | Current desk > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
Hey there!
I'm currently using Windows 10 on my laptop, and it sometimes just says "Your PC Ran into a Problem and Needs to Restart" on a blue screen with a :( face. It gives me error codes on the top-left of the screen, but they go by too fast to read.
This is the reason I hate Windows. Always in perpetual beta, and hard to fix bugs because of the closed-source nature.
Quick Quokka [talk] 16:47, 9 February 2022 (UTC)
C:\Temp\Bluescreen\
, navigate there and double-click on BlueScreenView.exe
. The entry at the top is the most recent. It should show you what the most likely cause of the crash is (and all the previous ones as well). Or the file may be completely empty - that's Win10 for you. If there is any info, you could try researching this on the interwebs, or post the result here (a simple copy and paste text job). Microsoft's own Debugging Tools for Windows are a complete pain in the arse. Best of luck. MinorProphet (talk) 08:57, 10 February 2022 (UTC)
I need to combine and summarize two different tables (sales and transfers) so that the output returns the time period, the product, and the total number of cases from those two tables. Currently I'm using a UNION ALL function that gets me 95% of the way there but falls down in that if the same product shows up on both tables in the same time period it returns two rows and I need it to combine into one. For example, let's say that we sold 100 potatoes in period 2 and transferred 60 potatoes in that same period, a standard union all would return two rows:
PERIOD_NO SKU_PRODUCT CASES
2 POTATOES 100
2 POTATOES 60
Whereas what I need to get back is:
PERIOD_NO SKU_PRODUCT CASES
2 POTATOES 160
Basically, I need it to be summarized the way that, say, an Excel pivot table would smoothly combine those quantities by period/product. I've got to think there's a way to do this. Searching online hasn't found the kind of thing I'm after, so I'm possibly not using the right terminology. Now, in theory, I could avoid the union all altogether by doing a convoluted outer join of some type with a list of all products and time periods, but that would be really inefficient since those tables would be absolutely massive. Any thoughts? Matt Deres (talk) 17:02, 9 February 2022 (UTC)
Sample SQL |
---|
The following discussion has been closed. Please do not modify it. |
UNION ALL SELECT SLS.PERIOD_NO, SLS.SKU_PRODUCT, SUM(SLS.INVOICED_CASES) as CASES FROM SALES_TABLE SLS WHERE SLS.PERIOD_NO <= 10 GROUP BY SLS.PERIOD_NO SLS.SKU_PRODUCT |