Viewing 15 posts - 841 through 855 (of 1,082 total)
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 7:37 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 7:32 am
Thanks very much for tht explination 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 2:43 am
Thanks all for your posts 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 9, 2008 at 2:42 am
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?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 8, 2008 at 9:35 am
Thanks Grant.
Thats what I thought.
If anyone has found a reason to use I'd be interested know?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 8, 2008 at 9:33 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 3, 2008 at 4:46 am
Thanks Todd 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 3, 2008 at 3:56 am
Well done Gail...
It's good to see a fellow South African representing in the world of SQL 🙂
Where in SA you from?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 3, 2008 at 3:48 am
congrats Jeff and Michael,
It's been a sometime coming 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
July 2, 2008 at 2:59 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 27, 2008 at 5:34 pm
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 27, 2008 at 5:30 pm
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 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 27, 2008 at 5:24 pm
Please also note that if no one is absent or present then you will get a division by zero error.
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 27, 2008 at 8:33 am
HI,
Please could you tell us what Present and Absent values are so that we have data to work with 🙂
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
June 27, 2008 at 8:29 am
Viewing 15 posts - 841 through 855 (of 1,082 total)