Click here to Skip to main content
15,914,481 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
AnswerRe: new graphics card NVIDIA GTX750OC is not working... advice? Pin
Member 376360819-Jan-15 7:16
Member 376360819-Jan-15 7:16 
GeneralRe: new graphics card NVIDIA GTX750OC is not working... advice? Pin
Joan M19-Jan-15 20:46
professionalJoan M19-Jan-15 20:46 
AnswerRe: new graphics card NVIDIA GTX750OC is not working... advice? Pin
XH558v19-Jan-15 8:24
XH558v19-Jan-15 8:24 
GeneralRe: new graphics card NVIDIA GTX750OC is not working... advice? Pin
MOlin12319-Jan-15 9:42
MOlin12319-Jan-15 9:42 
GeneralRe: new graphics card NVIDIA GTX750OC is not working... advice? Pin
Joan M19-Jan-15 20:49
professionalJoan M19-Jan-15 20:49 
GeneralRe: new graphics card NVIDIA GTX750OC is not working... advice? Pin
XH558v19-Jan-15 20:56
XH558v19-Jan-15 20:56 
GeneralRe: new graphics card NVIDIA GTX750OC is not working... advice? Pin
Joan M19-Jan-15 21:24
professionalJoan M19-Jan-15 21:24 
GeneralDoh! I'm an idiot... Pin
OriginalGriff18-Jan-15 1:08
mveOriginalGriff18-Jan-15 1:08 
Wrote a new SQL Scalar function in SSMS toady, and just couldn't get it to do anything:
SQL
SELECT MyFunctionName(MyColumn) FROM MyTable
Just underlined it in red and gave me
'MyFunctionName' is not a recognized built-in function name.
And wouldn't run my query.
SQL
SELECT dbo.MyFunctionName(MyColumn) FROM MyTable
Underlined it in red, said
Cannot find either column "dbo" ot the user-defined function or aggregate "dbo.MyFunctionName", or the name is ambiguous.
But would run it, and returned null for all rows.

Spent an hour trawling google and playing with user execute permissions. Starting to pull my hair out.

Then I looked closely at the function and realised I didn't use the input parameter at all, and the function was rightly returning null... D'Oh! | :doh:

I still hate SSMS and functions...but it works now... Blush | :O
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

GeneralRe: Doh! I'm an idiot... Pin
Richard MacCutchan18-Jan-15 1:15
mveRichard MacCutchan18-Jan-15 1:15 
GeneralRe: Doh! I'm an idiot... Pin
OriginalGriff18-Jan-15 1:38
mveOriginalGriff18-Jan-15 1:38 
GeneralRe: Doh! I'm an idiot... Pin
Kornfeld Eliyahu Peter18-Jan-15 1:17
professionalKornfeld Eliyahu Peter18-Jan-15 1:17 
GeneralRe: Doh! I'm an idiot... Pin
OriginalGriff18-Jan-15 1:38
mveOriginalGriff18-Jan-15 1:38 
GeneralRe: Doh! I'm an idiot... Pin
Kornfeld Eliyahu Peter18-Jan-15 1:43
professionalKornfeld Eliyahu Peter18-Jan-15 1:43 
GeneralRe: Doh! I'm an idiot... Pin
PIEBALDconsult18-Jan-15 5:43
mvePIEBALDconsult18-Jan-15 5:43 
GeneralRe: Doh! I'm an idiot... Pin
Mycroft Holmes18-Jan-15 11:55
professionalMycroft Holmes18-Jan-15 11:55 
GeneralRe: Doh! I'm an idiot... Pin
DJ van Wyk18-Jan-15 20:34
professionalDJ van Wyk18-Jan-15 20:34 
GeneralRe: Doh! I'm an idiot... Pin
#realJSOP18-Jan-15 1:50
professional#realJSOP18-Jan-15 1:50 
GeneralRe: Doh! I'm an idiot... Pin
Kornfeld Eliyahu Peter18-Jan-15 2:00
professionalKornfeld Eliyahu Peter18-Jan-15 2:00 
GeneralRe: Doh! I'm an idiot... Pin
Brady Kelly18-Jan-15 5:24
Brady Kelly18-Jan-15 5:24 
GeneralRe: Doh! I'm an idiot... Pin
User 1106097918-Jan-15 3:12
User 1106097918-Jan-15 3:12 
GeneralRe: Doh! I'm an idiot... Pin
Sander Rossel18-Jan-15 9:59
professionalSander Rossel18-Jan-15 9:59 
GeneralRe: Doh! I'm an idiot... Pin
pkfox18-Jan-15 20:06
professionalpkfox18-Jan-15 20:06 
GeneralRe: Doh! I'm an idiot... Pin
Sander Rossel20-Jan-15 0:01
professionalSander Rossel20-Jan-15 0:01 
GeneralRe: Doh! I'm an idiot... Pin
Slacker00719-Jan-15 5:38
professionalSlacker00719-Jan-15 5:38 
QuestionArticle Contest... Pin
Kornfeld Eliyahu Peter17-Jan-15 21:48
professionalKornfeld Eliyahu Peter17-Jan-15 21:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.