Profile

Cover photo
Steve Tarantola
695 followers|303,348 views
AboutPosts+1's

Stream

Steve Tarantola

Development  - 
 
I am hoping for some guidance that will point me in the right direction regarding balancing inventory with an expiration date.
I looking to know how many of each 'flavor' I have left in inventory and the expiration dates of the inventory
All items received are time stamped and I capture the expiration date (ie. qty 300 exp_date 7/04/14, qty 200 exp_date 7/14/14) 
All orders processed are time stamped (qty 200 6/27/14), so I could sum up the orders processed in a given day/week or whatever.
How would I begin to set up a solution (temp table, query, or something else) that would identify and display that I have qty 100 w/ exp_date of 7/04 and qty 200 w/ exp_date of 7/14 from the above example for display real time.
Any ideas on how to accomplish this?
1
Add a comment...

Steve Tarantola

Development  - 
 
Can anyone just tell me if the below table (t5) is possible?? Can I have a condition in the WHERE clause of t5 from t4?

UGGGGGGGGG, I am not even sure if this is possible......

(SELECT orders.model, sum(orders .quantity) as 'sumM', sum(orders .ord_qty) as 'sumO'
from orders where orddate>date_format(IFNULL(t4.date_inventory,'0000-00-00'), '%y%m%d')
group by model)t5
1
Add a comment...

Steve Tarantola

Introductions  - 
 
Wease
lvl 8
Resistance
Pottstown to Paoli

Hope my enlightened playmates have had as much fun as I
4
Add a comment...

Steve Tarantola

Discussion  - 
 

Wease from the Resistance here. I am pretty much of a newbie, only lvl4, but I mainly look out for the malvern-Pottstown area
1
Jim McCusker's profile photoSteve Tarantola's profile photo
2 comments
 
Might be a bit, the resistance is strong by me, which makes finding enemy portals a little more costly (gas prices suck)
Add a comment...

Steve Tarantola

Google TV Discussion  - 
 
Note to those with "a rats nest" behind their entertainment centers"....
1) Yes HDMI cables either work or do not work
2) but the real difference is in the shielding,

 I just found this out the hard way after two days of trouble shooting. I experienced 'flashes' on my screen. I thought it was the new GTV but it turns out to be interference into the cable.
Good thing I had new ones from my favorite online retailer, their Basics brand...woohooo. They work perfectly!
3
John Blossom's profile photoBrad Bailey's profile photoSteve Tarantola's profile photoThomas Snoich's profile photo
4 comments
 
I agree.  I have had good look with Amazon Basic cables (and actually everything else).  Was ready to return a device earlier that wasn't working until I decided to replace the cable.  The cable is question was a pricier cable - the cheap Amazon cable worked perfectly.
Add a comment...

Steve Tarantola

Google TV Discussion  - 
 
HiSense question, before I go to the manufacturer.
I followed the directions and adjusted the picture size (I guess this is called overscan). It was too much. 
I have gone into the setting and tried to adjust and also tried to start from default settings. How can I redo the overscan??


One other thing, if you use two-step authentication.....get a new application password before you start setup ;)
1
1
Bob Jeselnik's profile photoSteve Tarantola's profile photoScott Ugolik's profile photo이찬진's profile photo
6 comments
 
Figures, just one more typo to add to their list. Leave it to the Chinese. 
Add a comment...

Steve Tarantola

Shared publicly  - 
 
ugggg....just found out I have the first draft pick in my fantasy football league. 12 team PPR.......ok so who is my 2nd pick???? damn that is a long  time until the second pick.
1
Ray Perez's profile photoSteve Tarantola's profile photo
4 comments
 
not taking vick with another rib injury
In his circles
2,560 people
Have him in circles
695 people
Richard Morrison's profile photo
Adam F. (StrkeForcePenny)'s profile photo
Gias Uddin's profile photo
William McGullam's profile photo
Jenniffer Mieth's profile photo
kendry kenken's profile photo
Pedro Owsik (padalabra)'s profile photo
DoomsDay Headlines's profile photo
charlestown hunt's profile photo

Steve Tarantola

Shared publicly  - 
 
WOW!!!!!
That's all I can say about #GoT  
1
Vince Delia's profile photoSteve Tarantola's profile photoBrandon Spinner's profile photo
7 comments
 
I've read all the books, and I'm jones-ing for more. The story gets even crazier. They had to split this book up into 2 seasons (3 and 4) because obviously they couldn't cover it in 10 episodes. So even though the season is ending next week, this book is only half over.....Also the season hasn't ended yet, either :-P

Steve Tarantola

Shared publicly  - 
 
Has anyone found an app that will allow to use the created dropdown boxes in excel?
1
 
Steve Tarantola originally shared:
 
The Battle of #ingress   Philadelphia rages on but a massive offensive took place today thanks to our brave #ingressresistance   fighters. 

Very much like the Revolutionary war days....we know how that turned out ;)
..fight on fellow #resistance  members
1
Add a comment...

Steve Tarantola

Google TV Discussion  - 
 
Hisense question......
Has anyone set a static IP address? The 'Set' button is grayed out for me
1
Scott Ugolik's profile photoChris Jeter's profile photoSteve Tarantola's profile photoThomas Snoich's profile photo
8 comments
 
No, in fact sometimes using the google DNS settings will slow you down.  I have found that the google DNS servers outperform the Verizon FIOS servers in most instances.  The exceptions have been when the google servers are under attack by some new bot that google hasn't seen before - then they might be slow for a few hours.  Bottom line on DNS is to go with what you have had success using in the past.  Definitely one of those cases where if its not broke, don't fix it...
Add a comment...

Steve Tarantola

Shared publicly  - 
 
Finished setting up (aka repaired) my slave machines with Mint Maya XFCE, gnome desktop sharing, and openssh......and it works!!!!
Not bad when you lose a powersupply, hard drive and a stick of ram to a storm.
1
People
In his circles
2,560 people
Have him in circles
695 people
Richard Morrison's profile photo
Adam F. (StrkeForcePenny)'s profile photo
Gias Uddin's profile photo
William McGullam's profile photo
Jenniffer Mieth's profile photo
kendry kenken's profile photo
Pedro Owsik (padalabra)'s profile photo
DoomsDay Headlines's profile photo
charlestown hunt's profile photo
Links
Other profiles
Contributor to
Basic Information
Gender
Male
Steve Tarantola's +1's are the things they like, agree with, or want to recommend.
My Cocktail Bar Drink Recipes
market.android.com

You have alcohol, some beverages and fruits and wonder what cocktails you can make? My Bar is for you. Just choose what ingredients you have

Cryptography
www.crypto-class.org

Cryptography is a free online class taught by Dan Boneh.

Python Introduction - Google's Python Class - Google Code
code.google.com

Python Introduction. Google Code University › Programming Languages. Python is a dynamic, interpreted language. Source code does not declare

Introducing Google Drive... yes, really
googleblog.blogspot.com

Just like the Loch Ness Monster, you may have heard the rumors about Google Drive. It turns out, one of the two actually does exist. Today,

Facebook and Twitter creating vain generation of self-obsessed people
www.dailymail.co.uk

Baroness Greenfield, professor of pharmacology at Oxford University, believes the growth of internet 'friendships' could effectively 'rewire

YouTube - Chargers kicker, Nick Novak, peeing on sideline?
www.youtube.com

Create AccountSign In. Home. BrowseMoviesUpload. Hey there, this is not a commercial interruption. You're using an outdated browser, whi

Using Backtrack 5 R1 as Desktop Operating System: BT for Beginners | Bea...
channikhabra.blogspot.com

Using Backtrack 5 R1 as Desktop Operating System: BT for Beginners. Backtrack is one of the most famous penetration testing Linux distros. I

Cinnamon 1.2: The New Linux Desktop Is Now Officially Stable | PCWorld B...
www.pcworld.com

With seven key additions and changes, the latest version of this brand-new desktop aims to deliver a new level of customization to users.

Why Top Talent Leaves: Top 10 Reasons Boiled Down to 1 - Forbes
www.forbes.com

Eric Jackson, a fellow Forbes blogger I follow and find both funny and astute, wrote a really spot-on post last month about why top talent l

AndFTP (your FTP client) - Apps on Android Market
market.android.com

Your FTP/SFTP client AndFTP is a FTP, FTPS, SCP, SFTP client. It can manage several FTP configurations. It comes with both device and FTP fi

StopTheHacker automatically removes malicious code from web pages
news.techworld.com

StopTheHacker has added a feature to the security startup's subscription service that automatically removes malicious code placed on web pag

Studying with YouTube and Google+ | Google Student Blog
googleforstudents.blogspot.com

Studying with YouTube and Google+. Introduction: Taylor is a Google Student Ambassador at Boise State University. He is currently pursuing a

Comcast -- Owner Of NBC Universal -- Admits That DNS Redirects Are Incom...
www.techdirt.com

Well, well, well. Here's something interesting. Comcast, who owns NBC Universal (one of the main forces behind SOPA/PIPA), is officially a

YouTube - What Life Could Be in a Nuclear Submarine
www.youtube.com

Create AccountSign In. Home. BrowseMoviesUpload. Hey there, this is not a commercial interruption. You're using an outdated browser, whi

Chrome extension enables remote computer control
news.cnet.com

Google's Chrome Remote Desktop extensions lets a person with one machine running Chrome control another such machine. It should help make Ch