SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 The Yak Corral
 Monday Madness
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2050 Posts

Posted - 04/19/2010 :  10:04:15  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 04/19/2010 :  10:12:17  Show Profile  Visit webfred's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 04/19/2010 :  10:31:28  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
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)

USA
7020 Posts

Posted - 04/19/2010 :  11:07:14  Show Profile  Reply with Quote
You ask her for INSERT permissions, but you get DENY ALL.






CODO ERGO SUM
Go to Top of Page

Transact Charlie
Flowing Fount of Yak Knowledge

United Kingdom
3451 Posts

Posted - 04/19/2010 :  11:48:49  Show Profile  Visit Transact Charlie's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

Germany
8765 Posts

Posted - 04/19/2010 :  11:52:09  Show Profile  Visit webfred's Homepage  Reply with Quote
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

United Kingdom
22403 Posts

Posted - 04/19/2010 :  12:04:12  Show Profile  Reply with Quote
Go to Top of Page

jimf
Flowing Fount of Yak Knowledge

USA
2869 Posts

Posted - 04/19/2010 :  14:10:33  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
5528 Posts

Posted - 04/20/2010 :  07:02:43  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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

United Kingdom
3608 Posts

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

harsh_athalye
Flowing Fount of Yak Knowledge

India
5528 Posts

Posted - 04/20/2010 :  08:12:28  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000