Viewing 15 posts - 16 through 30 (of 127 total)
Ahhh, the times were impacting it! Thank you for the help.
November 4, 2016 at 2:36 am
Hi again,
Thank you for your detailed reply Luis Cazares I have only just seen your reply, I am going to read the article. I must confess I was a bit...
November 3, 2016 at 9:33 am
Hi Luis Cazares,
Could I just pick your brains please. Option 2 seems to be working great but I would like to change the table reference form wce_bookings to wce_quotes. I...
October 25, 2016 at 1:26 am
Hi Luis Cazares,
Could I just pick your brains please. Option 2 seems to be working great but I would like to change the table reference form wce_bookings to wce_quotes. I...
October 25, 2016 at 1:25 am
Hi Luis Cazares,
Could I just pick your brains please. Option 2 seems to be working great but I would like to change the table reference form wce_bookings to wce_quotes. I...
October 25, 2016 at 1:24 am
Firstly, thank you both for all that input. Lots to think about and play with.
Luis Cazares - those two options are great, I think i can use those to achieve...
October 24, 2016 at 11:10 am
Thanks pietlinden for your reply too. I don't have a calendar table. Is this something that is a standard SQL table structure I copy then use with your query? Thanks...
October 24, 2016 at 10:10 am
Hi Thanks for your reply. All those dates are bookings. So each row equates to a booking with an arrival and departure date. Is that what you meant?
Thanks again.
October 24, 2016 at 10:07 am
Thanks Hugo really appreciate your help. That has resolved my issue and I get the logic now. Also picked up lots of important things there for future reference. Thanks again.
February 3, 2016 at 12:19 pm
Thank you Hugo, very detailed reply, I need to go through this in more detail and test your suggestions. Sorry for too much sample data but I thought you should...
February 3, 2016 at 8:14 am
Thanks for the replies. Here is the script for the tables /data. I also revised the queries as i made alterations to the tables. Thanks for your help.
This query shows...
February 3, 2016 at 6:10 am
HI,
Here is the answer to my question, this query gets the results.
Select * from history h where not exists(select 1 from linkto where lutablename = 'history' and letablename =...
December 6, 2011 at 5:14 am
Thanks for the reply John,
I am tryin gthe insert part of what you suggested but no matter where i put it i get, loads of erros. Here is the code...
November 11, 2011 at 5:07 am
Hi Cadavre,
Is there any chance you could help me out with getting your example to insert into a psychical table called table2 with an id column and a column called...
November 11, 2011 at 4:39 am
Hi again, I should start by saying my SQL skills are poor at best.... Is it easy to have this script create the actual table instead of creating a virtual...
November 10, 2011 at 3:09 pm
Viewing 15 posts - 16 through 30 (of 127 total)