| 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. |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-04-19 : 10:31:28
|
| Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'your'Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
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 |
|
|
|
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 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
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 1736The 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. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-19 : 12:04:12
|
 |
|
|
|
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 |
|
|
|
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 houseHarsh Athalyehttp://www.letsgeek.net/ |
|
|
|
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.. |
|
|
|
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 Athalyehttp://www.letsgeek.net/ |
|
|
|
|
Monday Madness