Here's another...

Create Procedure myProc

AS

Declare @IntCertNo As Int

--first clear table

BEGIN

delete from dbo_GR_tbl_FitterQuals

END

Set @IntCertNo = 1 --initialise

--write fitter details where available

While @IntCertNo < 11 --covers all ten types with one spare...

varchar(30) is fine...did you test it by inserting the actual strings - 'aqua', 'blue' etc..or was it a variable ?!

btw...is the prodID the same for all rows ?

It's useful to keep db scripts handy if you want to run some tests on a subset (or all) of the database and you want to use it with test...

If the data type was char(3) that would make sense...but not if you say that the first entry is stored correctly...

maybe your text fields have a max length set on...

What about the branchID in the 2 tables ?! You could use that in your join instead if these can be linked!

Sorry - My bad - I thought you said one object at a time....not one database....there are scripts on this site that should help you script all of them...I think...

You don't have to do it one at a time....EM gives you the options of choosing between the various objects to be scripted...views, tables etc...all or some....in individual files or...

Again - everything hinges on the common fields and separate fields...

eg: You could always have one master table for the common data (insurer, premium, from, to...whatever) with a masterInsurerID which...

I think listing the additional fields would help...

If different data is held for each type of insurance then you would be better off having different tables for each type as...

Mark - what is the DDL of your class and schedule tables ?! Is there another column you can link ?!

As bond007 says - you're joining on classID - the...

Yes - my response will get only those values that are duplicate (somehow "reading between the lines" that is what I thought was the requirement)....

and yes - if you remove...

Ok - Darrell - I'll let you get away with this one....at this hour my razor sharp brain draws a blank!

oh wait..."A MAN...

Aah - then he should never have succumbed to temptation! More fool he...

Is that a reprimand or is there more than a note of envy in that question ?!

btw - why are the women "evil" ?!

Chiranjib - you were warned in the other post that the cursorsAreEvil people will "talk" to you... - well, here's one already - Remi's...