I am trying to get the proc to go through the information in the table and find any information with a date older then 12 months then take the older...

ok cleared the selet i mis-typed it should of been select.

how do i set up flags in the table and how does this prevent replication of the data.

this is the stored proc:

USE [BOMVerifier]

GO

/****** Object: StoredProcedure [dbo].[Get_BomInfo] Script Date: 10/31/2008 15:19:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[Get_BomInfo]

@PARNT CHAR(15),

@CUSNO NUMERIC(10,0),

@REVCD CHAR(3),

@CSEQN NUMERIC(3,0),

@child...

my stored procedure pulls information from an as400 and puts it into the database for others to view.

but if i set up a step to delet after it process wouldn't always delet the files or is there a command I would use in the second step to...

I have change the code some and that go is gone here is what i have now.

USE [BOMVerifier]

GO

/****** Object: StoredProcedure [dbo].[Get_BomInfo] Script Date: 10/30/2008 12:14:25 ******/

SET...

OK I still see the error when I execute the stored procdure it places the information in the table but shows the error. but now all I have to have...

Nope the only table with the PARNT feild is in the openQuery and I check the open query produces the information I need from it and doing a query using...

What do you mean i used only one of them. if its with the a.PARNT = @PARNT its cause some one here at work said that was all i had...