Thanks okfine08, This is also working but the query is running forever on the main database which has around 200K records

Thanks Fahey...It works perfectly for my requirement.

This is Working :

select T1.ID,T1.Number,T1.Description,piv.[0000000822] AS GRADE_LENGTH,piv.[0000000823] AS GRADE_WIDTH
from [dbo].[Table1] T1 JOIN
(
select [ID],[Grade],[Value]
from [dbo].[Table2]
) T2
pivot
(

I tried like 

SELECT T1.ID,T1.NUMBER,T1.DESCRIPTION,
CASE WHEN T2.GRADE='0000000822' THEN T2.VALUE END AS GRADE_LENGTH,
CASE WHEN T2.GRADE='0000000823' THEN T2.VALUE END AS GRADE_WIDTH
FROM [dbo].[Table1] T1 join [dbo].[Table2] T2...

Noted with thanks Thom...Please check below the statements:

--TABLE 1
CREATE TABLE [dbo].[Table1](
    [ID] [int] NULL,
    [Number] [INT] NULL,
    [Description] [varchar](20) NULL
) ;
GO
--TABLE...

Apologies for the format....I couldn't explain in detail..

Thank You for the replies....

Hi Sean,

DDL for my target looks like:

CREATE TABLE Equipment_TGT(

[Equipment_ID] [bigint] NOT NULL,

[Code] [nvarchar](50) NOT NULL,

[Description] [nvarchar](100) NOT NULL,

[TreeLevel] [smallint] NOT NULL,

[Parent_Id] [int] NULL,

[Parent_Code] [nvarchar](50) NOT NULL,

CONSTRAINT [pk_Equipment] PRIMARY KEY CLUSTERED...

Hi ...I got sample DDL's

CREATE TABLE Equipment(

[Equipment_ID] [bigint] NOT NULL,

[Version] [int] NOT NULL,

[Code] [nvarchar](50) NOT NULL,

[Description] [nvarchar](100) NOT NULL,

[IsActive] [bit] NOT NULL,

[TreeLevel] [smallint] NOT NULL,

[Parent_Id] [int] NULL,

CONSTRAINT [pk_Equipment] PRIMARY KEY...

We do not have separate Parent table.

How do i join the child table with itself to get the Parent_ID codes?

Thanks,

yes..Chris..

Thanks andy...

We have like after 40 characters the unit of measure is place in the description field. We have more than one space between the description and unit of measure.

Thanks for the reply...for the queries:

its like Five tasks run parallelly under which we have other tasks.

The mappings all are there already, i need to try improve the performance.

Its always...

Hi Zzartin...

I am still getting the error

'Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from character string.'

the column has below sample records :

940930

941027

941205

950117

0

1001213

1001214

0

1141128

1141129

1141130

Thanks...

Thanks guys for the reply's

Thanks Jason...The one with Varchar is working for me. But In some of the Columns we have '0' for which the conversion is failing. Can you...

Hi Sean,

I tried writing the function

CREATE FUNCTION dbo.Convert_Date (@date_column decimal(7,0))

Returns date as begin

declare @date date

set @date = CONVERT(DATE,CASE WHEN LEFT(@date_column,1) = '1' THEN '20'

ELSE '19' END + RIGHT(@date_column,6), 112)

RETURN...