can you explain why you want it in descending order ?

Designing databases , writing procedures!!you have to love every aspect of it!!!

i would not use char for numeric values,

for the second,third fields i would use tinyint,smallint because

1) it would be half the size of char

2) you would have to put...

that WILL be treated as four different queries ...

this should do it in one

UPDATE TempNew

SET Relation = CASE Evaluation

WHEN 1 THEN 'EVALUATION'

WHEN 0 THEN

CASE CHANNEL...

Sorry , This is the right answer , i've used the pubs database for the sample query

DECLARE @sql Nvarchar(500),

@Var NVarchar(100),

@rc int

SET @Var = '@RC int...

This should work for you

DECLARE @sql Nvarchar(500),

@Var NVarchar(100)

@rc int

SET...

Visual InterDev has a nice debugger for SP's!!

the whole idea of using a aliased column in the where clause goes against the way the query is processed in SQL . the where clause would be resolved first...

oh ye of little faith,

i think the query can be refined a bit to look for 0s'

this subquery can be modified like this

SELECT btiuser ,

cast (CASE

...

i should go and get some sleep 😉

its a group by clause thats missing , sorry for that

select btulogin as username ,

ISNULL ( vperhour , 'n/a') as vperhour ,

ISNULL...

as for the string being more than 8000 characters the solution would be to join

several variables like EXEC ( @var1 + @var2)

brian ,i think the solution using text datatype...

sorry that should be!!

select btulogin as username ,

ISNULL ( vperhour , 'n/a') as vperhour ,

ISNULL ( sperhour , 'n/a') as sperhour ,

ISNULL ( cperhour , 'n/a') as cperhour ,...

does this work for you??

select btulogin as username ,

ISNULL ( vperhour , 'n/a') as vperhour ,

ISNULL ( sperhour , 'n/a') as sperhour ,

ISNULL ( cperhour , 'n/a') as cperhour...

can you post the code!!

also what is the client app developed in??

i think the issue here is not explaining what the SP does but what the system or the module does as a whole .. unless the developer has a good...