Viewing 15 posts - 16 through 30 (of 6,483 total)
So if I understand the request - you're looking to find the unused lots from a FIFO inventory system. or rather the remaining inventory by lot and inventory code.
January 6, 2020 at 3:43 pm
To add on to drew's comments you probably want to be clear about which state you want. it looks like for now you're lumping it in by state of residence,...
January 2, 2020 at 9:23 pm
Merry Christmas All, hope you enjoy the holidays (those of you that get them off 😉 ).
Won't lie, I really don't want to go see the latest Star Wars...
December 19, 2019 at 3:59 pm
Interesting topic! While I could see how one might argue against comparing yourself to others, I would caution against going too far onto the "snowflake path". Unique is great from...
December 11, 2019 at 4:52 pm
I love the technical historian brand of games. I call them a "brand" of games because they can take on a number of different flavors. For example:
October 30, 2019 at 4:54 pm
by without ODBC I am assuming you're meaning no direct linked tables within the Access front-end (you will be using ODBC or OLEDB in the end either way, since they're...
October 10, 2019 at 5:31 pm
You're probably not going to like the answer, but the only thing that comes to mind is a new table and load it using SCD2 on a month by month...
October 3, 2019 at 3:07 pm
What you're being asked for is an SCD2 model. note this is usually NOT kept within your OLTP solution.
You would need to keep 2 dates in addition to whatever business...
October 3, 2019 at 2:41 pm
I'm not sure this is a "high tech" vs "low tech" argument. Other than one being more of a cultural mainstay than the other, most of the arguments so far...
October 1, 2019 at 4:52 pm
The "safe" way is not to store the balance itself. store the transactions increasing or decreasing the balance, and calculate the balance when you need to see it.
September 10, 2019 at 8:11 pm
I used this link and found the article with no issues: https://sqlinthewild.co.za/index.php/2011/02/15/are-int-joins-faster-than-string-joins-2/%5B/quote%5D
Thanks - although that's not actually this particular article. Two new behaviors I didn't expect:
September 10, 2019 at 12:11 am
Is it just me or can you no longer get to the original article? All links to it point to the DISCUSSION, not to the ARTICLE. Sadly the article was...
September 9, 2019 at 8:33 pm
When job hunting, I'm point blank with potential employers or recruiters about what my current salary is. The way I see it, if either party can't match the expectations...
August 29, 2019 at 3:53 pm
Very popular topic. Start here:
I'd go through the entire series. Gail's VERY good.
August 28, 2019 at 8:01 pm
I think thre's a rather sizeable difference between associates informally sharing salary info, and a company that openly publishes/discloses all salaries. In the first case - since the company isn't...
August 28, 2019 at 2:18 pm