SSchampion

curser can u write sample query of it ?

@old hand

but i have the inner condition if @@rowcount=0 then break then shouldnt go infinite......

@sean

Curser ?? can u write sample query of it ?

yes i know tat ..but i want to use loop becoz want clear looping concept in SQL jst pretty mch confuse in it..

Select

full_name, Case WHEN full_name LIKE '% % %'

Then

SUBSTRING(full_name, (CHARINDEX(' ', full_name) + 1),

CHARINDEX(' ', (SUBSTRING(full_name, (CHARINDEX(' ', full_name) + 1),

(LEN(full_name) -

CHARINDEX(' ', full_name))))))

Else

null

End

'Middle_Name' From #names

update

#names set middle_name=Case WHEN full_name LIKE...

well tatz not important whether is the surname or not.. all i need is to break the string 🙂

yes ..it will always have space ......the only constant thing is space after every word....

wat will b the possible solution ??/

select ordernumber session_time session_id email_id

from table

where session_time=(select max(session_time) from table)

and email_id=(your desired email)

tat will be possible solution by my understanding of ur question!!

select ordernumber session_time session_id email_id

from table

where session_time=(select max(session_time) from table)

tat will be possible solution by my understanding of ur question!!

thanx its working 🙂

YES

hey guys i have figure it out.....and got the correct query thanx anyways 🙂

myquery

=============

select distinct a.country,a.zone,a.branch,a.user1,' ' as 'user2'

from test a ,test b

where

a.country=b.country

anda.zone=b.zone

and a.branch=b.branch

guys i have this two records of users of same country ,zone...