Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashokghr
Starting Member
5 Posts |
 Posted - 2001-07-12 : 14:06:11
|
| Thanks Mark for the prompt reply. Your answer is good. I think I need to put my question again with some more details. CityClass Table (CityClassCode(PK),Description would have data like this:"A","Class A Cities""A-1","Class A-1 Cities""B","Some Description""C", "Some Description""UNDEFINED","Some Description"and the able CityParams(CityClassCode,StartRange,EndRange,Amount) (Slight modificatio in the strucutre !!!, STartRange and End Range is what I was maring as Rule)would have data like this:Here Rules are (0,3000),(3001,12000)(12001,9999999)"A", 0, 3000, 50"A-1",3001,12000,150"B",12001, 9999999, 300Now for all there other CityCLass Code, We need to store a Value "FallBack Amount" for each rule. i.e.Rule1(0,3000):- 15, Rule2(3001,12000):-30Rule2(12001,9999999):-60The above defnied amounts would be applicable to CityClassCodes("C" and "UNDEFINED"). I hope this time the problem is clear enough. Thanks again. |
|
|
|
|
|
|
|
Design Issue:- Repost