Thanks for your reply, Mr. Brian. I got your point. I will first check with the client to run this script on their Teradata environment and based on the result...

Not allow me to attahed .sql file so copy paste code here.

SELECT case when REGEXP_INSTR(string, '/ OB/') > 0

OR REGEXP_INSTR(string, '/OB/') > 0

OR REGEXP_INSTR(string, 'OB//') > 0

OR REGEXP_INSTR(string, 'T/O') >...

Thanks, Jeff and Scott for your time.

Actually, once data is available in DB then only I will able to use system views, as you mentioned but in my case, I...

I am trying to automate whole things from source to DW. I had already done from staging to DW I need to run one script which will handle all scenarios...

please find below script for creating metatable

CREATE TABLE [dbo].[metatable](
[ID] [smallint] IDENTITY(1,1) NOT NULL,
[Table_Name] [varchar](50) NOT NULL,
[Schema_Name] [varchar](128) NOT NULL,
[Column_Name] [varchar](50) NOT NULL,
[Column_Datatype] [varchar](50) NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT...

Try to reregister ODBC or reinstall your ODBC driver. It will work.

solved i had provided wrong column name. both place i have provided packagetype rather than coveragetype

pivot will not work as i have multiple columns and 15m records. i use below code but it give me value for first column pcakgetype but it is not working...

Thanks for your reply. I had gone through it. seems it will give me new row but i want new columns. I am trying to update it as per my...

Thanks for your help

yes i want to write as date in sql server. but before that i need to check format yyyy-mm-dd other format then filter that data

Understand but .net application need to update status back to table. so i am worried about locking issue

I have total more than 1 million records and my SP will use by .net application with 15-20 thread. so Application read one row and update status base on some...

You can use SSIS package and provide precedence constraint is success then only go to next step.

HI,

It's done. I have added tables with auto incremental id and foreign key to create dummy nodes. Once again Thanks for your help