Recent content by Semidevil

I currently use 2x 24inch HP monitors. While it’s nice, I’m wondering if a single wider screen monitor is enough. I’ve also tried using a single screen (24inch) + my laptop screen(13 inch), and I think it should be enough. The only annoying thing is I can’t get them aligned quite right. I do...

I have 1 work laptop (windows) and a school laptop (macbook). when I use either one, they would be connected to my dual monitors. the windows PC has 1 hdmi to my first monitor, and an adapter to connect to a vga to my second monitor. The macbook is usb c, so I'm using both c and using an...

What is the best way to maximize results if I have 15 minutes per morning for a dumbbell routine? I'm able to exercise 5-7 days per week and my morning consists of 15 minutes treadmill + 15 minutes dumbbells. The apartment gym has only dumbbells up to 40lbs, but I'm not worried because right...

Thanks. If I'm correct, I believe the two options are for sql server? I'm stuck with oracle sql developer. I did manage to connect to sqlplus, which is the command line equivalent. However, my query is rather large with lots of variables and pivots, so it won't accept my variable which...

im trying to automate some of my tasks and one of the objective is to run a sql developer query and export the result. I'm using the spool function so as soon as I run it, it will automatically export, but is there a way for sql dev to automatically run the sql query on a weekly basis( in the...

Thanks for the feedback. The end result of what I want it to look like, is for it to automatically(or on a schedule) send an email to a group of people with either and attachment or a link. All the elbow work will consist of things like: logging in to external sites to retrieve data...

My goal is to be able to learn to write some scripts to automate my reports for work. The end result would be to push as little buttons as possible to be able to do things such as copy files from one place to the next, run SQL query, open/update excel sheets, log in and grab data from various...

if the watch series 1 is constantly paired to my phone, does it do a pretty accurate job in terms of tracking distance, steps, incline, GPS etc etc I see the benefit of the watch 2 having its own GPS, but for someone who always has his phone with him, Will the watch 2 still be more accurate?

I'm not sure. I saw a couple threads in the Logitech forum saying not all keys work

I use a lot of windows excel shortcuts at work and when I log into windows from my Mac via Bootcamp, I want to be able to work in the same way and same button combinations. My MacBook Air is obviously missing certain keys as compared to a full size windows desktop (I.e, pg down, end, etc...

Thanks for all replies. For me personally, it's important to have something that is portable and light weight, hence the reason I'm not considering the MBP. The Mac air is certainly portable enough, but If I can control it, I don't want to buy a machine that looks exactly the same as the one...

I currently have a mid 2010 13 inch MacBook Air. It has 1.8ghz Intel core 2, 2gb ram, and 128ssd. The 12 inch MacBook is a 1.1ghz(turboboost up to 1.8), 8 gb ram, and 256 ssd. Since the processor of the new Mac is equal to or lesser than my current MacBook, but has 4x more ram, will I...

Thanks. That makes sense. Now, when I do a group by, it gives me an 'invalid column name," and it is pointing to all my group by lines. (I realize I need the aggregate functions. These are all in my code)

I have a ''student" table I want to join with an "ID" table. The "ID" table has 3 columns: "code" (I.e xxx), "sub code" (xxx-yy), and "type" (I.e, "aaa" or "bbb"). My issue is I want to left join by "xxx" when type = "aaa" and join by "xxx-yy" when type = "bbb". How do I join with...

Thanks. So right now, what I'm trying to achieve is to update the report once, and have it all compiled in one table. Let's say I update the report weekly. The current situation is that I would open up the query on table 1, update the date, review it in excel. For table 2, I would update...