Thursday, May 29, 2008

[itsdifferent] A Tiny Fruit That Tricks the Tongue

A small red berry called miracle fruit temporarily rewires the way the palate perceives sour flavors, rendering lemons as sweet as candy.

read more on nytimes

Regards,
Sudev Gandhi

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Everyday Wellness

on Yahoo! Groups

Find groups that will

help you stay fit.

Yahoo! Groups

Familyographer Zone

Join a group and

share your pictures.

Do-It-Yourselfers

on Yahoo! Groups

How-to ideas,

projects and more.

.

__,_._,___

Wednesday, May 28, 2008

[itsdifferent] Re: Comma separated list of values of single Database table field

I Normally use Regular Expressions, however this depends on where you
want the presentation layer, on Business Module / Database or in the
actual presentation.

thanks

--- In itsdifferent@yahoogroups.com, "sudev_gandhi" <sudev.gandhi@...>
wrote:
>
>
> Of course one can do it... but when you require this kind of information
> programatically you need to iterate through records. In that case he'll
> have to use some piece of program using loop constructs like cursors (in
> case of T-SQL) or if he prefer he can do it by iterating in ADO.Net
> dataset also.
>
>
>
>
> --- In itsdifferent@yahoogroups.com, "Brijesh" <brijesh.pandya@>
> wrote:
> >
> > I would have just copied single column output in a text editor and did
> > a newline V/s Comma replacement.
> >
> >
> > --- In itsdifferent@yahoogroups.com, "sudev_gandhi" sudev.gandhi@
> > wrote:
> > >
> > > Many times you need to create a comma seperated list of values in a
> > > table. Here is a line of T-SQL solution to get comma separated list
> of
> > > values of single field of a database table.
> > > DECLARE @commaSeparatedVal AS VARCHAR(MAX);
> > >
> > > SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') +
> > > CONVERT(VARCHAR,[SKU]) FROM PRODUCT
> > >
> > > PRINT @commaSeparatedVal
> > >
> > > Regards,
> > > Sudev Gandhi
> > > [Recent Articles On My Blog] <http://sudev.blogspot.com/>
> > >
> >
>

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Y! Messenger

Files to share?

Send up to 1GB of

files in an IM.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Special K Group

on Yahoo! Groups

Join the challenge

and lose weight.

.

__,_._,___

[itsdifferent] Re: Comma separated list of values of single Database table field

Of course one can do it... but when you require this kind of information programatically you need to iterate through records. In that case he'll have to use some piece of program using loop constructs like cursors (in case of T-SQL) or if he prefer he can do it by iterating in ADO.Net dataset also.

 


--- In itsdifferent@yahoogroups.com, "Brijesh" <brijesh.pandya@...> wrote:
>
> I would have just copied single column output in a text editor and did
> a newline V/s Comma replacement.
>
>
> --- In itsdifferent@yahoogroups.com, "sudev_gandhi" sudev.gandhi@
> wrote:
> >
> > Many times you need to create a comma seperated list of values in a
> > table. Here is a line of T-SQL solution to get comma separated list of
> > values of single field of a database table.
> > DECLARE @commaSeparatedVal AS VARCHAR(MAX);
> >
> > SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') +
> > CONVERT(VARCHAR,[SKU]) FROM PRODUCT
> >
> > PRINT @commaSeparatedVal
> >
> > Regards,
> > Sudev Gandhi
> > [Recent Articles On My Blog] <http://sudev.blogspot.com/>
> >
>

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Need traffic?

Drive customers

With search ads

on Yahoo!

John McEnroe

on Yahoo! Groups

Join him for the

10 Day Challenge.

Yahoo! Groups

Special K Challenge

Join others who

are losing pounds.

.

__,_._,___

[itsdifferent] Re: Comma separated list of values of single Database table field

I would have just copied single column output in a text editor and did
a newline V/s Comma replacement.

--- In itsdifferent@yahoogroups.com, "sudev_gandhi" <sudev.gandhi@...>
wrote:
>
> Many times you need to create a comma seperated list of values in a
> table. Here is a line of T-SQL solution to get comma separated list of
> values of single field of a database table.
> DECLARE @commaSeparatedVal AS VARCHAR(MAX);
>
> SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') +
> CONVERT(VARCHAR,[SKU]) FROM PRODUCT
>
> PRINT @commaSeparatedVal
>
> Regards,
> Sudev Gandhi
> [Recent Articles On My Blog] <http://sudev.blogspot.com/>
>

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Y! Messenger

Send pics quick

Share photos while

you IM friends.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Family Photos

Learn how to best

capture your

family moments.

.

__,_._,___

[itsdifferent] Comma separated list of values of single Database table field

Many times you need to create a comma seperated list of values in a table. Here is a line of T-SQL solution to get comma separated list of values of single field of a database table.
 

DECLARE @commaSeparatedVal AS VARCHAR(MAX);

SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') + CONVERT(VARCHAR,[SKU]) FROM PRODUCT

PRINT @commaSeparatedVal

Regards,
Sudev Gandhi

Recent Articles On My Blog

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
New business?

Get new customers.

List your web site

in Yahoo! Search.

Y! Messenger

Send pics quick

Share photos while

you IM friends.

Wellness Spot

Embrace Change

Break the Yo-Yo

weight loss cycle.

.

__,_._,___

Monday, May 26, 2008

[itsdifferent] Importance of !important in CSS

Do you know What does !important mean in CSS?, an "!important" declaration (the keywords "!" and "important" follow the declaration) this takes high precedence over a normal declaration. And can be framed in this way, this means that the styles are applied in order as they are read by the browser.

CSS it tries to create a balance of power between author and user style sheets. By default, rules in an author's style sheet override those in a user's style sheet. But in CSS1, this is in other way round - Author "!important" rules took precedence over User "!important" rules.


For Example:
User's Style Sheet:
   1: <style> 
   2:   p{font-size: 2em !important;} 
   3:   p{font-style: italic;} 
   4: </style>

Author's Style Sheet:
   1: <style> 
   2:   p{font-size: 3em;} 
   3:   p{font-style: normal;} 
   4: </style> 

If you see in the above instance, the first rule in the User's Style Sheet has "!important" declaration, which will overrides the first rule in the Author's Style Sheet. And if you observe for the second rule in User's Style Sheet it does not contain "!important" so this will be ruled out because here second rule in the Author's Style Sheet has got high preference so the HTML will render by taking size as "p{font-style: normal;}"

If you would like to know more on this, then check with the w3 site:
w3.org and move to the section called "6.4.2 !important rules"
 
Regards,
 
Sudev Gandhi

Sudev Gandhi Blog

Âª Grab this Headline Animator

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Y! Messenger

Files to share?

Send up to 1GB of

files in an IM.

Yahoo! Groups

Women of Curves

Discuss food, fitness

and weight loss.

.

__,_._,___

Friday, May 23, 2008

[itsdifferent] Google Treasure Hunt 2008

Dare to take the challenge ?

have a look Google Treasure Hunt 2008


--
Brip

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Y! Messenger

Group get-together

Host a free online

conference on IM.

Healthy Living

Learn to live life

to the fullest

on Yahoo! Groups.

Get in Shape

on Yahoo! Groups

Find a buddy

and lose weight.

.

__,_._,___

Friday, May 16, 2008

[itsdifferent] Some Interesting Facts about Rajnikant

Sorry for posting funny message to our group, but its too good I could not hold myself sharing with you all.
Visit: http://devenkhatri.blogspot.com/2008/05/some-interesting-facts-about-rajnikant.html
______________________________________
Sent from my www.pageflakes.com startpage

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Green

Get things and

get things for free.

Find out how.

Y! Messenger

Files to share?

Send up to 1GB of

files in an IM.

.

__,_._,___

[itsdifferent] The Beauty of Mathematics

Beauty of Mathematics !!!!!!!

1 x 8 + 1 = 9
12 x 8 + 2 = 98
123 x 8 + 3 = 987
1234 x 8 + 4 = 9876
12345 x 8 + 5 = 98765
123456 x 8 + 6 = 987654
1234567 x 8 + 7 = 9876543
12345678 x 8 + 8 = 98765432
123456789 x 8 + 9 = 987654321

1 x 9 + 2 = 11
12 x 9 + 3 = 111
123 x 9 + 4 = 1111
1234 x 9 + 5 = 11111
12345 x 9 + 6 = 111111
123456 x 9 + 7 = 1111111
1234567 x 9 + 8 = 11111111
12345678 x 9 + 9 = 111111111
123456789 x 9 +10= 1111111111

9 x 9 + 7 = 88
98 x 9 + 6 = 888
987 x 9 + 5 = 8888
9876 x 9 + 4 = 88888
98765 x 9 + 3 = 888888
987654 x 9 + 2 = 8888888
9876543 x 9 + 1 = 88888888
98765432 x 9 + 0 = 888888888

Brilliant, isn't it?

And look at this symmetry:

1 x 1 = 1
11 x 11 = 121
111 x 111 = 12321
1111 x 1111 = 1234321
11111 x 11111 = 123454321
111111 x 111111 = 12345654321
1111111 x 1111111 = 1234567654321
11111111 x 11111111 = 123456787654321
111111111 x 111111111 = 12345678987654321



Now, take a look at this...


101%



From a strictly mathematical viewpoint:



What Equals 100%?
What does it mean to give MORE than 100%?

Ever wonder about those people who say they are giving more than 100%?

We have all been in situations where someone wants you to
GIVE OVER 100%.

How about ACHIEVING 101%?


What equals 100% in life?


Here's a little mathematical formula that might help
answer these questions:


If:

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Is represented as:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26.


If:


H-A-R-D-W-O- R- K


8+1+18+4+23+ 15+18+11 = 98%


And:

K-N-O-W-L-E- D-G-E


11+14+15+23+ 12+5+4+7+ 5 = 96%


But:

A-T-T-I-T-U- D-E


1+20+20+9+20+ 21+4+5 = 100%



THEN, look how far the love of God will take you:



L-O-V-E-O-F- G-O-D


12+15+22+5+15+ 6+7+15+4 = 101%


Therefore, one can conclude with mathematical certainty that:

While Hard Work and Knowledge will get you close, and Attitude will
get you there, It's the Love of God that will put you over the top!

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Recent Activity
Visit Your Group
Yahoo! Green

Get things and

get things for free.

Find out how.

Y! Messenger

Want a quick chat?

Chat over IM with

group members.

Yahoo! Groups

Balance your life

by learning how to

make smart choices.

.

__,_._,___

Wednesday, May 07, 2008

[itsdifferent] Solar Powered Hearing Aid

finally I found something to cheer

With growing population of Elderly people around the world, a common need of hearing aid is increasing.

Howard Weinstein has successfully developed a solar powered hearing aid, Yes you heard that right, it does not needs any battery.

This Canadian business man's mission in Africa was to set up a company that would provide affordable hearing aids to partially deaf Africans.

Like all developing country, medical is not cheap in Africa, and hearing aid was an ailment only rich people can afford.

As per World Health Organization (WHO) there are roughly 250 million hearing-impaired people around the globe, out of that two thirds of them living in developing nations, however only 10 million instruments are made. Battery of the aid is the problem of the cost, it is estimated that 1$ cost of battery will last for just one week, certainly in India , China, Africa and Latin America 1$ can give you food for a day.

Weinstein did a great research and talked to many people, some financiers, tech geeks and industry exec.

He came up with "a cheap hearing aid powered by rechargeable solar batteries", keeping size, weight and all features just same, only change was in price.
It now cost less than $100, almost 20% of the price of the cheapest model avilable today. and not to mention that these rechargable battery last 2-3 years. Instrument comes with a  pocket-size recharger that can either plug into a wall outlet or use its own built-in solar panel.

Weinstein is getting funding from the Ashoka Foundation and the Oregon-based Lemelson Foundation.

Wish him all the Best.

--
Tech News

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Healthy Living

Learn to live life

to the fullest

on Yahoo! Groups.

Find helpful tips

for Moderators

on the Yahoo!

Groups team blog.

Home Improvement

on Yahoo! Groups

Find tips & tricks

for doing it yourself.

.

__,_._,___

Monday, May 05, 2008

[itsdifferent] Managed Extensibility Framework - MEF

Managed Extensibility Framework (MEF) will be the new product from the MS.net framework family.

Microsoft's .NET Framework team is working on MEF which will help to improve compatibility with third-party extensions.

This framework will replace ad-hoc development and will provide single point solution for all API needs for a developer who are writing Application extensions.

Managed Extensibility Framework (MEF) will consists of three technologies that work together

  • A Dependency Injection (DI) framework
  • A Naming and activation service
  • A "duck typing" structural type system.

Although this sounds like Object builder (Patterns and Practices), Cwalina (MEF program manager) assures this will be a revolution in .Net Application usage, he added that the development team is working closely with the Unity framework as well as the DI community to develop MEF.

Click here to see samples / blogs and discussions regarding Managed Extensibility Framework (MEF).

--
Microsoft .Net Tech News

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Y! Groups blog

the best source

for the latest

scoop on Groups.

Give Things.

Get Things.

It's free and it's

good for the planet.

Women of Curves

on Yahoo! Groups

see how women are

changing their lives.

.

__,_._,___