Thank you for your Response Jeff Moden!

here is my script for Dbmail.

--DECLARE @s-2 VARCHAR(max)

--SET @s-2 = 'Data for '+CONVERT(VARCHAR(12),GETDATE(),107)

DECLARE

@s-2 VARCHAR(max),

@query_result_separator CHAR(09),

@query_result_width SMALLINT,

@Qry2 VARCHAR(2048)

SET @s-2 = 'XXXXXX_'+CONVERT(VARCHAR(12),GETDATE(),107)

SET @query_result_separator =...

example data.

I mean columns. Blank means Empty strings. All columns are strings.

Thank you.

Thank you.

Only two columns for ID.

if the len(id) = 14 then it should be in ID1 otherwise it should be in ID2.

Thank you.

But i would like to use the function "len".

if the len(id) = 14 then it should be in ID1 otherwise it should be in ID2.

Can we achieve it ?

I would like to display the result in single row  like below .

FirstName LastName                 ID1                 ...

• This reply was modified 3 years, 8 months ago by  adisql.
• This reply was modified 3 years, 8 months ago by  adisql.

We have to transfer the data to other system in real time.

The other table resides in oracle database.

So first I am testing with sql table  if it works then I...

Thank you Rick.I totally understand your explanation.

We have some agreement restrictions for not to create trigger on Table.

So I am  trying to create trigger on view.

When ever cardnumber insert into...

Thank you Rick!!

Yes , It is working.

But my actual goal is , if the record insert into the underlying table then same record will be insert into the other table.

But...

Actual my requirement is , if new record insert in sql table then it will be copy over to oracle databse table.

FYI..

here is my view.only on one column from one table.

USE [Database1]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE VIEW [dbo].[View_Table1]

AS

SELECT distinct(idnumber)

FROM  Table1

GO

Basically anytime when a new record  is inserted into the specific table\column , it grab the record  and bring it over in some way for use in another system.

we have...