| cuneyt 2002-12-20, 5:23 am |
|
Hi everybody,
I have an company table and it has 2 columns, Company Code and
User Code, I
am incrementing "User Code" with "column identity" property of MS
SQL Server
2K. I have different companies and those companies have different
users. When
I increment User Code one by one, of course it doesnt consider
whether it is
the same company or not.
Question 1: How can I satisfy this condition below?
EX:
company user
1---------1
1---------2
2---------3
2---------4
3---------5
4---------6
What I want is
company user
1---------1
1---------2
1---------3
2---------1
2---------2
3---------1
3---------2
3---------3
etc.
Question 2: I want to know that whether it is possible to do that
by writing
column formula or not?
--
Posted via http://dbforums.com
|