CREATE PROCEDURE dbo.A

  (

   @PersonnelNumber As Integer

 &nbsp

as

 SELECT      e.DisciplineID

 FROM    Employees e

 WHERE

 e.PersonnelNumber =  @PersonnelNumber

GO

CREATE PROCEDURE dbo.B

  (

   @DisciplineID As Integer

 &nbsp

as

 SELECT      s.SkillName,

   s.SkillID

 FROM  Skills...

Does it mean that when I use replication, I shud not change my subscriber tables.

Thanks, I got my query done.

What exactly I need is carry over all IDENTITY values from the latest transaction occured from the parent tables to child.Any pls help.

But I think scope_identity() wud return only the last Identity value from the parent table.

Yeah I am not gud at designing and developing.

Actually I am a pure Administrator. Here I am forced to do all those things so breaking my head in those.

Thanks a lot.

Anyways u r gud at helping others.

FYI..

I am doing a job where I have to migrate old databases from Access and Oracle to SQL Server 2000 and then redesign them in a normalized way,later import all...

Yeah u r right but the thing is I migrated data from Access into sql database,when i tried changing data type then it says data may be lost.

What can be...

Do U mean tht the Design is not at all OK.

What changes u think have to be made in this scenario.

This is the insert statement pulling data from other DB

INSERT INTO perfmeasure..PM

(pmorderby,type,measure,frequency,measuredby,goal,source,definition,formula)

SELECT

perfsection,subsection,pmorderby,type,measure,frequency,measureby,goal,source,definition,formula

FROM PM..boa_pm

May be very silly..but I am damn new to SQL, learning things here.

I have changed table deisgn as per ur advice and posted my REAL table in thread "Insert". pls do check it.

 sorry for inconvinence.

OK I think I have to give REAL table. sorry for the inconvinence.

Table PM

MeasureNum  int 4 (PK)Identity

PMOrderBy    int 4  

Type           char 1 

Measure       nvarchar 255 

Frequency    nvarchar 255

MeasuredBy  nvarchar 255

Goal            nvarchar 255

Source        nvarchar 255

Definition     ntext 16

Formula       nvarchar 255

Table Owners

ComptCode  nvarchar 50

MeasureNum int(FK)

Owner         nvarchar 50

MeasureNum is the relation between...

Ok let me give another example for INSERT query

Table1[MeasureNO(PK),subsection,code,owner]

Table2[Type,source,MeasureNo(FK),owner]

Here in Table2 MeasureNo has multiple owner. How can I insert owner column in table1 from table2 where  MeasureNo has relation in...

Thanks dude.