parikiti (4/15/2013)
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 customer info..
example : Vam is the customer in the sample table i sent..he has multiple rows created by different agents(CreatedBy) because for some reason he has been approached by the same agent for different products but according to the new rule no matter how many products are sold or introduced to a customer he should be only considered once and also a particular customer row is considered active...for only the time frame described in the Parameters Table...
so THE FIRST vam row in this case is active for one day and if any new rows for the same customer have been created in that particular day they are considered inactive and assigned a valid status as '9(NO)'...
But what is the time frame described in the Parameters table? It has a value of 1. 1 what? 1 hour? day? month? year?
You are basically going to end up looking for gaps and islands of data. See if this article helps point you in the right direction. http://www.sqlservercentral.com/articles/T-SQL/71550/[/url]
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/