Penguins are my favorite animals and other RANDOM thoughts

Re: Penguins are my favorite animals and other RANDOM though

Unread postby Soren » Mon Sep 28, 2015 20:40:27

1) Sitting in class
2) SQL cursors are bad and the syntax is fucking gross
3) Challenge problem assigned
4) I solve the problem:

Code: Select all
CREATE OR REPLACE FUNCTION total_pounds_ordered_sf
(
  lv_idbasket bb_basketitem.idbasket%TYPE
)
RETURN NUMBER
IS
  lv_pounds_ordered NUMBER(36,2);
BEGIN
  SELECT SUM(lbs)
  INTO lv_pounds_ordered
  FROM (
    SELECT CASE
      WHEN OPTION1 = 1 THEN QUANTITY * 0.5
      WHEN OPTION1 = 2 THEN QUANTITY
      ELSE 0 END AS lbs
    FROM bb_basketitem
    WHERE idbasket = lv_idbasket
  );
RETURN lv_pounds_ordered;
END;


5) Teacher says no but we didn't use CASE statements recently...use cursors.

tl;dr this is the worst teacher I've ever had.
Olivia Meadows, your "emotional poltergeist"

Soren
Plays the Game the Right Way
Plays the Game the Right Way
 
Posts: 39874
Joined: Thu May 28, 2009 13:44:19
Location: area x

Re: Penguins are my favorite animals and other RANDOM though

Unread postby mickbayne » Mon Sep 28, 2015 20:55:44

My bank reimburses me for all ATM fees but they got bought out by another bank that doesn't do that so now I need a new bank. USAA is the leading contender.
Another day, another box of stolen pens.

mickbayne
BSG MVP
BSG MVP
 
Posts: 5882
Joined: Sat Dec 30, 2006 02:13:43
Location: Tipsy McStagger's Good Time Drinking and Eating Emporium

Re: Penguins are my favorite animals and other RANDOM though

Unread postby Bucky » Mon Sep 28, 2015 21:00:15

i just use wells fargo because their ATM's are EVERYWHERE (except brigantine!)

er, I mean BECAUSE MCNEAL!

Bucky
BSG MVP
BSG MVP
 
Posts: 58018
Joined: Fri Dec 29, 2006 19:24:05
Location: You_Still_Have_To_Visit_Us

Re: Penguins are my favorite animals and other RANDOM though

Unread postby mickbayne » Mon Sep 28, 2015 21:03:55

The closest ATM at work is Wells Fargo but at home it's Santander or Cardtronics or something. I've just gotten used to not having to worry about paying fees ever so def wanna stick with a bank that reimburses.
Another day, another box of stolen pens.

mickbayne
BSG MVP
BSG MVP
 
Posts: 5882
Joined: Sat Dec 30, 2006 02:13:43
Location: Tipsy McStagger's Good Time Drinking and Eating Emporium

Re: Penguins are my favorite animals and other RANDOM though

Unread postby jamiethekiller » Mon Sep 28, 2015 21:07:26

PNC reimburses. They're popular. And their on-line game is very strong

jamiethekiller
Plays the Game the Right Way
Plays the Game the Right Way
 
Posts: 26938
Joined: Sun Dec 31, 2006 03:31:02

Re: Penguins are my favorite animals and other RANDOM though

Unread postby PrattRules » Mon Sep 28, 2015 21:07:48

mickbayne wrote:The closest ATM at work is Wells Fargo but at home it's Santander or Cardtronics or something. I've just gotten used to not having to worry about paying fees ever so def wanna stick with a bank that reimburses.


You should be able to find at least five banks that won't charge you a fee, provided you maintain a certain balance or have a monthly deposit. Wells Fargo is everywhere. PNC is everywhere, thanks to Wawa. Santander has that extra 20 checking.
"Just remember, it's not a lie if you believe it." -George Costanza

PrattRules
Space Cadet
Space Cadet
 
Posts: 16564
Joined: Tue Sep 29, 2009 20:38:24
Location: Northeast Philly

Re: Penguins are my favorite animals and other RANDOM though

Unread postby TenuredVulture » Mon Sep 28, 2015 21:25:36

In this day and age, how important are ATMs anyway? You can use your debit card for almost everything, and if you do need cash, just go and buy something at a grocery store and take out an addition $50 or whatever.
Be Bold!

TenuredVulture
You've Got to Be Kidding Me!
You've Got to Be Kidding Me!
 
Posts: 53243
Joined: Thu Jan 04, 2007 00:16:10
Location: Magnolia, AR

Re: Penguins are my favorite animals and other RANDOM though

Unread postby The Dude » Mon Sep 28, 2015 21:27:18

they usually have maximum cashback amounts, and there are plenty of bars/restaurants/hairdressers/etc that are cash only
BSG HOF '25

The Dude
BSG MVP
BSG MVP
 
Posts: 30280
Joined: Thu Dec 28, 2006 23:04:37
Location: 250 52nd st

Re: Penguins are my favorite animals and other RANDOM though

Unread postby Slowhand » Mon Sep 28, 2015 22:02:09

Current status: tipsy
How dare you interrupt my Lime Rickey!

Slowhand
Plays the Game the Right Way
Plays the Game the Right Way
 
Posts: 30278
Joined: Fri Jan 12, 2007 04:26:24
Location: Flattening the curve

Re: Penguins are my favorite animals and other RANDOM though

Unread postby mickbayne » Mon Sep 28, 2015 22:29:47

I end up using ATMs maybe like three to five times a month. Don't really do the cash back with debit card purchase thing because I prefer to use a rewards credit card anywhere that accepts cards. Looks like PNC has a $200 promo right now for new Virtual Wallet accounts so i'll probably give that a try. Thanks jamie!
Another day, another box of stolen pens.

mickbayne
BSG MVP
BSG MVP
 
Posts: 5882
Joined: Sat Dec 30, 2006 02:13:43
Location: Tipsy McStagger's Good Time Drinking and Eating Emporium

Re: Penguins are my favorite animals and other RANDOM though

Unread postby Bill McNeal » Mon Sep 28, 2015 22:41:30

My 401k just dropped by $2.00 :(
man I drew all these penises for nothing - housh

Bill McNeal
BSG MVP
BSG MVP
 
Posts: 27673
Joined: Thu Dec 28, 2006 21:05:24
Location: A Place To Be Somebody

Re: Penguins are my favorite animals and other RANDOM though

Unread postby z ipper » Mon Sep 28, 2015 22:42:02

santander has a nice checking account that give you $20/month if you use direct deposit and bill pay. can use the atm at cvs too.

z ipper
Dropped Anchor
Dropped Anchor
 
Posts: 8241
Joined: Thu Dec 28, 2006 20:08:32
Location: eat less bats

Re: Penguins are my favorite animals and other RANDOM though

Unread postby WheelsFellOff » Mon Sep 28, 2015 22:47:58

I use Fulton because they're a two-block walk from my apartment. It's probably a longer walk for you though.
So far the Eagles have been unable willing to at least make a good will jester - Garry Cobb, Professional Sportswriter

jerseyhoya wrote:My hatred of quote boxes in signatures has reached a new high

WheelsFellOff
Plays the Game the Right Way
Plays the Game the Right Way
 
Posts: 27290
Joined: Thu Mar 25, 2010 13:43:13
Location: Bologna

Re: Penguins are my favorite animals and other RANDOM though

Unread postby Slowhand » Tue Sep 29, 2015 05:31:01

Been off the last two days and have found myself wide awake at 5:00 am both days. What the heck?
How dare you interrupt my Lime Rickey!

Slowhand
Plays the Game the Right Way
Plays the Game the Right Way
 
Posts: 30278
Joined: Fri Jan 12, 2007 04:26:24
Location: Flattening the curve

Re: Penguins are my favorite animals and other RANDOM though

Unread postby SK790 » Tue Sep 29, 2015 05:51:26

Classic case of stink bugs
I like teh waether

SK790
Plays the Game the Right Way
Plays the Game the Right Way
 
Posts: 33040
Joined: Thu Dec 28, 2006 23:12:01
Location: time is money; money is power; power is pizza; pizza is knowledge

Re: Penguins are my favorite animals and other RANDOM though

Unread postby CalvinBall » Tue Sep 29, 2015 06:54:22

Take zzquil next time

CalvinBall
You've Got to Be Kidding Me!
You've Got to Be Kidding Me!
 
Posts: 64951
Joined: Mon Jul 30, 2007 15:30:02
Location: Pigslyvania

Re: Penguins are my favorite animals and other RANDOM though

Unread postby Woody » Tue Sep 29, 2015 12:12:52

There are about 5 of you who never fail to lessen my enjoyment of BSG
you sure do seem to have a lot of time on your hands to be on this forum? Do you have a job? Are you a shut-in?

Woody
BSG MVP
BSG MVP
 
Posts: 52472
Joined: Thu Dec 28, 2006 17:56:45
Location: captain of the varsity slut team

Re: Penguins are my favorite animals and other RANDOM though

Unread postby The Dude » Tue Sep 29, 2015 12:13:51

:oops:
BSG HOF '25

The Dude
BSG MVP
BSG MVP
 
Posts: 30280
Joined: Thu Dec 28, 2006 23:04:37
Location: 250 52nd st

Re: Penguins are my favorite animals and other RANDOM though

Unread postby Soren » Tue Sep 29, 2015 12:37:31

The Dude wrote::oops:
Olivia Meadows, your "emotional poltergeist"

Soren
Plays the Game the Right Way
Plays the Game the Right Way
 
Posts: 39874
Joined: Thu May 28, 2009 13:44:19
Location: area x

Re: Penguins are my favorite animals and other RANDOM though

Unread postby CalvinBall » Tue Sep 29, 2015 13:17:09

Woody wrote:There are about 5 of you who never fail to lessen my enjoyment of BSG


name names

CalvinBall
You've Got to Be Kidding Me!
You've Got to Be Kidding Me!
 
Posts: 64951
Joined: Mon Jul 30, 2007 15:30:02
Location: Pigslyvania

PreviousNext