|
As the title says, I just want an output if the if is matched, if it’s not matched then I don’t want any output.
I currently have this, but it gives an error obviously
...rFormat=IF(ISNULL(rFormat), VALUES(rFormat),UNCHANGED)…
I looked around http://dev...
Started by Mint on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Try this:
rFiles = COALESCE(existingColumnValue,....
Just use WHERE rFormat IS NULL instead of IF.
You could simply do
IF(ISNULL(rFormat), VALUES(rFormat), rFormat)
I'm not sure what you are trying to achieve by calling VALUES() at this point, however .
|
|
Using C#, asp.net 3.5, SqlServer 2005,
Trying to incorporate some inversion of control together with 3-tier architecture into my current assignment.
Don’t know enough to know if this is a great idea or an incredibly dumb one:
I have created a User Interface...
Started by Lill Lansey on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
If you are doing something that reduces complexity in you and your team... .
Software's Primary Technical Imperative is to reduce complexity.
If it makes sense to you (and your team) and it works as intended, it's a fine design pattern, no matter what it is .
|
|
This is not specific to any language, it´s just about best practices. I am using JPA/Hibernate (but it could be any other ORM solution) and I would like to know how do you guys deal with this situation: Let´s supose that you have a query returning something...
Started by bosnic on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
The query looks like this
PROJECTID: 1 NAME: New Web Site ALLTASK: 10 OPENTASK: 7 CLOSEDTASK: 3
I don´t have any domain class that could represent this information and I don´t want to create specific.
|
Ask your Facebook Friends
|
Ok, maybe they're system shortcuts. I've googled (just a bit) and couldn't find an answer. Maybe there isn't any :) Still..
I love keyboard and I use quite a few in TextMate but just realise I still use the mouse for 2 of the most common actions :
How...
Started by pax on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at superuser):
How do I press search and replace after the S/R dialog box is up? - if you press enter it just takes you to the next occurrence of the search string
The buttons in the box map to the same options under Edit > Find, so you can use those key shortcuts... .
|
|
I am setting up a simple test page in Python. I only have two files: .htaccess and index.py. (Permissions for both set to 755) I get a 403 Forbidden error when trying to view the page - how can I fix this?
.htaccess:
RewriteEngine On AddHandler application...
Answer Snippets (Read the full thread at serverfault):
Also - does the .htaccess work with any other scripts, like perl or bash?
Generally there's a default handler... .
Did you make sure the directory is viewable? I've had permissions issues with directories interfere with the files they contained in the past .
|
|
I have a remote PC with SQL Server 2008 setup and allowing remote connections.
I am an Admin user on the PC and have remotely connected to the SQL Server and I am trying to restore a database from backup but getting permissions denied for anything I try...
Started by Jan Zelezny on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
When you're logged in as the administrator....
To give yourself these rights, you will need to log in as an administrator, or the SA account (if mixed mode is enabled) .
Sounds like the account you are logging in as does not have the rights to perform these options .
|
|
My check engine don t turn off the code is 212 the Oxygen sensor I gat a new one Bosch 13034 i don t have catalyst I put a nut whit a separation to can rwach but nothing helpp
Started by yxr640 on
, 18 posts
by 4 people.
Answer Snippets (Read the full thread at turbobricks):
Posted via Mobile Device....
|
|
Don’t like Google? Don’t use it! An unlikely ally speaks up on antitrust allegations
As cries of a Google monopoly grow louder, legal scholar Robert Bork has piped in with an easy answer to Google critics: Stop using Google. Is it really that simple, ...
Started by Slapshot007 on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at dealzoid):
|
|
Haven´t your mom told you anything?Don´t play with your food!
Started by weiffi on
, 13 posts
by 13 people.
Answer Snippets (Read the full thread at jokeroo):
He's crossing the lines That is probably the only way he can get any naah, he's just... .
Thanks to my favorite superhero.
He's marinating.
Lions juz wanna have a lil fun is all lol he 's tenderizing Originally Posted by hendrix he 's tenderizing lmao. .
|
|
It's no surprise to anyone in the aviation industry to hear that the pilot population is shrinking. Sure, it's sad – but it's not a surprise. We all know it's shrinking. If only there were something we could do to reverse that trend. Good news — there...
Started by GA News on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at aircraftpilots):
|
