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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2012-10-31 : 06:56:23
|
| Hello there.is there a way i can define the grid number to text of my choice.RegardsRob |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-31 : 07:03:43
|
| You can create a reference table with two columns, one column being the grid number and the second one the text that you choose to associate with it. You would then join to that table using the grid number to get the text associated with that grid number. |
 |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2012-10-31 : 07:32:22
|
| is there a system function for the gridnumber to reference to? |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-10-31 : 07:42:55
|
| Where are you doing this? In a T-SQL script, or from the client code? Can you post the code you have currently, even if it does not work correctly? |
|
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-10-31 : 08:13:45
|
| If you create the table with an IDENTITY column this would number as you input the text |
|
|
|
|
|
|
Defining automatic grig number to desired text