Viewing 13 posts - 586 through 598 (of 598 total)
Am I still missing something?
January 19, 2009 at 9:33 am
Sure, will do.
Sorry for the touble.
January 19, 2009 at 9:31 am
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...
January 19, 2009 at 9:12 am
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....
January 18, 2009 at 11:01 am
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]...
January 18, 2009 at 9:40 am
The method I posted above worked...but gives me fewer records...so I'm stuck..
January 17, 2009 at 3:37 pm
Geez long night, I meant the where..
Thanks Gail.
January 17, 2009 at 1:19 pm
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
January 17, 2009 at 8:35 am
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...
January 17, 2009 at 7:44 am
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...
January 16, 2009 at 9:11 am
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...
January 16, 2009 at 7:28 am
Viewing 13 posts - 586 through 598 (of 598 total)