Hi, I am experimenting with migrating our SQL 2019 DBs to Azure Managed instances,  we currently use OraClient to connect to Oracle on-prem via linked servers. I am interested in...

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

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)...

Thank you so very much...Exactly what i needed...

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...

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...

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',...

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,

Here is the plan minus linked server..Thanks for your help.

Thanks, i'll give it a read, the query is from dev.

here it is.

Thanks

Excuse the ignorance, but what type of file would you like?  ...Thanks

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...

Thank you!!

Appreciate the suggestion, but it still doesn't like it..