yes,same image with different name.Sorry for before reply

I didn't try this but as per my previous issue I used computed column properties of that column.

Thanks for your suggestion. I will follow your suggestion.

I don't have SEQ_NUM on the master table.

This one is the table from which I want to copy data

USE [TmsEPrd]

GO

/****** Object: Table [dbo].[STUDENT_DIV_MAST] Script Date: 3/7/2016...

OK. I just want to copy one table's data to another table without null values and I already wrote query for that...

insert ADVISOR_STUD_TABLE(ID_NUM,ADVISOR_ID) select s1.ID_NUM,s1.ADVISOR_ID_NUM from STUDENT_DIV_MAST s1

where s1.ADVISOR_ID_NUM is...

No, I just give same title by mistake but I want to insert some data not update. I am now on next step of my phase.

Thanks

Hello I just make some changes in query and it seems like its working

update ADVISOR_STUD_TABLE set advisor_stud_table.ADVISOR_ID=STUDENT_DIV_MAST.ADVISOR_ID_NUM from STUDENT_DIV_MAST

where STUDENT_DIV_MAST.ADVISOR_ID_NUM=ADVISOR_STUD_TABLE.ADVISOR_ID and

STUDENT_DIV_MAST.ADVISOR_ID_NUM is not null;

Ok. Advisor_stud_table information

USE [TmsEPly]

GO

/****** Object: Table [dbo].[ADVISOR_STUD_TABLE] Script Date: 3/4/2016 11:16:35 AM ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [dbo].[ADVISOR_STUD_TABLE](

[APPID] [int] NOT NULL,

[ADVISOR_ID] [int] NOT...

OK, I am sending you whole table information:

This one is for ADVISOR_STUD_TABLE

USE [TmsEPly]

GO

/****** Object: Table [dbo].[ADVISOR_STUD_TABLE] Script Date: 3/4/2016 11:16:35 AM ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

SET...

Hello,

I also tried this before but sorry to say that I forgot to mention.

I just executed first query and we have some duplicate student ids so I get following error:

UPDATE

...

I couldn't set that allow null property. It has primary key...

Is there any other way to do this?

Thanks for your reply. I am trying to install izenda. And it creates this procedure automatically during installation. But unfortunately this procedure failed and I couldn't give permissions to anyone....