Yes it did... Thanks Again Lynn 🙂

Haha I confused you with my bad english....or may i did not understand this statement

set identity_insert dbo.FamGroup_Lookup off;

go

But when I used your query on my database,...

Thanks to every one who has been trying to help me...

Lynn, I have to update the column with the primary key not with the identity key...

here is the solution...I just...

well on a sample table yes it works... On my actual production table it wont the errors that i have been showing you are from my production table

UPDATE employees

SET ID= EXTENDEDID

WHERE ID<> EXTENDEDID

Same Error

Msg 512, Level 16, State 1, Procedure trig_AfterFamGroupInsert, Line 10

Subquery returned more than 1 value. This is not permitted when...

Infact the same error for all of them like i mentioned before...

This is the statement

I get

Msg 512, Level 16, State 1, Procedure trig_AfterFamGroupInsert, Line 10

Subquery...

@ above all

Well, its just an example... My work place might have had really bad designers when they started designing the database... That Primary key column(ID) is not used in...

use select statement followed by order by columnname DESC

I am planning to take this exam too.. Katie and Emil's website is giving me pretty good approach.. Thanks

Donno How I missed this simple detail... Thanks a ton.. u saved my day

Thanks for the reply

my requirement is using a while loop because there are some 300 lines of code is involved after selecting each dbname in the while loop..

I wonder if...

Eugene Elutin (3/4/2013)

---

I...

This is my Answer....

Lynn Pettis (2/26/2013)

---

Also, if you are attempting to populate columns of existing rows of data, INSERT is not what you want, you want UPDATE.

Looking at your dynamic...

I want to delete this post...It a mistake..Donno how to do it... SO writing somehting

SOurce table

Destination Table

CREATE TABLE [dbo].[Organization](

[OrganizationID] [int] NOT NULL,

[DioceseID] [int] NULL,

[ParishID] [int] NOT NULL,

[Diocese]...