Now while I appreciate that it may be frustrating for a guru to see what he or she considers to be basic errors in a question, it is equally frustrating for a newbie to the language to be flamed and - I'm sorry to say this - patronised - for having the temerity to ask such a question.
In many years of using the web this is the first time I've felt the need to defend myself in this way Don't let Joe Celko's comments upset you. Some people are bound and determined to always speak down to everyone — they like to make themselves feel important. That is the only way they can inflate their ego - no one else will do it for them. If he went away, we wouldn't even miss him. You must be logged in to reply to this topic. Login to reply.
July 3, at am I'm trying to work a stored procedure with a NULL value in a case statement and can't get the syntax correct. The statement returns the maximum hourly rate for each job title in the HumanResources. Employee table. The HAVING clause restricts the titles to those that are held by men with a maximum pay rate greater than 40 dollars or women with a maximum pay rate greater than 42 dollars.
When a value does not exist, the text "Not for sale' is displayed. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Fill in your details below or click an icon to log in:. Email required Address never made public. Name required. He has worked in a number of different settings and is currently the technical lead at one of the largest software companies in the UK.
Adrian Buckman After working in the motor trade for over 11 years Adrian decided to give it all up to persue a dream of working in I. Follow me on Twitter My Tweets. David Fowler Which Processes are waiting on a Spinlock? Follow Following. Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search.
I only have access to right now, but I'd hope that this syntax would still work in seems like something that would be part of the original definition of CASE. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
Learn more.
0コメント