Declare @temp table (Id int identity(1,1) primary key, empname varchar(15), datecreated date )

insert into @temp (empname, datecreated)
select 'Austin', cast(GETDATE()-37 as date)
union
select 'Chris',...

Sure, Luis... I will post the DDL's in a while.

Yeah I knew that syntax was wrong, Thom. That's how my requirement is. Based on condition, I need to select records in between fromdate1 to todate 1 else date range...

(DB_DATETIMESTAMP) (@Var_DateTime) this was my first expression in derived column.
then I tried splitted into date and time separately into two columns and then tried concatenating (DT_WSTR,25) (SUBSTRING(@var_datetime, 1, 11))...

I am trying to convert into datetimestamp. I am able to get until first 3 digits of milliseconds but not the whole 6 digits. Actually the value is coming through...

Not any political reason. Thats how the architect has been recommended. They are also not sure about that. Any way I believe ADO.net would work. I have been waiting for...

Hi Kevaburg, Thanks for the link and the suggestions. I really appreciate it.

My only option is to have to pull data directly from cassandra. I can't use any interface layer...

Hi Eirik,

Were you able to get any information ?

Thank you , Eirik. Take your time . I'll definitely be waiting to hear from you.

I don't think they gonna use SQL 2016. So I'm not sure, Eirik. But please let me know about your idea. I will take it up to my architect team....

Yes exactly, Eirik. You got it.