Thanks! this helps a lot.

Yes, working on it. I got side tracked and got pulled away on a critical project. I will follow up in a week. Thanks for your help.

I just tried something, would this do what i am looking for?

Select top 1000 RCPTDT, PACK_ITEM, max(UPC), min(UPC), Max(LEGACY_WH), SUM(CASESSHPD), MAX(PACK_SIZE), MIN(PACK_SIZE), MAX(UNIT_COST), MAX(ITMDESC), MIN(ITMDESC)

From pmk_cands_shipments_2008

GROUP BY PACK_ITEM,...

I don't know how many fields it will be but I expect it to be less than 30.

The Dynamic part is for the creation of the fields. It starts out with the 1 column with the string of names (comma delimited).

I fixed the issue. See the code fixed below:

Insert Into dbo.CMS_NewVnd_Master(

[Site_NBR], [AuditCode], [AuditDesc], [PRGIndustryDesc],

[PRGSubIndustryDesc], [CorpClientDesc], [AuditStatus], [Client_Nbr],

[AuditYearDesc], [VendorCode], [VendorDesc], New_Vnd, New_Name,

GroupVendor, GroupType)

Select CL2006.[Site_NBR], CL2006.[AuditCode],...

It's very simple... SQL servercentral is free and has many good resources without the annoying popups or distractions that turn people off like heavy advertisements. It is easy to...

The stored procedure is not available.... Does anyone have the sproc?

I think you just missed the whole point!

Sox is not the problem here, but the lack of understanding of what sox requires of us.  People are always with their...

If you are running a dts that involves more than 1 machine, is  AMERICA\SVCSQL and admin on all machines? 

  That's usually the case, where somoene takes your tools to be able to do your job away then they figure out that they made you handicapped.  But that is...

Bombard them with requests and then you'll see how fast they'll change it and give you rights again.

I haven't tested this, but does this make sense?

1 - Do a Select with a left join from db1.table1 to db1.table2 (selecting all fields except the identity field INTO a...

Thank you for trying to answer my question, but maybe I was not clear enough.  When I said "export from my Briefcase", I meant from the briefcase on the sqlservercentral...

sounds like you'll end up going with the 1 hard drive for OS and the other 4 for your RAID5 db's and logs on same drive.