Sample Data in the attachment

Psp_ps_no psp_item_no psp_item_var psp_qty_prpnl

6 DRR01DELT0004 ## 10.00000000

352 ...

beacause 352 OPTIONAL AUTO WIRING FOR DRR (ARAI)

in descriotion field in another table

Gianluca Sartori (6/6/2011)

INSERT INTO #temp (item_code,variant_code)

SELECT DISTINCT T2.psp_item_no,T2.psp_item_var

FROM pmddb..pmd_mpsp_ps_postn T2

WHERE T2.psp_io_flag = 'i'

AND NOT EXISTS (

SELECT 1

FROM #temp AS...

This cod is working : :w00t::w00t:

INSERT INTO #temp (item_code,variant_code) ...

This is true but I don't want SELECT only Distinct from the Source Table to insert.

I want only distinct record will be inserted into the Destination Table.

How is it possible...

Plz...

SQL SERVER 2005

USE [PMDDB]

GO

/****** Object: Table [dbo].[pmd_mpsp_ps_postn] Script Date: 06/01/2011 11:28:29 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [dbo].[pmd_mpsp_ps_postn](

[psp_company_no] [dbo].[GLCOMPANY] NULL,

[psp_ps_no] [dbo].[UDD_PSNO] NOT NULL,

[psp_ps_rev_no] [dbo].[UDD_REVNO] NOT NULL,

[psp_ps_pos_no]...

Thanks Wayne !!:-)

Actual Scenario

Hope that you are familiar with Production BOM (Manufacturing). Take an Example :

BPD (Variant 4000) is a Finished Item and it is assembled from the following Items...

I've done this with the help of CURSORS

Thanks to all .:-)

My Code Given below..

CREATE proc aaa

(

@item_no...

kindly reply

Suppose in a certain Table I have all the required data. Item Code is a field of this table.

Item--- BPD (finished Good)has three child Items BPD01, BPD02, BPD03 and

BPD01 has...

BPD & BPD001,BPD002,BPD003 has a relation.

BPD001 has relation with its child(BPDX01) Item but BPD has no direct relation to BPDX01...

Input parameter id BPD

Output are BPDX01, etc as shown in picture.