Viewing 15 posts - 1 through 15 (of 47 total)
This is what the data looks like:
calldate calltime duration phonenum empnum
2013-12-31 00:00:00.000 10:59 00:01:19 2679682968 23
2013-12-31 00:00:00.000 8:42 00:01:06 7314354142 83
December 7, 2017 at 7:23 am
So what i trying to do is create the materialized view on this table: Combining the calldate + calltime field
CREATE TABLE [dbo].[CALLS](
[calldate] [datetime] NOT NULL,
[calltime] [char](5)...
December 6, 2017 at 12:48 pm
Those are time values stored in the time column, I've change that column to be type = time, I 'thought' now my problem was interrogating time differences in a case...
November 2, 2017 at 4:48 am
Thanks, but that didn't work as planned. I WAS ABLE to copy all data into another table and create a 'time' datatype. Now my issue changing the case statement to...
November 1, 2017 at 1:32 pm
Sorry...
INSERT [dbo].[CALLS] (calldate, calltime ,duration, duration_in_decimal, ext, trunk, calltype, io, areacode, phonenum, dept, fname, lname, empnum)
VALUES ('2017-10-31 00:00:00.000', '9:01','00:04:10', '0.0692000', '3301', '', 'TLD', 'O', '609',...
November 1, 2017 at 10:38 am
CREATE TABLE [dbo].[CALLS](
[calldate] [DATETIME] NOT NULL,
[calltime] [CHAR](5) NOT NULL,
[duration] [CHAR](8) NOT NULL,
[duration_in_decimal] [DECIMAL](18, 7) NULL,
[ext] [CHAR](5) NOT NULL,
[trunk] [CHAR](5) NOT NULL,
[calltype] [CHAR](3) NULL,
November 1, 2017 at 7:00 am
Here is the plan minus linked server..Thanks for your help.
September 18, 2017 at 6:41 am
Thanks, i'll give it a read, the query is from dev.
September 15, 2017 at 1:14 pm
here it is.
Thanks
September 15, 2017 at 12:39 pm
Excuse the ignorance, but what type of file would you like? ...Thanks
September 15, 2017 at 12:35 pm
Interesting, Yes, we are looking to upgrade the entire domain. So there no setting/config in SQL to determine authenticating protocol method? Even when using SQL logins?
Does...
July 13, 2017 at 4:53 am
Appreciate the suggestion, but it still doesn't like it..
September 12, 2016 at 1:00 pm
If i have 10 other SQL servers making the same call how can it be an Oracle issue? Possible the Oracle client on that Sql Server. and making explicit columns...
April 30, 2015 at 8:57 am
Viewing 15 posts - 1 through 15 (of 47 total)