Search results

I need only one record for each quantity. Edited post : I had pasted the wrong date for quantity 10. That was why you were receiving 2 records for 10. @CJ_London found the problem in #1. Sorry for the confusion, but the forum doesn't allow to paste a table. Thanks again for your help.

I had thought of that, but since the query was simple, there can't be any difference. I have far more complicated queies running on very large tables and the peformance is really fast. I'll try a passthrough with given top 1 solution to see how the result would be. But it won't be until Monday...

Just as a follow up : I don't know how car insurance works there, but here, normally the car is insured. It means that no matter who the driver is, the insurance can be used. But, we also have the option to select to apply for personal insurance. In this case, the person is insured and can drive...

Since you explicitly asked about insurance in other countries, here is my car insurance as an example. I live in Japan. I pay US $380 per year for my car. (Each year without accidents, makes it cheaper) To be able to compare with your situation, last year my annual income was a little more than...

I just tested your version. The result is correct, But it seems yo be very slower than the joined sql in #2. The #2 sql is instantaneous, but running your sql, takes around 1 to 2 seconds. First there's a blink then the result shows. If I chnge the where clause to AND p.PricesProductFK IN...

I just rechecked. The sql of #2 seems to show the correct result. Thanks.

The result data shown in my first post, was a copy and paste from the data sheet view of sql from #2. It shows only 7 records and it seems the result is correct. But I may be wrong though. I did lot of testing and may have pasted the wrong sql. I'm away from my PC and will try to start a remote...

After several trials and errors, the following seems to work. But honestly, I'm not sure if it can be relied on. There seems to be too many joins: I appreciate if you can correct this one, or suggest something to be used instead. Thanks. SELECT q.PricesOrderedFromFK, q.PricesQuantity...

I'm sorry for the length of the question. I don't know how I can explain it shorter. This is a working sql: SELECT PricesOrderedFromFK, PricesQuantity, Max(PricesRegisteredOn) As RegisteredOn, PricesRegisteredBy FROM tblProductPrices WHERE PricesProductFK = 34086 Group BY...

What's wrong with sharing an un-finished product? Others can help you finish it sooner. Your first post starts with: But you’re not sharing anything that can actually be tested. Instead, you keep giving lengthy explanations of how the product will work, and so far—if I’m not mistaken—nobody...

China’s economy does not rely on personal taxes the way most Western countries do. China’s government revenue depends on: 1-Corporate taxes. Companies that are owned and controlled by the government (SOEs) pay profits and taxes. Large private companies contribute significant tax revenue too...

To prevent this thread going off track and being highjacked, I've put my thoughts in spoiler section to let you know how I think. Please don't reply. I will add a new thread for my case and will ask for your advice there. Thanks.

In your suggested model, what happens when an assembly can be used as a part in another assembly? (sub assembly) How do the relationships look like? For example, a manufacturer can assemble several parts and make a cabrator and sell it as an stand alone part, or can use the caburator as a sub...

I wasn't talking about passwords. I was talking about the secret questions that you have to set an actual answer to them.

Doc, here, for the sites that don't allow adding a question, it's very common to use a pattern in the answers. Almost all my friends, relatives, colleagues, neighbors have a vast info about me. What was my first dog's name, which school I attended....etc. There are apps that you can find a lot...

If it makes any sense, we can either choose one of the pre-defined questions, or add our specific questions and the answer to that questions. The questions we add is available only for us, not other users/members. When needed, we have to offer both the question and the answer. I normally use...

Go to Google Payments Center Sign in to your account (payments.google.com) Click on the Activity or Subscriptions & services tab. You will see a detailed list of all your Google-related transactions

I had a lot more to say, and wanted to explain in details, but as it turns out, the OP and some others are not enjoying our (my?) discussion, I think I'll stop here. Thanks for your thoughts.

I read all the replies carefully several times, and I’ve tried to step back and look at this from both sides, not just from my initial instinct. And I have to admit, many of your points are valid. The idea that non-violent offender, especially hackers with specialized skills, can contribute more...

Why? Because of our simplistic and childish debates which ignored reality and consequences? Don't worry. I have one more comment and it will be over soon.