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: Yesterday @ 5:58 PM
Points: 5,965, Visits: 8,216
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 6, 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: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
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: Friday, July 25, 2014 12:34 AM
Points: 1,888, Visits: 2,326
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: Friday, July 25, 2014 12:34 AM
Points: 1,888, Visits: 2,326
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: Thursday, July 10, 2014 3:22 AM
Points: 642, Visits: 518
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: Monday, July 21, 2014 3:43 AM
Points: 1,938, Visits: 1,162
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:56 AM
Points: 902, Visits: 2,034
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
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1452971
Posted Wednesday, May 15, 2013 2:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:58 PM
Points: 5,965, Visits: 8,216
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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:56 AM
Points: 902, Visits: 2,034
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
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1452978
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse