Viewing 15 posts - 2,956 through 2,970 (of 5,109 total)
Zalouncha - Friday, October 6, 2017 9:07 AMHi Thom A,my data look slik ebelow:
CALLSTATID,CLIENTNO,CALLLOGID,CPGNO,CALLSTATE,LOCALISEDCALLSTATE,STATETIMEAGT,USEDBYAGENT,LOGAGENTNO,CALLLOGREF,COMPLETECODE,CTI_USER
1,1,10,5,Talking,Call time,08:27:38,agent1,123,NULL,NULL,70002
2,1,10,5,Hold,Hold,08:30:36,agent1,123,NULL,NULL,70002
3,1,10,5,Talking,Call time,08:34:17,agent1,123,NULL,NULL,70002
4,1,10,5,Hold,Hold,08:34:18,agent1,123,NULL,NULL,70002
5,1,10,5,Talking,Call time,08:34:52,agent1,123,NULL,NULL,70002
6,1,10,5,WrapUp,Wrap Time,08:36:19,agent1,123,NULL,NULL,70
Thanks. it would be great,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 9:18 am
ChrisM@Work - Friday, October 6, 2017 9:02 AMHave you got an actual plan for the faster query, Thom?
Sure. It's considerably different;...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 9:12 am
Without seeing your sample data, from your description I understand that a new row is inserted each time a status changes (with a duration? I've guessed yes). I also assume,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 9:03 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 8:38 am
Like Phil said, we have a requirement here. Are you actually asking how to work out an average? If so, which type of Average: Mode, Mean, Median? Let's assume you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 8:36 am
Know this has gone quiet, and I have a solution,but we're testing queries on 2017 now as we're planning to upgrade in the new year. Surprisingly, the new Cardinality Estimator...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 8:27 am
SSDT cannot deploy to SQL Server 2008. If you've done a one way upgrade on your project, and not kept a backup, you have problem, as you won't be able...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 6:31 am
If you're connecting to SQL Server 2008 then SSDT is not compatible. You have to use BIDS with SSRS/SSIS/etc 2008. SSDT 2017/2016 is compatible with SQL Server 2012 onwards. Conversely...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 5:47 am
A For Each Loop would normally be used if you have multiple files in one directory or set of sub directories. This means that the Loop can iteratively go through...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 6, 2017 at 3:03 am
Also, I feel there is no need to check that "today", and "30 days ago" is greater than 2011-09-18. Unless you invent a time machine and go back and run...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 5, 2017 at 11:19 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 5, 2017 at 6:23 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 5, 2017 at 4:48 am
I'm hazarding a bit of a guess here, but I'm I imagine that SSIS doesn't like the commas. As it is importing the column as a string, and (true) numbers...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 5, 2017 at 4:31 am
craig.jenkins - Thursday, October 5, 2017 3:31 AMgreat spot thankyou Thom, it should be IF GETDATE() >='2018-01-02' AND GETDATE() <'2018-01-03'
Ok, but my concern...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 5, 2017 at 3:48 am
I'm not sure that is correct. For example, one item I noticed is:IF GETDATE() >='2018-01-02' AND GETDATE() <'2017-01-03'
How can the current date be both greater or equal...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 5, 2017 at 3:25 am
Viewing 15 posts - 2,956 through 2,970 (of 5,109 total)