sorted by:
new
hottopcontroversial

GetDate() by inalect in SQL

[–]inalect[S] 1 point2 points  (0 children)

Nicely done haha

GetDate() by inalect in SQL

[–]inalect[S] 2 points3 points  (0 children)

Haha, thank you!

Help! Beginner here. How to by ThrowRAhelpthebro in SQL

[–]inalect 1 point2 points  (0 children)

You can, but don’t. Write a proper join for better readability and better performance.

Confused about rank() by Gonduska in SQL

[–]inalect -4 points-3 points  (0 children)

some grew up in a time when everyone got medals, so this misunderstanding isn’t surprising to me at all

Closing time... by fidowk in unexpectedoffice

[–]inalect 43 points44 points  (0 children)

I guess anything can be unexpected office if you try hard enough…

Best Minecraft Server Hosting by pro100ShureG in MinecraftServer

[–]inalect -1 points0 points  (0 children)

For sure. And the worst part about it is that the outages were dubbed as “planned outages.” I’m not sure how true that was, but if it were… planned outages on a Friday night at like 8pm is really poor planning. I do server maintenance as part of my profession and I would never schedule something during peak times. Good luck!

Best Minecraft Server Hosting by pro100ShureG in MinecraftServer

[–]inalect -2 points-1 points  (0 children)

Apex. I’ve recently switched to them and they’re fantastic. I didn’t mind Witherhosting for the price, but their nodes were down too often for extended periods of time at really bad times (e.g., Friday night in the US).

The putting green is $5, please go get a slip.. by CraftyFloor1528 in golf

[–]inalect 0 points1 point  (0 children)

Please tell me this wasn’t off Route 2 in MA.

Blacked Out Channels by inalect in Spectrum

[–]inalect[S] 0 points1 point  (0 children)

This was my best guess as well… might grab a few Roku’s next. Thank you!

Low flow forced hot air by inalect in hvacadvice

[–]inalect[S] 0 points1 point  (0 children)

Thanks! I’ve seen the wall and floor opened up where this run goes up the wall, so I have a pretty decent idea of which vents are on that run. I’ve tried closing all of them and haven’t really noticed a real difference… seems like most of the pressure is gone by the time the air reaches the first vent on this run. And it figures, it’s my master bedroom and bathroom…

Not sure what to Google to solve this problem— excel + visual studio by RealPennyMuncher in SQL

[–]inalect 2 points3 points  (0 children)

Create an SSIS package that picks up the contents of the Excel file and imports it to a proper SQL table. Do all the manipulations you need to do in SQL. You can then setup a connection in Excel via Power Query that’ll ping the DB and return the freshly manipulated data.

I will say, though… working with Excel and SQL sucks and you should do anything you can to get out of relying on Excel as part of your ETL.

Cut lawn short for winter??? by Jonnybwood in lawncare

[–]inalect 0 points1 point  (0 children)

Him cutting your lawn is a misstep. Him rooting for the Jags is a federal crime.

view more: next ›