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 |
|
12many
Starting Member
9 Posts |
 Posted - 2013-04-12 : 03:23:32
|
| Hi there I have two tables, table one is a list items that have a unique id.table two is a list of things done with those items.if what ever has been done is normal the referenced id in table two is positive.Other wise it gets put in as a negative.my question is, is it possible to to reference table 1's items with a negative representation of its Id Many thanks for any helpIan |
|
|
12many
Starting Member
9 Posts |
Posted - 2013-04-12 : 03:28:02
|
| HI There ABS(referencedid) Worked a treat Ian |
 |
|
|
|
|
|
negative Ids