Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Assigning categories to values 2 Expand / Collapse
Author
Message
Posted Tuesday, May 14, 2013 9:56 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:45 AM
Points: 5,793, Visits: 8,003
Comments posted to this topic are about the item Assigning categories to values 2


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1452909
Posted Tuesday, May 14, 2013 11:25 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 06, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Yesterday i learn something and today i got the chance test it.
That's the best thing about QoD.
Thanks Hugo.




Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1452921
Posted Wednesday, May 15, 2013 12:39 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:46 AM
Points: 1,371, Visits: 1,547
I found Today's question relatively easier than yesterday. :)

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1452937
Posted Wednesday, May 15, 2013 1:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:50 PM
Points: 1,867, Visits: 2,275
Good question Hugo..
Specially the link of CASE won't always evaluate in order



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1452948
Posted Wednesday, May 15, 2013 1:06 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 11:50 PM
Points: 1,867, Visits: 2,275
Lokesh Vij (5/15/2013)
I found Today's question relatively easier than yesterday. :)
true



_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1452949
Posted Wednesday, May 15, 2013 1:34 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:17 AM
Points: 636, Visits: 508
kapil_kk (5/15/2013)
Lokesh Vij (5/15/2013)
I found Today's question relatively easier than yesterday. :)
true


+1 to that but I was looking for a catch somewhere in the answers though (paranoid much!!)



MCITP
MCTS - E-Business Card
Twitter: WWDMark

Try not! Do or do not, there is no try

email: info@weekendwebdesign.co.uk
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk
Post #1452953
Posted Wednesday, May 15, 2013 2:14 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 3:59 AM
Points: 1,938, Visits: 1,149
Easy one compared to yesterday QOTD. yesterday i got it wrong. i did not verify verify between operation -1 and -10.

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1452970
Posted Wednesday, May 15, 2013 2:17 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 671, Visits: 1,541
That is cool... how did you set two questions back to back? (if it was just out of luck then it is a strange luck....)


ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)
Post #1452971
Posted Wednesday, May 15, 2013 2:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:45 AM
Points: 5,793, Visits: 8,003
Raghavendra Mudugal (5/15/2013)
That is cool... how did you set two questions back to back? (if it was just out of luck then it is a strange luck....)

People who submit questions have no control over when they will be published. When submitting questions, I often submit a few at the same time (because when I have an idea for a question, it very often grows big enough to be split into multiple questions). Usually, they are then published a week apart. Why the site managers decided to put these two back to back, I don't know.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1452976
Posted Wednesday, May 15, 2013 2:41 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 671, Visits: 1,541
Hugo Kornelis (5/15/2013)
Raghavendra Mudugal (5/15/2013)
That is cool... how did you set two questions back to back? (if it was just out of luck then it is a strange luck....)

People who submit questions have no control over when they will be published. When submitting questions, I often submit a few at the same time (because when I have an idea for a question, it very often grows big enough to be split into multiple questions). Usually, they are then published a week apart. Why the site managers decided to put these two back to back, I don't know.


any reason manager had... it worked out very well, and seeing these two in sequence is actually really great.

Thank you, Hugo.


ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)
Post #1452978
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse