Thanks for the quick replys.

I'm thinking I should create a new table with state, county, abbrev...

Am I still missing something?

Sure, will do.

Sorry for the touble.

Like this Gail?

INSERT INTO Eventitems_rob (LogId,Company,CompanyId,Department,DepartmentId,CompanyCRN,DepartmentCRN,TitleUnit,TitleUnitId,State,County,OrderNo,OrderId,UserCompany,UserCompanyId,UserName,UserId,Source,Event,EventTime,EventValue,PI2Status,PI2LineCount,PI2RequestTrigger,PI2PrimaryRequestValue,Comment)

SELECT '418504535','Chicago Title','134','ServiceLink PA','845','00021','00090','01','910','CA','Madera','1734995','33806768','ServiceLink','190','Christina Young','1538','TitlePoint','Image-Recorded','Sep 29 2008 12:53PM','MA:2008 00020606','','','','',''

SELECT '358982648','PlantMaintenance','268','Arizona Locating','1132','PLADM','00009','Arizona Locating','1224','CA','Madera','[NONE]','29553378','PlantMaintenance','268','PM2 Janice Marquez','9837','TitlePoint','Image-Recorded','Jun 30 2008 1:01AM','MA:2

SELECT '358982677','PlantMaintenance','268','Arizona Locating','1132','PLADM','00009','Arizona Locating','1224','CA','Madera','[NONE]','29553378','PlantMaintenance','268','PM2 Janice Marquez','9837','TitlePoint','Image-Recorded','Jun 30 2008...

It would be great if the results could match the output of the orignal statement, as this is part of a larger proc that I would prefer not to change....

Sorry for the delay Jeff,

I followed the directions in your signature. Let me know if this is incorrect.

CREATE TABLE [dbo].[EventItems_rob](

[LogId] [int] NOT NULL,

[Company] [varchar](50) NOT NULL,

[CompanyId] [int] NOT NULL,

[Department]...

The method I posted above worked...but gives me fewer records...so I'm stuck..

Geez long night, I meant the where..

Thanks Gail.

Here it is..

Thanks again Gail.

K, will do thanks Gail.

Sure Gail, I understand completely.

I'm kinda new to this site, so wasn't sure if I should post something so large.

I'll work on breaking it down.

~Thanks

Thanks everyone...VERY much appreciated.

I ended up doing this...and it seemed to work well.

What do you all think?

UPDATE e

SET e.UserID = q.UserID

FROM #Events AS e

INNER...

Hi everyone, thanks again for all your help.

I tried Ramesh's suggestion first, but to my surprise, it was only slightly quicker.

Was then going to try Chris Morris's suggestion but I'm...

THANK YOU ALL SOOOOO MUCH!!

I really appreciate and am in awe of your skills.

You all may have saved my job!!!

Good karma to you all, and if any of you...