Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Monday Madness

Author  Topic 

elwoos
Master Smack Fu Yak Hacker

2052 Posts

Posted - 2010-04-19 : 10:04:15
Here is my question for the day.

You know your a SQL geek when....?



steve

-----------

Deja Moo - The feeling you've heard the same bull before.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-04-19 : 10:12:17
You know your a SQL geek when....?

I don't know what you're trying to do but that's not correct!
You can use WHEN inside CASE.
Example:
CASE WHEN col1=1 THEN 'one' ELSE 'Dont know' END




No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2010-04-19 : 10:31:28
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'your'


Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2010-04-19 : 11:07:14
You ask her for INSERT permissions, but you get DENY ALL.






CODO ERGO SUM
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2010-04-19 : 11:48:49
You forget your Keys and can't find you house?


Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-04-19 : 11:52:09
quote:
Originally posted by Transact Charlie

You forget your Keys and can't find you house?


Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION



To ask in all innocence


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-04-19 : 12:04:12
Go to Top of Page

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2010-04-19 : 14:10:33
You log in on Saturday to see if there's a new post in the Yak Corral.

Everyday I learn something that somebody else already knew
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-04-20 : 07:02:43
1. You write query to calculate your monthly expenses.
2. You moan over lack of execution plan to calculate shortest path to your friend's house


Harsh Athalye
http://www.letsgeek.net/
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-04-20 : 07:58:46
You can't find anything more interesting to do than debug a 10,000 line sproc..
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2010-04-20 : 08:12:28
quote:
Originally posted by RickD

You can't find anything more interesting to do than debug a 10,000 line sproc..



That reminds me one more,

Best thing to kill time on holiday is to solve SQL puzzles (like the one Joe celko put forward every once a while)

Harsh Athalye
http://www.letsgeek.net/
Go to Top of Page
   

- Advertisement -