|
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 .
|
|
Posted 24 July 2011 - 11:06 AM
by Jason Stotts
One oft he very few things that I think Obama has done right since he’s been in office is to work to repeal the military’s “Don’t Ask, Don’t Tell” (DADT) policy of discriminating against non-heterosexuals...
Started by Jason Stotts on
, 12 posts
by 7 people.
Answer Snippets (Read the full thread at objectivismonline):
Posted....
It's just a shame now that this had to happen during a time when our military seems to be fighting all of the wrong battles, for all of the wrong reasons .
Posted 26 July 2011 - 08:14 PM
A while ago, I would have been excited to hear about this .
|
|
How to utilize programmers effectively when they don’t have Enough Work?
Started by LittleBoy on
, 48 posts
by 47 people.
Answer Snippets (Read the full thread at stackoverflow):
Then....
You could have them look to first get any legacy code covered by a decent set of unit tests .
Get them to pay back some Technical Debt.
Just be sure not to break anything.
Testing and refactoring ? There is always room for improvement in the code .
|
Ask your Facebook Friends
|
I don’t understand or see the need for regular expressions.
Can some explain then in simple terms and provide some basic examples where they could be useful, or even critical.
Started by Jlouro on
, 13 posts
by 13 people.
Answer Snippets (Read the full thread at stackoverflow):
How regular expressions....
You pass it a string and it will return true or false if it is a match or not .
What regular expressions are used for:
Regular expressions is a language in itself that allows you to perform complex validation of string inputs .
|
|
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.
|
|
I have a number of XP machines that have a SQL 2005 Instance running on them, and they are set to start automaticly in Service Control Manager.
On 1 or 2 of these machines when you reboot, the SQL Instance doesn't start. Nothing makes it into the event...
Started by Paul Farry on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Is there any information in the SQL Server error log rather than the Windows event log?
Does it happen every time?
Sure it's the SQL service that's set to auto-start and not SQL Agent, for instance? (Apologies if that's too simple a question for you -... .
|
|
Hi, I am using Qt´s QGraphicsView- and QGraphicsItem-subclasses. is there a way to not scale the graphical representation of the item in the view when the view rectangle is changed, e.g. when zooming in. The default behaviour is that my items scale in...
Started by yoursort on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
How about this:
#include <QtGui/QApplication> #include <QtGui/QGraphicsScene> #include <QtGui/QGraphicsView> #include <QtGui/QGraphicsRectItem> int main(int argc, char* argv[]) { QApplication app(argc, argv); QGraphicsScene scene... .
|
|
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... .
|
|
This question has been asked in a C++ context but I'm curious about Java. The concerns about virtual methods don't apply (I think), but if you have this situation:
abstract class Pet { private String name; public Pet setName(String name) { this.name =...
Started by Jason S on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You could work around it by using covariant return types (thanks to McDowell for the correct name):
@Override public Cat setName(String name) { return (Cat) super.setName(name); }
(Covariant return types are only in Java 5 and above, if... .
No, not really.
|
