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 |
|
durexlw
Starting Member
2 Posts |
 Posted - 2010-07-03 : 05:01:11
|
| Imagine functions (as in coding): there is a function call, to each function there are parameters and whereas the names and the amount of parameters is specific to a function, the value of that parameters is specific to the function call.For example:Add (Number1,Number2)ADD = functionNumber1 & Number2 = parameters specific to the functionAdd (5,3) = function callwhere the numbers 5 and 3 are parameters specific to the function call-What I would like is a datamodel that can do this: if I add a new function, it should present me with the parameters specific for that function, but the values for those parameters should be different for each 'function call'. I'm really struggeling with this one and I'm in need of some help.... is this even possible? |
|
|
pduffin
Yak Posting Veteran
68 Posts |
Posted - 2010-07-07 : 21:18:57
|
| No idea what you mean, and as 53 people have ready this and not replied, I guess they don't understand either! |
 |
|
|
pduffin
Yak Posting Veteran
68 Posts |
Posted - 2010-07-07 : 21:20:36
|
| The function stuff makes perfect sense, but with regard to the data model, I have no idea what your asking. |
|
|
|
srivastava.savita
Starting Member
1 Post |
Posted - 2010-07-08 : 02:18:38
|
| create a table variable say @table and insert all your parameters in that table variable and use something like thisSelect parameter1,parameter2,function(parameter1,parameter2) as summation from @table |
|
|
|
|
|
|
|
|
Want a brainteaser? Here's one...