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 «««123

T-SQL Logic Expand / Collapse
Author
Message
Posted Friday, June 25, 2010 1:53 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 6:52 AM
Points: 4,483, Visits: 631
Huh... I thought I chose "1" but it says I answered the question wrong... what's up with that?
Post #943323
Posted Monday, June 28, 2010 5:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:22 AM
Points: 112, Visits: 237
Interesting one. The explanation given isn't quite correct:

2. len(case name when 'master' then 'other' else 'name' end) > 4 --only the length of 'master' > 4, all other db's are changed to 'name', which length =4.

its not the len of the word 'master' being compaired, but the lenth of the word 'other'.




Wayne

Did you get access denied? Great the security works.

Post #943815
Posted Wednesday, June 30, 2010 2:07 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 07, 2014 8:17 AM
Points: 323, Visits: 1,446
Take out "and database_id < 2"; you still get the same result and looks like a harder question.

Ken
Post #945772
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse