Yes, So For Row 1 "ABC" is the data and for Row 2 "ABCX" is the data where "X" is additional.

NOTE: For Row 2 to flag as duplicate it...

Declare @principalServer01 varchar(50);

SELECT @principalServer01=state_desc

FROM [Server01].master.sys.databases

WHERE name = 'databasename';

IF @principalServer01='ONLINE'

Declare @principalServer02 varchar(50);

SELECT @principalServer02=state_desc

FROM [Server02].master.sys.databases

WHERE name = 'databasename';

IF @principalServer02='ONLINE'

I use this query when I meant Server01='ONLINE'

Sorry, I forgot to mention that I need bring data to another server.

- DataServer (Where I need data)

- Server01 (Database Mirroring Server)

- Server02 (Database Mirroring Server)

and I need to run...

Great 🙂

Thanks

Example:

Column_A Output_Needed

---------- ...

I am looking at MERGE statement and playing around... will let you know how it goes...

Thank you!!

I have to pull all the columns to compare it.

It's a heap table..

I used a drop down menu, but will try with SQL Statement.

Thanks.

It's very slow... Transferring into the cache

Do you have any other suggestion... Also, I don't have enterprise environment.

Thank you!!

I was just using example.

I want date datatype to converted into datetimeoffset datatype while passing parameter.

Thanks for your help.

Thank you guys..I was able to load the data...

Sorry, I was not clear enough. I need to update table name.

From TableA, TableB to aaa_TableA, aaa_TableB.

Thanks.

so we have 3 tables involved here, what is the source and destination tables of the data being transfered? Are the tables in the same database?

-- Same database

Are you...

/****** Object: Table [dbo].[pp] ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[pp](

[e_id] [bigint] NULL,

[p_id] [bigint] NULL,

[pr_id] [int] NULL,

[s_name] [varchar](256) NULL,

[pro_id] [varchar](512) NULL,

[timestamp] [varchar](30) NULL,

[extra] [varchar](max) NULL,

[checked] [bit]...