Viewing 15 posts - 1 through 15 (of 26 total)
Hi Ron
contsupp.country is the course short name field. the registration component of the system underwent an evolution - as do most processes I suppose, but I really wish that they...
October 23, 2012 at 6:51 am
I have a rather absurd sense of humour, to some that is, to others, not so much.
so, you were late out the door last night as well, that's IT for...
October 23, 2012 at 6:39 am
thanks Ron, much appreciated; I'm always interested to learn more stuff.
I'll have to attend to that in the morning, I don't know where you're situated, but I'm EST and...
October 22, 2012 at 4:09 pm
You are so quick to respond! no waiting, how gratifying.
I'll have to study this, make sure I understand it and absorb it all, as well as add it to my...
October 22, 2012 at 4:05 pm
Hi Ron
yes, quite correct, it's GM.
and your query does work, but it gives me multiple records for each contact and includes courses that are prior to 01 jan 2010. I...
October 22, 2012 at 3:34 pm
Hi Sean
I do apologize, I did think that I had copied the whole thing, not just the inserts, I certainly intended to post it all. and also thought that I...
October 22, 2012 at 3:26 pm
ok, here's my create table for the table listing the courses taken by a contact:
insert #contact_courses
select 1234, 'course name', 'TRG2155', 'Introduction to HACCP Planning' union all
select 1234, 'course name', 'TRG2156',...
October 22, 2012 at 1:49 pm
so many tricks, so little time!
October 22, 2012 at 12:29 pm
You are FAST!
ok, give me a few minutes and I'll see if I can create the contsupp table from your examples.
I'll be right back - I'll try it out on...
October 22, 2012 at 12:26 pm
Great, thanks. I`ll figure it out as soon as possible.
kim
October 22, 2012 at 12:10 pm
Hi Sean
Thanks for your very prompt reply - you all are amazing. I recognize that you are volunteers and for those of us who rely on your generosity of time,...
October 22, 2012 at 12:05 pm
thank you Want a cool sig for your very prompt reply.
ah, yes, quite right, I did mention only the two tables at the beginning, apologies.
maincourses has a one-to-one relationship with...
October 22, 2012 at 11:09 am
j_e_o (6/14/2012)
pardon my not-up-to-datedness, what's TDD?
TDD and CI are Agile concepts/terms/practices:
TDD = Test Driven Development
CI = Continuous Integration
They aren't silver bullets, but when done well, can really improve...
June 14, 2012 at 10:09 am
omg do I interpret this correctly? you have programmed for X years and live in Manhattan close enough to CP to ride your bike there and around it? two of...
June 14, 2012 at 7:26 am
Viewing 15 posts - 1 through 15 (of 26 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy