Viewing 15 posts - 1 through 15 (of 23 total)
Hi Guys,
Thanks for the replys. The requirements have changed so I've left this behind now. I never did get to the bottom of it though.
Thanks to those that contributed.
Mark
June 18, 2009 at 2:41 am
Hi Gail,
Thanks for replying. I'll get some sample data together, my explanation probably isn't great!
Thanks
M
June 12, 2009 at 9:09 am
Aah, gotcha,
I've place the join inside my existing query and it works beautifully.
Thanks for the extra advice. I'll have to have a think about all the issues you've raised.
Many Thanks...
December 12, 2008 at 9:49 am
Hi Guys,
Following on from Seth's post...
I understand the design of the tblCurrency and the reasons for it. I also understand that I will insert CurrencyID in the "other" table.
When...
December 12, 2008 at 8:55 am
I'll start again. I have a table where a number of fields are inserted by a user. One of these fields is "currencyname" which stores the currency name eg. pounds,...
December 12, 2008 at 3:48 am
I'm sure it's me that's missing something not you!
From what I can gather, you're saying I can use the value I have that was entered via the DDL, check what...
December 12, 2008 at 3:34 am
Hi Chris,
I already have the currency name and currency symbol list in a table with the Currency Name populating the drop down list the user will select from.
This DDL is...
December 12, 2008 at 3:18 am
Hi John,
That works a treat. Thanks for your help. It's much appreciated. Thanks also for the info in formatting code listings. I've never really looked into doing things this way....
December 11, 2008 at 2:56 am
Ok Here goes.
I'm just working with test data too so I've only created a very small set
SELECT '1','6','Jan 1 2009 12:00AM','Jan 8 2009 12:00AM', UNION ALL
SELECT '2','6','Jan 15...
December 10, 2008 at 10:33 am
also just discovered that if I change from WHERE NOT EXISTS to WHERE EXISTS then all rows are returned. This suggests the subquery is not working correctly no?
Regards
December 10, 2008 at 9:54 am
Hi,
I assigned a date format dd/mm/yy to @StartDate and @EndDate.
I have different data in my table than the data supplied above but the first query works fine with these values...
December 10, 2008 at 9:22 am
Hi Chris,
Thanks for your interest . Very bizarrely, where you have put operator missing some of the query has disappeared. I've tried to edit the post and repost the whole...
December 10, 2008 at 7:41 am
Hi,
Ive used the tutorial i found (see above link) to produce a query that will give me the Id of any unit the DOES have a reservation between 2 supplied...
December 10, 2008 at 6:40 am
Hi Seth,
Just one more thing i've just come across:
It looks like if the number of rows retrieved in RateCount is 0 it returns NULL. Is it possible to have the...
October 28, 2008 at 11:25 am
Well I've got to hand it to you....
I'm very grateful for your effort with this. It would have taken me forever to figure this out.
I hope you're always this helpful!
Once...
October 28, 2008 at 11:07 am
Viewing 15 posts - 1 through 15 (of 23 total)