Hi Smith,

Apologies for the same :-

insert into sales (ID,Sales_Jan,Sales_Feb,Sales_Mar,Sales_Apr,Sales_May)

values

(1,100, 0,0,0 ,0 )

insert into sales (ID,Sales_Jan,Sales_Feb,Sales_Mar,Sales_Apr,Sales_May)

values

(2,120,0,200,300,0)

insert into sales (ID,Sales_Jan,Sales_Feb,Sales_Mar,Sales_Apr,Sales_May)

values

(3,0,100,0,300,0)

insert into sales (ID,Sales_Jan,Sales_Feb,Sales_Mar,Sales_Apr,Sales_May)

values

(4,100,200,100,100,100)

insert into sales (ID,Sales_Jan,Sales_Feb,Sales_Mar,Sales_Apr,Sales_May)

values(5,100,0,100,100,100)

--- Sales ID to populated is...

Hi Jeff/Gila Monster,

It was just an example 😛 to help someone who posted a query in some other thread for "How to delete tables within a DB following some pattern...

What I mean is the data is normalized in the table but I have created a derived column by concatenating the columns 🙂 .

I just wanted a way to match...

Sean u had me ...The data is very well normalized but I wanted to know a logic to match such data other than normalizing it (out of curiosity :hehe: and...

Thanks Cadavre,

Wish you many more centuries for providing the solution.

Thanks,

Ankit

Cause the client requirement is like that 🙂 .

Thanks Gina

Hi Gila,

Thanks for your reply. The data is normalized but I have concatenated fields separated by "/". I want to now populate ID to these fields with fields eg: ...

Thanks cold coffee,

But I was looking for solution that Adi provided. I hope you too would appreciate his code.

Regards,

Ankit

Thanks Adi this is perfect and clears my concept on Joins as well.

Regards,

Ankit

If I execute

DECLARE @QUERY NVARCHAR(MAX)SET @QUERY = N'SELECT 1'EXECUTE sp_executesql...

Sean Its not working for me ?

Lynn,

1.the DPPEngine Proc is creating queries and storing into Queries table.

2.Superb cursor is executing these...

Sean, Thanks for your help.

The ";" after Rule_DB is making @Sourceid...

Am I missing some information or is it Friday that is keeping people busy ?