Viewing 13 posts - 16 through 28 (of 28 total)
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, '') =...
September 28, 2005 at 9:47 pm
About 20 seconds(?) There were approx 460k rows to update.
September 27, 2005 at 11:10 pm
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...
September 27, 2005 at 7:08 am
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...
September 27, 2005 at 4:52 am
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...
September 27, 2005 at 2:50 am
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 ...
September 26, 2005 at 11:54 pm
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...
September 26, 2005 at 11:05 pm
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'...
September 25, 2005 at 10:19 pm
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,...
September 25, 2005 at 7:07 pm
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,...
September 25, 2005 at 1:41 pm
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...
September 22, 2005 at 11:23 pm
Viewing 13 posts - 16 through 28 (of 28 total)