Re: Distinct insert

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 08/25/04

  • Next message: Connie Ulehla: "Sql Server Reporting Services Download" 
    Date: Wed, 25 Aug 2004 23:34:01 +0200

    On Wed, 25 Aug 2004 12:55:03 -0700, Robert wrote:

    >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,

    Hi Robert,

    Please provide DDL (CREATE TABLE statements, with constraints), sample
    data (as INSERT statements), expected output and a description of the
    business problem you're trying to solve.

    http://www.aspfaq.com/etiquette.asp?id=5006
    http://vyaskn.tripod.com/code.htm#inserts

    Best, Hugo 

    -- 
(Remove _NO_ and _SPAM_ to get my e-mail address)
  • Next message: Connie Ulehla: "Sql Server Reporting Services Download"

    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
      ... to insert a Distinct Account number. ... In the AutoExpt table there are multiple occurrences of "LIC TAG" values all ... of which need to be put into 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
      ... 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)