Viewing 15 posts - 2,956 through 2,970 (of 5,111 total)
Thom,
This poster will first need to determine duration from multiple records within a given...
October 6, 2017 at 9:39 am
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,...
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;...
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,...
October 6, 2017 at 9:03 am
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...
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...
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...
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...
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...
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...
October 5, 2017 at 11:19 am
October 5, 2017 at 6:23 am
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...
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...
October 5, 2017 at 3:48 am
Viewing 15 posts - 2,956 through 2,970 (of 5,111 total)