But there are like 50 columns inside the table so I have to use Coalesce for each Column

I am using ssis- file system task

need the query which will give me the expected result

No its not working

yeah, have to do it through cursors

SEAN,

I have to use the cursor ,as according to the requirement, so no wayout.

ohh my mistake , here is the query

ALTER PROCEDURE [dbo].[abc_specialty1_sp_]

@sysID bigint,

@qnxtStatus char(15),

@ReturnCode AS INT OUTPUT,

@ErrMsg nvarchar(4000)OUTPUT

AS

BEGIN TRY

BEGIN TRAN T1

SET NOCOUNT ON;

UPDATE abc_specialty_tbl

SET

code=CASE

WHEN NPVS.code IS NOT NULL

THEN...

this the stored proc which executed by cursor

ALTER PROCEDURE [dbo].[abc_specialty1_sp_]

@sysID bigint,

@qnxtStatus char(15),

@ReturnCode AS INT OUTPUT,

@ErrMsg nvarchar(4000)OUTPUT

AS

BEGIN TRY

BEGIN TRAN T1

SET NOCOUNT ON;

UPDATE abc_specialty_tbl

SET

code=CASE

WHEN NPVS.code IS NOT NULL

THEN...

Well, I have to call the 15 different stored proc through cursor based on conditions. This is onlt 1 of them , but all have same logic

But i want to update only those fields which comes in as not null