The errormessage is indicated in TEST; its the lasts ddl I placed.

Now, my rule is that: basically where ever there is an update you update the the table with the values. You determine what table to update by the error message.

If...

INSERT INTO [janinetestdata].[dbo].[EDUCATION] VALUES(2,3,4,6,2,4398)

INSERT INTO [janinetestdata].[dbo].[EDUCATION] VALUES(2,3,7,5,3,4237)

INSERT INTO [janinetestdata].[dbo].[HH_ALL] VALUES(36144 , 2 , 3 , 21227 , 5 , 6 , 8 , 1 )

INSERT INTO [janinetestdata].[dbo].[HH_ALL] VALUES(36157 ,...

INSERT INTO [janinetestdata].[dbo].[EDUCATION]

([ED_THREE]

,[ED_FOUR]

...

USE [janinetestdata]

GO

/****** Object: Table [dbo].[EDUCATION] Script Date: 02/27/2013 13:05:32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[EDUCATION](

[ED_THREE] [float] NULL,

[ED_FOUR] [float] NULL,

[ED_FIVE] [float] NULL,

[ED_SIX] [float] NULL,

[PERSON_NUMBER] [float] NULL,

[zBarcode]...

Im new to sql. Where can I find the ddl?

Okay, but its showing only one though. I don't know why. I will show you the one using cursors versus the select state

Below is the cursors

USE [janinetestdata]

GO

/*Purpose of the sql...

For example, the select statements finds 10 rows that contain 'UPDATE', it would do the sql execution on the 10 rows that contain 'UPDATE'. But, the use of printing the...

I tried your way Lange; the only thing is that I can't view the selected data. For example, say the query ends up with 9 rows of data but only...

Thanks, I will try that now.

Thanks, for your help. It works....