Viewing 3 posts - 1 through 3 (of 3 total)
Join is the Answer and right Approach to this problem.
AMIT KULSHRESTHA
SOFTWARE ENGINEER
NEW DELHI,INDIA
AMIT KULSHRESTHASOFTWARE ENGINEERNEW DELHI,INDIA
June 19, 2003 at 1:02 am
#462047
very simple one .. use self join and take from one starting balance and from another ending balance
Cheers
June 4, 2003 at 8:38 pm
#459845
yes identity column can be reset as follows
DBCC CHECKIDENT (<TableName>, RESEED, <reseed value>)
June 4, 2003 at 8:35 pm
#459844