Hi,
Please find the script below.
USE [Wondb]

GO
/****** Object: Table [dbo].[Test]  Script Date: 9/7/2017 1:11:16 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE...

Hi,
Please find the attached excel and import into DB.  In the attached file for date (2017-09-01 00:00:00.000) we will get 4 rows for RlSt= 60. so what I need...

Hi,

If you see the result in my previous posted query, we get 2 different OSID's for the same date('2017-09-01 00:00:00.000') with RlSt value as 66. In this case, we need...

Hi John,

Thanks you for explaining me the code and the person is not available to ask why he written this code. 

Regards,

Viay

Hi John,

Please find the code below.

   TRUNCATE TABLE cache.table
    
    INSERT INTO cache.Table
    SELECT * from [inkedserver].Database.dbo.Table
        
    
    BEGIN TRANSACTION
        ALTER SCHEMA cache1 TRANSFER dbo.Table;
        ALTER...

Hi John,
Thanks for the info. In my case there are tables with 2 schema's which already exists. For ex: cache.table name and dbo.Table name. first they are truncating data...

Hi,

Based on TimeZone...

Nope.

Regards,

Vijay