Search results for query: *

Hi, I'm trying to perform a SELECT query on an Amazon hosted MySQL database. My query looks like this: select user_id, max(created_at) from marketing_events where description = 'signed in' group by user_id The table in question is about 20m records of which about half fit the 'signed in'...

In a similar vein to the question I posted yesterday, I need to look at achieving the same thing with a slightly different approach in that I actually want to update the Guest table with the first booking date from the Bookings table: Bookings - Booking ID - Created Date - Guest ID Guests...

Hey, I'm trying to query an Access Database with PowerPivot. Long story short I am trying to bring in the date of a Guest's first booking from the Bookings table with their ID, Country and the Date their account was created from the guest table. I've done this a million times from SQL Server...

Guys, I've got a very simple Query that is part of a pick-list creator for customer orders. One of the fields I need to bring through is Warehouse location. This complicated matters as at present if there is more than one location for a product it effectively creates a double up of the order...

Hi, I've got the following query which I'm trying to streamline to bring through summarized data. The problem is that in our database all the sales are recorded as a 'long' date with the time which means I am struggling to summarize by day. I've got the code to reformat the date which works well...

Hi, I've got the following query that I use in PowerPivot to bring through a chunk of the product table from our SQL Server Database. It worked brilliantly until I decided to throw a load of other stuff in there in terms of pulling in sales and goods receipt data from other tables - from a...

Hi, I'm looking to import some data from the company SQL Server database into a local SQL Server Express DB I have created on my PC. If I wanted to import the entire contents of the 'Inventory' table what would the code be? Source Data: server: ab-srv-01 db: maindb table: Inventory Thanks...

Hi, hoping someone can help me with a query I need to write to summarise the components of a retail transaction where the transaction details are in one table (saleheader) but the details are in the other (saleline). My aim is a query that, for each transaction (reference1) on the saleheader...

I've got a series of voucher codes that are alphanumeric and I need to establish whether a transaction is associated with the voucher code. There are 21,000 codes which are sequential e.g. AB00000000005258 to AB00000000026258 but I'm presuming that becuase they are alphanumeric I can't do the...

Guys, I've got the following code which returns the details of customer orders this year. The problem is that I need to return the $ sales number which is in the sales table with the complication being that the only way to link the two is through a 3rd table. customerordernumber(column) is in...

Guys, hoping someone can help with an issue I'm having. The following query used to work like a dream to return sales for a specific store between specified dates grouped by year and week. I have made a change to enable me to screen out transactions using a particular voucher code by joining...