Build a table with constants in it.
Move it to a read-only filegroup, so that it avoids locks/blocks/et al, in terms of contention.
Select from it when you need to use a value.
If you ever need to change it, change the file to read-write, update it, then change it back to read-only.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon