Hey John,

This is amazing... you are the MAN

This looks great, I'm in the process of sprinkling some salt

John,

I think the name is bit misleading. Actually the purpose of this SP is to get the Current / Acquisition segment for Customers who has only 1 Product in their...

John,

If you notice the example of our business rule:

1)     French QandS, their Current Segment should be “QandS”. And their next level is Level1 since French has that product available. If...

John, I apologize about the confusion there.

Actually each product category (Language in this case) doesn't necessarily contains all the products.

E.g.: 

1)     Product category; French, Contain QandS, Level1, Level2, and Level3.     

2)     Product...

Thanks for the input SQLGuru. I'll try this approach and let you know if I need any help.

JB

Thanks Aaron, Jeff and John for your input.

Let me try this and I'll let you know if I have any issue.

JB

Hi Jo,

Thanks for replying. Actually I posted this message in another section [SQL Server 7, 2000 --> T-SQL] and I have added some additional details there as well. Please take...

Hi Jeff,

Well we have a product line of forign languages. Each language has potential levels (products). QandS is the lowest priced product where as Compact, Level 1, Leve2 and Level3 are...

Thank you Joan and Aaron for your reply. To give you an idea & to anwer John's question I'm writing down the code & DDL here:

CREATE TABLE [dbo].[Customer_Profiles] (

 [CustID] [int] NULL...