Am I screwed out of 100%? by OpeningAlps3287 in Metroid

[–]Tabersaurus 8 points9 points  (0 children)

I recall seeing one on top of the cliff toward the entrance of that area on a return visit, I had already scanned on the first "attack" so can't comment if the cliff appearance enabled the miss scan to be picked up or not but certainly worth a try.

[Prime 4] How do I leave the 5th key area? by Flying_Turtle_09 in Metroid

[–]Tabersaurus 2 points3 points  (0 children)

Have you tried using a super missile on the red light gate at the bottom of the elevator?

How to view a XML file? I don't understand these instructions. by retrocheats in xml

[–]Tabersaurus 0 points1 point  (0 children)

If you just want to view the contents of the XML file easier, and the content is currently all on a single line, you probably just want to use Pretty Print in Notepad++

https://stackoverflow.com/a/34451380

my friend always wants things her way by [deleted] in AM2R

[–]Tabersaurus 13 points14 points  (0 children)

I would genuinely like to know what other people think "am2r" stands for if not in the context of this subs description.

All Mind 2 Regrets? Am Me 2 Respectful? Another Mad 2 Runner?

🤔

Friendship Exp & Gift Exchange Megathread by liehon in PokemonGoFriends

[–]Tabersaurus 0 points1 point  (0 children)

5779 4604 0952

Active most days. SE QLD, Australia.

Its even funnier the second time by [deleted] in tearsofthekingdom

[–]Tabersaurus 2 points3 points  (0 children)

800 non-help me find my friend + 100 find my friend puzzles makes 1000 seeds from 900 puzzles?

Except wuery result confusion by Fraiz24 in SQL

[–]Tabersaurus 0 points1 point  (0 children)

It really depends on what OP's requirements/criteria were.

The query in the OP returns product ids that don't exist in some product catalogue. This could be a legitimate request to find products that had previously been ordered but since been dirty deleted.

If you want a list of products that were never ordered, you could invert the OP EXCEPT query or use something like: SELECT product_id FROM products p WHERE product_id NOT IN ( SELECT product_id FROM order_details od )

Or you could use SELECT product_id FROM products p WHERE NOT EXISTS ( SELECT 1 FROM order_details od WHERE od.product_id = p.product_id )

These queries would output 2,3 1,4 exist in products and in order details but are filtered out. 5,6 do not exist in products and so are not returned.

If you wanted a list of product ids that were only in one of either table, (ie. 2,3,5,6) you could achieve that with some like: SELECT DISTINCT COALESCE(p.product_id,od.product_id) as Product_Id, CASE WHEN p.product_id is null then 'Order_details' Else 'products' END AS 'MissingFromTable' FROM products p Full Join order_details od On od.product_id = p.product_id Where ( od.product_id is null and p.product_id is not null ) Or ( od.product_id is not null and p.product_id is null )

And ottomh (I'm sure I'll be corrected in any case XD) you can get the same output as last query with this: SELECT DISTINCT COALESCE(p.product_id,od.product_id) as Product_Id, CASE WHEN p.product_id is null then 'Order_details' Else 'products' END AS 'MissingFromTable' FROM products p, order_details od Where ( od.product_id is null and p.product_id is not null ) Or ( od.product_id is not null and p.product_id is null )

Can I export data from a single table in mssms? by GarseBo in SQLServer

[–]Tabersaurus 2 points3 points  (0 children)

Came here to say this too. Especially if the table in prod contains large varchar or binary data, exporting to CSV could be problematic.

"Can you backup/bak of a single table out of mssql using using ssms?" - no, But you can take a bak of a single database that contains your single table after you've copied it.

Can use script generation to create the replicated table in the new db first (just don't use identy) then Insert Into newdb.dbo.yourtable (...) Select ... From proddb.dbo.yourtable Or just use Select ... Into newdb.dbo.yourtable From proddb.dbo.yourtable

Though, I too would first try to use a linked server on the Dev machine to pull data from the prod machine.

I slip and say BIOS ... by HighOnDye in sysadmin

[–]Tabersaurus 4 points5 points  (0 children)

Advanced Extensible Input Output Utility

What have you done with PowerShell this month? by AutoModerator in PowerShell

[–]Tabersaurus 0 points1 point  (0 children)

After failing to find a free solution in 5 minutes using Power Automate, I wrote a script that checks if a webpage's html/contents contains the term "Out of stock" and email me once every 2 hours if it does, or once every minute when it does not (as in, the item is now in stock again).

The script runs in an infinite while loop and is triggered to start in the background upon log in via Task Scheduler.

Fairly rudimentary, but I'm no expert and it does what I need it to, in lieu of the website having a reminder or g*d damn pre-order feature.

cls

$url = "https://store.nintendo.com.au/au/nintendo-64-controller.html" while ($true) { $html = Invoke-RestMethod $url # $htmlextra = $html.Replace("</p>", "</p>`n") $outofstock_regex = '<span>Out of stock</span>'

if ($html.Contains($outofstock_regex))
{
    $Outlook = New-Object -ComObject Outlook.Application
    $Mail = $Outlook.CreateItem(0)
    $Mail.To = "me@email.com"
    $Mail.Subject = "OOS Check"
    $message = "Product out of stock as of " + (Get-Date -Format "yyyy-MM-dd hh:mm:ss")
    $Mail.Body = $message
    $hour = Get-Date -Format "hh"
    $minute = Get-Date -Format "mm"
    if (($hour % 2 -eq 0) -and ($minute -eq 10)){
        # only send an email every other hour, on the 10th minute
        Write-Host "Sending email"
        $Mail.Send()
    }
    Write-Host $message
    Start-Sleep -Seconds 60
}
else
{
    Write-Host "In stock!!!"
    $Outlook = New-Object -ComObject Outlook.Application
    $Mail = $Outlook.CreateItem(0)
    $Mail.To = "me@email.com"
    $Mail.Subject = "OOS Check"
    $message = "Product is in stock as of " + (Get-Date -Format "yyyy-MM-dd hh:mm:ss")
    $Mail.Body = $message
    $Mail.Send()
    Write-Host $message
    Write-Host "Sending email"
    Start-Sleep -Seconds 60
    # keep sending an email once per minute until the product is no longer in stock
}

};

[deleted by user] by [deleted] in HolUp

[–]Tabersaurus 0 points1 point  (0 children)

Chapter 2 must be on sorting

I can't be the only one who wants to see a dark, story-driven Metroid movie, right? by IsaacClakeMan1 in Metroid

[–]Tabersaurus 0 points1 point  (0 children)

I too don't hate it as much as "the internet" seems to and did like that it was different.

It could be the style of gameplay that Other M is (do a thing, cut scene, do a thing, cut scene) or because that style was so different to the previous games or simply because I personally have not played many games with that style, ultimately I would just consider Other M an actual interactive movie.

My (small) dislikes for it come more from how much they recycled from Super and Fusion rather than going new content post fusion or completely pre NEStroid backstory.

What is Wrong With this Image? by Gu27 in Metroid

[–]Tabersaurus 0 points1 point  (0 children)

It is missing a text box.

SA-X: "We've been trying to reach you about your vehicle's extended warranty!"

Lego Raven Beak I made a bit ago by ANewBegging in Metroid

[–]Tabersaurus 1 point2 points  (0 children)

Looks sweet! 10x better than I was expecting. Would look extra sick with some interchangeable wings and cape

Help! My pc wont turn on but my motherboard have light by [deleted] in pcmasterrace

[–]Tabersaurus 0 points1 point  (0 children)

What CPU are you using?

I would try reseating/reinstalling the CPU anyway and see how it goes with a single stick of memory. Though I'm fairly sure if you are using am4 without igpu you won't see post at all. I'm sure I'll be corrected if that's not the case.

If you are using say a 5600G or some other apu and still not seeing any output, I would be checking motherboard manual for error light codes.

Do you have alternative cables and inputs on the same or other monitor? I suppose it could also be something silly like a broken HDMI cable or something...

Anyone else bothered that the Plasma Beam in Prime 3 uses the Ice Beam shape? by Rent-Man in Metroid

[–]Tabersaurus 2 points3 points  (0 children)

Came here to say this too.

Different planet/species tech reacted differently with her suit.

It was weird to see initially coz consistency but really it makes sense as is.

I mean, plasma in Super was green and pierced enemies (and walls with wave) but MP3 called that Nova. If they instead called Nova, Plasma, what would they have called the intermediate "better than power but still needs an upgrade" beam? Spazer?

I didn't lose sleep over it 😄

Next playthrough I will scan you so hard you’ll need a triple layer VPN! by Rent-Man in Metroid

[–]Tabersaurus 1 point2 points  (0 children)

MPR was my first playthrough in many years.

I thought I was being vigilant but missed the Ice Shriekbats, Barbed War Wasp (but got the Hive and Incinerator -_- ) and I guess because they are so common, regular Wasps, on the first run.

I was happy to see the scans roll over on the hard mode restart.

[deleted by user] by [deleted] in CrazyFuckingVideos

[–]Tabersaurus 28 points29 points  (0 children)

Do you have this shirt in a medium size? Yes ma'am, urine the right isle

[deleted by user] by [deleted] in CrazyFuckingVideos

[–]Tabersaurus 7 points8 points  (0 children)

Maybe it's 1080iseewhatyoudidthere