Home All Groups Group Topic Archive Search About

done in a single statement

Author
14 Sep 2006 9:37 PM
Thom Anderson
A table looks like this:
create table #customer ( customerID int not null primary key, taxID char(9)
not null, salesRep int null)
insert #customer values (1, '111111111', 5)
insert #customer values (1, '111111111', 5)
insert #customer values (1, '111111111', 5)
insert #customer values (1, '111111111', 5)
insert #customer values (1, '111111111', 5)
insert #customer values (1, '111111111', 5)
insert #customer values (1, '111111111', 5)
insert #customer values (1, '111111111', 5)
customerID, customerTaxNo, salesRep
1,

AddThis Social Bookmark Button