|
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 .
|
|
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 .
|
|
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 .
|
Ask your Facebook Friends
|
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):
Italy.
Is Jeff Yeah, I generally like to eat my "meal" before I poke it! lol LMAO that is t funny.
|
|
Can you explain this Quote: : "If you don’t know what you want, you end up with a lot you don’t."?
Started by Nafada on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at yahoo):
If you don't know what you want, you will try to get things that you don't want, and then your screwed :) You keep on getting things because you think that one of them may just be the very thing you've been looking for...when in fact none of them are ... .
|
|
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.
|
|
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):
*/ } class Dog:
abstract class Pet< T....
Trick:
abstract class Pet<T extends Pet> { private String name; public T setName(String name) { this.name = name; return (T) this; } } class Cat extends Pet<Cat> { /* ...
|
|
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... .
|
