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 |
|
cnaypi
Starting Member
22 Posts |
 Posted - 2008-05-28 : 17:44:49
|
| I would like to know how to use a fact table so that when I insert or update a row with a word that the table will reference the fact table to make sure that the word I'm using is correct.for example I have a table with column Fulltext and Abbreviationin the fulltext column I have a a word "Windows Server 2008" now in the abbreviation I would like to abbreviate this to "Win Srv 08" Now the Fact table would have to columns Fulltext and Abbreviation under Full text the full words would be in it like Windows, Server, and 2008 and under the Abbreviation column Win, srv, and 08So I want it so that everytime the word Windows comes up and I need to type an Abbreviation for it that it will reference the fact table which is using the Abbreviation Win. To avoid different ways of abbreviating the word windows.Is there a way to do this automatically so that I don't have to manually go back and forth between the fact table and the table that I'm updating? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 00:49:52
|
| You can just join what you called fact table to get Abbreviation. |
 |
|
|
metaraja
Starting Member
3 Posts |
Posted - 2008-06-03 : 02:44:57
|
| You can directly make a link to the Abbreviation column and get the full value for the field while enterring the Abbreviation. (Or)U can use a trigger on each update or insert to update the value by refereing Abbreviation tablefor both the cases Abbreviation table must be defined.Raja |
|
|
|
|
|
|
help with a fact table