ok

i tried this one

CREATE TABLE [dbo].[emp_new](

[empid] [int] NULL,

[primary1] [varchar](20) NULL,

[primaryinten1] [int] NULL,

[secondary2] [varchar](20) NULL,

[secondaryinten2] [int] NULL,

[secondary3] [varchar](20) NULL,

[secondaryinten3] [int] NULL,

[secondary4] [varchar](20) NULL,

[secondaryinten4] [int] NULL)

empid primary1 primaryinten1 secondary2 secondaryinten2 secondary3 secondaryinten3 secondary4 secondaryinten4

1 HF 1 NULL NULL NULL NULL NULL NULL NULL NULL

1 NULL NULL CAD 1 NULL NULL NULL NULL NULL NULL

1 NULL NULL CADO 1 NULL NULL NULL NULL NULL NULL

1 NULL NULL MAN 1 NULL NULL NULL NULL NULL NULL

1 NULL NULL MANt 1 NULL NULL NULL NULL NULL NULL

now i tried

--select * from emp_new

----drop...

i am not finding a solution,please help me hwo to do it

the thing is i cannot use aggregate function in PIVOT , as i need to place character in the column

here @min-2 + @interval should not be > @end

how will i make sure that

no there is no more rule, but if you execute is second time it moves everything to scondition

and also there may be duplicate values

IF YOU EXECUTING IT SECOND TIME it moves all the values to scondition

also if there is duplicate example

id pcondition scondition

1 sa ...

this code is not working

it snot necessary that all 5 condition will exists for that particular ID, there can be 3 or 4 ,not all 5

in that case it has...

u r updating cte i need to update customecode table

but i dont need select ,i just need update statement, the store proc should not have select

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...

i am trying to explain it here

example:

ID pcondition scondition

1 HF ...

i used row_number ,but how to get multiple condition in update

for example if condition = 'HF'

then update

else if condition ='AST'

then update

but i need loop or condtion hwo to do it

example if primarycondition = 'HF'

then update table a

set secondary condtion = null

if there is no primary condition = 'HF'

then

if primarycondition =...

thisis not the result that i want

i have five PRIMARY condition ,

hf,

COPD,

CAD,

dia,

ast

primary intensity could be 1,2, 3

now i want to check suppose if i have all 5 condition...

my desire out put will be

Member primarycondition primaryintensity secondarycondition secondaryIntensity

M2345 hf ...