HERE YOU GO

CREATE TABLE CustomCode

(ID int,

pcondition varchar(50),

Pinten int,

scondition varchar(50),

sinten int)

INSERT into CustomCode

SELECT 1,'HF',1,NULL,NULL

UNION

SELECT 1,'CA',1,NULL,NULL

UNION

SELECT 1,'AF',1,NULL,NULL

UNION

SELECT 2,'CAD',2,null,NULL

UNION

SELECT 2,'AST',2,null,null

UNION

SELECT 3,'CA',1,NULL,NULL

UNION

SELECT 4,NULL,NULL,'HF',1

Order to Update :

If ID has more than one pcondition

one of them will be pconditrion and pinten

other will be scondition and sinten

Based on followind order

1 - AF

2- CA

3 - CAD

4 - AST

5- hf

Output :

IDpconditionPintensconditionsinten

1AF 1NULL NULL

1NULL NULLCA 1

1NULL NULL HF 1

2NULL NULL AST 2

2CAD 2NULL NULL

3CA 1 NULL NULL

4NULL NULLHF1