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

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

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

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

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

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

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

so many tricks, so little time!

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

Great, thanks. I`ll figure it out as soon as possible.

kim

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

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

j_e_o (6/14/2012)

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

pardon my not-up-to-datedness, what's TDD?

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