1 day....

sean i really do get what you mean...let me try to get you more info...

basically the customer information in the customersA table on any given day can have multiple same...

sorry for the late reply...

Case 1:the first column can be considered as first one and also there is a time assigned when the that particular row was created like 04/01/2013...

i have updated the sample scripts along with the insert statements in my original post...i was just reading guidelines for posting a question,hope that helps..

Let me try to explain what's going on then..

There is a Table Customers(Table A) which will get Customers Data as any new prospective Customers join the Product list. A single...

The two Tables are on the same server.Table B is used as Dynamic storage to change values depending on the requirement..i can create a variable in the stored procedure and...

once i get started will post the query in further details .sorry for jumping the gun