mmm

Ok I have feeling that Jeffs question is going to lead to using a Numbers Table?!?!?

So you could please let us know the answer to that question it would be...

HI All,

How about this?

SELECT

STUFF(CASE WHEN LEN(@vctemp)<=2

THEN UPPER(@vctemp)

ELSE UPPER(LEFT(@vctemp,1)) + LOWER(SUBSTRING(@vctemp,2,LEN(@vctemp)))

END,PATINDEX('% _%',@vctemp)+1,1,UPPER(SUBSTRING(@vctemp,PATINDEX('% _%',@vctemp) +1,1)))

Thanks

Chris

Thanks very much for tht explination 🙂

Thanks all for your posts 🙂

Thanks Jason,

The login I would think would make a difference yes good point.

does anyone have any feedback on the main difference/benifits of "assert" vs "compute scalar" in an execution plan?

Thanks Grant.

Thats what I thought.

If anyone has found a reason to use I'd be interested know?

I won't I'm sorry to say 🙁

I'm currently in the UK working for an insurance software house.

Would have been good to meet up to be honest 🙂

When I was in...

Thanks Todd 🙂

Well done Gail...

It's good to see a fellow South African representing in the world of SQL 🙂

Where in SA you from?

congrats Jeff and Michael,

It's been a sometime coming 🙂

Just wanted to say that Todd, that is very good advise for newbie, I like the way you not only help him with the problem but also gave him tools...

I'm gonna go with Noel on this one...

You will prob find that this user has more data in some of the cols being returned which is going to exceed the...

Hi all,

Kaushal I see what you trying to do but changing the zero base.

GSquare is prob right, but we still won't wont' know without a schema and some data 🙂

Please also note that if no one is absent or present then you will get a division by zero error.

HI,

Please could you tell us what Present and Absent values are so that we have data to work with 🙂

Thanks

Chris