Forum Replies Created

Viewing 13 posts - 586 through 598 (of 598 total)

  • RE: Top N sub query workaround - Does it exist?

    Am I still missing something?

  • RE: Top N sub query workaround - Does it exist?

    Sure, will do.

    Sorry for the touble.

  • RE: Top N sub query workaround - Does it exist?

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

  • RE: Top N sub query workaround - Does it exist?

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

  • RE: Top N sub query workaround - Does it exist?

    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]...

  • RE: Top N sub query workaround - Does it exist?

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

  • RE: Index key with a maximum length of 1004 bytes

    Geez long night, I meant the where..

    Thanks Gail.

  • RE: My problem 'LIKE' Child

    Here it is..

    Thanks again Gail.

  • RE: My problem 'LIKE' Child

    K, will do thanks Gail.

  • RE: Indexing a one table, for just one proc

    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

  • RE: Top N sub query workaround - Does it exist?

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

  • RE: Top N sub query workaround - Does it exist?

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

  • RE: Top N sub query workaround - Does it exist?

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

Viewing 13 posts - 586 through 598 (of 598 total)