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 |
|
Lionheart
Starting Member
41 Posts |
 Posted - 2010-03-12 : 09:34:14
|
| I have points for 2 separate curves that I need to map onto each other based on five points along each curve. Does anybody have any suggestion/code to demonstrate what would be the best way to do this using SQL?Each curve is in a separate table.ThxLH |
|
|
ray-SQL
Starting Member
18 Posts |
Posted - 2010-03-15 : 16:11:09
|
| Can you explain this in more detail? What do you mean by "map"? Sample data would be good.Please see the pinned FAQ on top of this forum on how to post more information. Esp:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74221[/url]Ray Dai |
 |
|
|
Lionheart
Starting Member
41 Posts |
Posted - 2010-03-16 : 07:54:31
|
| Apologies. I have the following key points along two curves. X ID1 ID2 1000 1,786,929 1,249,121 200 852,628 636,772 100 569,317 440,798 10 39,155 33,566 5 9,295 3,902 I need to use sql to try and find a formula that will map the points from ID1 onto ID2. This formula will then be used applied to all the points for the curve ID1 to create a curve for points where X=0 to 1000 to create a mapping of one curve to another.Appreciate the help.LH |
|
|
|
ray-SQL
Starting Member
18 Posts |
Posted - 2010-03-16 : 10:00:53
|
| Thanks for the added info. I am not sure how sql can help you "find" a formula to relate one set of data to the other. It seems that it is your data and you should know how they are correlated, if you don't, then someone else should. Otherwise there could be a millon possibilities how these two sets are related. If you know how they are related, the SQL has math functions that can assist you to map the points, but you will have to come up with the formula yourself first: [url]http://msdn.microsoft.com/en-us/library/ms177516.aspx[/url]Ray Dai |
|
|
|
|
|
|
|
|
Using SQL to map one curve onto another