Distinct insert

From: Robert (Robert_at_discussions.microsoft.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 12:55:03 -0700

I am trying to insert a record id primary at the same time that I am trying
to insert a Distinct Account number.

The insert statement is something kind of like this:

insert into Accounts (AccountsOID,Account)
        select Distinct "Rec NO" + 100 as AccountsOID, "LIC TAG" as Account from
AutoExpt

In the AutoExpt table there are multiple occurrences of "LIC TAG" values all
of which need to be put into the Accounts table, however there must be only
one entry for the Lic tag in the accounts table. The Rec No +100 is just to
create a unique primary key for the AccountsOID.

Is there anyway I can get only the Distinct Lic Tag's, but at the same time
get a unique primary key for them.

Thanks,

Relevant Pages

  • RE: Distinct insert
    ... >>to insert a Distinct Account number. ... >>of which need to be put into the Accounts table, ... >>one entry for the Lic tag in the accounts table. ... >>create a unique primary key for the AccountsOID. ...
    (microsoft.public.sqlserver.mseq)
  • Distinct insert
    ... TAG" as Account from AutoExpt group by "LIC TAG" ... >insert into Accounts ... >create a unique primary key for the AccountsOID. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Distinct insert
    ... >to insert a Distinct Account number. ... >of which need to be put into the Accounts table, ... >one entry for the Lic tag in the accounts table. ... >create a unique primary key for the AccountsOID. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Distinct insert
    ... excel file into a new table in the SQL database. ... accounts table is not automatically generated, ... My theory is that if I add only the distinct account numbers and departments ... support on importing the data. ...
    (microsoft.public.sqlserver.mseq)