Forum Replies Created

Viewing 13 posts - 16 through 28 (of 28 total)

  • RE: converting statement

    Using a very similar construct.. this time I get the error:

    Server: Msg 208, Level 16, State 1, Line 1

    Invalid object name 'Asgn'.

    -------------------

    UPDATE Asgn

    SET Asgn.CaseResolvDatetime = CASE

    WHEN ISNULL(t1.CallId, '') =...

  • RE: converting statement

    About 20 seconds(?) There were approx 460k rows to update.

  • RE: converting statement

    That has worked. Thank you so much.

  • RE: converting statement

    Don't yet have it working.

  • RE: converting statement

    Really sorry Phil, but I think that's what I was having trouble with in the first place - having a test statement, and replacing the 'test statement' with the details...

  • RE: converting statement

    Not sure where to go from here. You've got a JOIN in the update where I'm only touch the 1 table in the database itself, and I don't see a...

  • RE: converting statement

    What you've done looks a bit different with a few different variables etc. I actually don't need this data in the database at all:

    --SELECT '00500588','Desktop', NULL UNION ALL

    --SELECT '00500588','SD...

  • RE: converting statement

    I was referring to the updating of the 'Asgnmnt' table

    I think you're asking for 'sp_help Asgnmnt' information.

    AssignedBy  varchar no 8             yes no no SQL_Latin1_General_CP1_CI_AS

    DateAssign  smalldatetime no 4       yes (n/a) (n/a) NULL

    TimeAssign  smalldatetime no 4       yes (n/a) (n/a) NULL

    AssignDatetime  datetime no 8       yes (n/a) (n/a) NULL

    GroupName  varchar no 15             yes no no SQL_Latin1_General_CP1_CI_AS

    AsgnCdrGrp  varchar no 1             yes no no SQL_Latin1_General_CP1_CI_AS

    Assignee  varchar no 20             yes no no SQL_Latin1_General_CP1_CI_AS

    Phone   varchar no 14             yes no no SQL_Latin1_General_CP1_CI_AS

    Comments  text no 16     ...

  • RE: converting statement

    Hi Phil,

    So close. This all looks right, except that with the actual updating of the table, the query just runs for 45 mins or more with no actual updating of...

  • RE: converting statement

    Hi Phil,

    as sample of what i get back is this:

    CallID                  GroupName         CustPendCase

    ----------           --------------     -------------

    00504164            Field Sup - Vic           N

    00504164            SD Followup              Y

    What I want is for CustPendCase be set to 'Y'...

  • RE: converting statement

    Hi Phil,

    I tried the following, but no results were returned into the CustPendCase column

    ---------------------------------

    DECLARE @table TABLE(CallID VARCHAR(8), GroupName VARCHAR(15), CustPendCase VARCHAR(1))

    INSERT @table(CallID, GroupName, CustPendCase)

    SELECT CallID,...

  • RE: converting statement

    Ok, thanks for your input. I have changed the statement to:

    ------------------------------------

    USE reporting

    go

    DECLARE @table TABLE(CallID VARCHAR(8), GroupName VARCHAR(15), CustPendCase VARCHAR(1))

    INSERT @table(CallID, GroupName, CustPendCase)

    SELECT CallID, GroupName, NULL

    FROM Asgnmnt

    -- SELECT CallID,...

  • RE: converting statement

    Still a bit lost. Basically I'm trying to substitute the following data:

    SELECT '00500588','Desktop',Null UNION ALL

    SELECT '00500588','SD Followup',Null UNION ALL

    SELECT '00500600','Server',Null UNION ALL

    SELECT '00500600','Service Desk',Null UNION ALL

    SELECT '00500777','SD Followup',Null UNION ALL

    SELECT...

Viewing 13 posts - 16 through 28 (of 28 total)