|
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 .
|
|
But there’s starving kids in AMERICA. Why don’t we start at home before we go off to another country trying to feed folks there? The Will of Fire.
Started by Shodaime on
, 26 posts
by 4 people.
Answer Snippets (Read the full thread at the8thlegion):
The world and we don't give uh s**t DRE said: ↑ We feel sorry for Africa because Africa keeps getting.
|
|
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 .
|
|
Hi guys,
Can somebody tell me why my wideband don`t pass W65?
When I reach W65 the wideband remain on W65 and the calibration cannot be completed.
No AFR readings etc...
Please advice,
Danieln
Started by danielnk on
, 6 posts
by 2 people.
Answer Snippets (Read the full thread at innovatemotorsports):
W35 or W65 the majority of the time and it will not calibrate,
The sensor itself gets hot still but it will not calibrate....... .
W35 or W65 and it will not calibrate
the sensor gets hot but it will not calibrate Sensor getting stuck in heater warm-up... .
|
|
Obama thinks the American people don’t understand basic economics, we don"t? Jonathon M. Seidl writing for the blaze.com
President Obama just announced his plan to “accommodate” religious organizations being forced to provide free contraception. And guess...
Started by Hang Ten on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at yahoo):
Rule of law means that one man doesn’t get to set policy with the stroke of the pen.
|
|
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> { /* ...
|
