I don't think it was Synergy. it did work very smoothly as changing control was as simple as moving the mouse to the correct screen.
For example I need the stuff that I can make aerogel from and it lists a bunch of places the plant can be found but I don’t know which direction to head in to get to any of those places.
- I'm not sure how many of you have ever felt like this. But as an aspiring Filmmaker, I love Music in Films. I always hear a song I like and imagine how it could be used in a Film. No matter the genre, I always picture it being played and try to work out the scene in my head. Sometimes I hear a song I REALLY like and wonder if it has been used in a Film before. And to figure out if it has, I just have to do a random Google search and hope I get lucky. But imagine an App where you can type the name of a song, and when you press "Enter." It searches for what Films and TV Shows have used that specific song, if any, and then gives you the Film Title or TV Show name along with the Episode Title. Followed by the exact time stamp in that Film/TV Show where the song was played.
- Just an idea I always wish was a reality. It's kind of like Shazam and WhoSampled. But instead of telling you what song is being sampled, it tells you which Film/TV Show the song was featured in. Just a thought...
My wife is still on the records. The new bishop contacted me earlier this year when he was still the EQP and wanted to come to my home and meet me and my wife even though I resigned a year and a half ago. I told him I was no longer a member of the church and wished not to be contacted and asked him to tell the bishop and ward council just to leave my family alone. He said he was sorry and didn’t realize the situation and that he would pass along the information.
Now this guy is bishop. From what I’ve heard of him and seen from him he is a great guy. But I just don’t want anything onto change. I don’t want to become a target again and I don’t want anyone coming by for my wife to fellowship her. She doesn’t either and we have made it clear to the ward that church people aren’t to come by the house. Does anyone have experience with this kind of change and what information the new bishop will have about me?
For one of my homework exercises I'm supposed to write the query that's given in the title, but I have no clue how to check that the products were purchased on the same date.
The only way that I know of would be to have a from clause as for example:
"FROM shoppinglist as sh1, shoppinglist as sh2, shoppinglist as sh3 etc
WHERE sh1.date = sh2.date, sh2.date = sh3.date etc"
But that would be a lot of work for 10 different dates, so I'm assuming that there is supposed to be a faster way to do it.
I was able to make a query that finds all the cID's of people that purchased 10 different products, but I can't seem to augment it in such a way that all the purchases were made on the same day. This is the query that I came up with:
'SELECT sh1.cID
FROM shoppinglist as sh1
GROUP BY sh1.cID
HAVING count(distinct sh1.pID) > 10;'
returns the cID's of customers that have made 10 purchases, so how would I augment it in order to make sure that those 10 purchases are made on the same day?
I'm using the following schema:
customer(cID, cName, street, city)
Customers with unique cID and other attributes
store(sID, sName, street, city)
Stores with a unique ID and other attributes. Stores with the same name but different sID (and address) form what we call a store chain.
product(pID, pName, suffix)
Products with a unique ID
shoppinglist(cID, pID, quantity, date)
What a customer wants to buy on a certain date. (Every customer creates at most one shoppinglist per day.)
purchase(tID, cID, sID, pID, date, quantity, price)
A transaction: what a customer bought in one go; every transaction (tID) corresponds to one customer (cID) buying from one store (sID) on one date (date); at some point during the course we see that this actually means tID → cID,sID,date
inventory(sID, pID, date, quantity, unitPrice)
Inventory of a store as published at the start of a date.
The information supplied to use about SQL is really really bad so I can't seem to figure it out myself. So any help would greatly greatly be appreciated.
Thanks in advance!
Basically, back in one of my liberal arts college class on Myths and Legends we learnt about this theory wherein people seem to claim a certain land based on a myth of an ancient origination from that particular land (eg: Israel Palestine issue/ Ram Janmabhumi in Indian history). What is this theory called? There are many more examples of this throughout history I'm sure.
So I have a list of Names and data in the rows of each name in Column A on Sheet1. On Sheet2 I would like to populate the names and data from Sheet1 of a select list of names. Lets say that list is on Sheet3 A1:A7. I hope I am making sense.
