Hello Lutz,

I am not sure if my approach is correct.

I can determine the customers not having orderd on past meals of one day only, sth. like

SELECT CUST_ID FROM #_CUSTOMER

WHERE CUST_ID...

Hello Gail,

sorry, :ermm: was not really sure what to do here... Will certainly keep the same thread the next time...

Marin

Chris,

thanks a million for your quick responses and excellent solutions, both work like a charm!

Many greetings,

Marin

...customer 456 had assignment to "BLUE" of course... Sorry for the mistake.

Marin

Hello Gail/Chris,

thanks for the quick responses!

This is what I expect actually:

insert into #Result (AssignmentDate, CustomerID, CategoryName)

select '2008-11-23 10:12:13.125',123,'RED' union all

select '2008-11-23 10:12:13.125',123,'BLUE' union all

select '2008-11-15 22:06:15.333',456,'BLUE';

select * from #Result

Meaning that...

Hello Lynn/Seth,

apologies for not posting in the suggested format - will certainly do the next time.

Lynn, many thanks for your quick response and for showing me the right way to...

Hello Jerry/Chris,

many thanks for your responses! Chris' solution is exactly what I was looking for: nice, lean & sleek, even with more randomization provided.

I have also succeeded in the meantime,...

Hello GSquared,

thanks a ton for the solution! It works perfectly - exactly what I need...

Cheers,

Marin

Hello all,

thanks for your prompt answers! As John remarks, I can't use MID LEFT and INSTR functions because they are not T-SQL...

As for Michael's question: I really need only...

Well, I have a table that contains keys and values: COL_KEY and COL_NAME. The first contains a nutrient code (always the same, no matter the language). The later contains nutrient...

Hello Antares, Ninja and Allyn,

thank you very much for your assistance. I will surely give it a try with your suggestions.

Many greetings,

Marin

Hello Allyn and Ninja,

thanks for your replies. An allergy is valid only until the next assignment:

1. Allergy to peanuts assigned on 4/18 (valid from 4/18)

2. Additional allergy to dairy products...