Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Assign Validation Codes Expand / Collapse
Author
Message
Posted Monday, April 15, 2013 9:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 6, 2014 11:56 AM
Points: 10, Visits: 155
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)'...
Post #1442382
Posted Monday, April 15, 2013 10:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:28 PM
Points: 13,138, Visits: 11,977
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/



_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1442386
Posted Monday, April 15, 2013 10:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 6, 2014 11:56 AM
Points: 10, Visits: 155
1 day....
Post #1442387
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse