Search results for query: *

Jpadie, appreciate the response. Think the text field is the only one that serves my purpose but will look for an alternative but reassuring to hear that there is obviously something not right - my previous experience of in-house servers is closer to the 1 second you mention. Thanks again. Jacob

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'...

Thanks Andy!

Andy, not sure why the pic doesn't work although its pretty irrelevant at this point. The end Bookings table I'm looking for has the following columns: Booking_ID Guest_ID Created_Date Repeat Customer_Booking_Number Where the first three are from the data export and the last two are calculated...

Skip, you've got me - basically I am trying to do this using mainly techniques I know and understand and I am going round the houses somewhat. Fundamentally my goal is to be able to get a flag onto the Bookings table called 'Repeat' which is either true or false. Ideally there would also be a...

Thanks Andy, appreciate you looking at it. Inserting my stuff where applicable I currently get a 'Syntax Error' as can be seen in the attached screenie. I've taken out the where clauses because initially I won't need them. I basically understand what you are doing although I was surprised not...

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...

PHV - sorted. You were a massive help!

PHV - looks like that is the problem. One is text and the other is a number (one came from an Excel export, the other from CSV as it was so large). Jacob

Guys, sorry but this was just a typo when I was tidying up the code to put in the post. My Select and Group By do match!

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...

Rudi, thanks for the super quick response. Although I have an 'insert' date in the warehouse location table it would appear to be exactly the same for many of the productcodes that have multiple locations meaning that I probably can't use it as a 'tie breaker'.

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...

George, you've lost me slightly now! The tables definitely have indexes (at least according to the schema). With the assistance of Google I tried to look at the execution plan and apparently I don't have permission (I'm using windows authentication). The question is, if I can get a look at the...

Thanks Rudy, really appreciate it! Jacob

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...

George, I can't say thankyou enough! This is amazing, it turns an 11 minute query into one that takes 48 seconds. Regards Jacob

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...

Thanks, thats great! Jacob

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...