Hi there,

I'm not sure exactly what you are asking.  I think you might be looking for something like this:

insert into MyPivotTable (OrderType, AccountType, ...)

select ...

Hope this helps

Wayne

G'day,

Here is one way to do what you are asking.  This methd relies on a temp table, but may be sufficient for your needs.

DROP TABLE TestTbl

GO

create table TestTbl (

        MyID  ...

G'day,

There are a few ways to accomplish what you are asking.  A few more details might point towards a specific solution.  A common method is something like the following pseudocode:

SELECT...

G'day,

I usually just follow the BCP statement with an update statement, similar to the following:

UPDATE ctcTempAdditional SET ColName2 = LTRIM(RTRIM(ColName2))

There is a time and memory cost that depends on the number...

Paula,

Thanks for the additional background.  This helps frame the problem a little better.

Can you provide an idea of the volume you are dealing with on a monthly basis?  For example,...

Robert & Sarah,

You might consider a variation used frequently in the MMORPG world.  Instead of playing magic with the seeds, add a column called something intuitive like "SourceLocation" that contains...

I completely agree with you Noel.  The right answer really is to find or define identifiers that are unique to each business entity.  All of the other possibilities that were...

John,

It sounds like you are working in an enterprise shop (or equivalent) where there is only one instance of the schema in production.  Consider the case where a product development...

Following is a brief snippet from the soundex topic in BOL.  in your situation, you could attempt to match the values by including something like SOUNDEX(columnA) = SOUNDEX(columnB) in the...

This is an interesting one...  I do not think you are going to find an "ideal" solution.  The best answer is for you to find something like a DUNS number...

G'day,

Assuming that your tables look something like the following, the select

may do what you are asking.  This is pseudo-code and needs to be adapted

to your specific situation.  However, there...

And another variation...

CREATE TABLE TestTbl (

AuthID        INT,

ClaimID       VARCHAR(20),

MemID         VARCHAR(20),

DischargeDate DateTime

)

GO

INSERT INTO TestTbl (AuthID, ClaimID, MemID, DischargeDate)

SELECT 100542, '05083000006', 'MB00112864', '2005-01-10 00:00:00' UNION

SELECT 100542, '05083000006', 'MB00112864', '2005-01-10 00:00:00' UNION

SELECT 100542, '05083000006',...

Hello Igor,

Thank you for offerring something free to the community.  The UDFs sound like useful utilities.  Can the source be posted to the scripts area of this site?

Wayne

hmmm....  An interesting question.  In my opinion, the support for XML templates in SQL Server 2000 is terrible.  I typically write my own custom export routine.  Having said that, BOL...

Another variation on the same algorithm uses "coalesce" as follows:

create table #x

( id int not null, MyName varchar(20), job varchar(20) not null )

insert #x select 12345, 'Jane Smith', 'Accounts Clerk'

insert...