Hmmm... this sure looks familliar[/url]...

Read up on ISNULL() in books online, Ken pointed you in the right direction. You might try something like this:

SELECT ISNULL(test06, 0) - ISNULL(text08, 0) AS DIFF FROM mytable

I suspect something else might be wrong as Sergiy's code should have run without issue... However you might try turning on the execution plan when you run the query...

Loner, to me it really depends. You have to choose the backup/restore strategy which works best with your maintenance window, DR plan, db usage, etc... I manage roughly...

I think I just threw up in my mouth a little...

I have that shirt, you can buy it at thinkgeek.com. 😉

GilaMonster (12/13/2007)

---

Virtual cookie to the first person who spots the problem with this.

For info, @somestring was declared as Varchar(8000) and was built up from several fields of one row...

Oh this is great... I've seen so many good examples. The lack of brackets when you're throwing around OR statements sets my teeth on edge. The ISNULL()...

In the case that it's used by multiple applications we usually generalize the object portion a bit. It's really evaluated on an issue by issue basis.

The prefix p_ is...

I don't pre or postfix tables as a rule, however I do like to label views for the same reasons Steve said above. As for procedures I usually try...

I frequently run into triggers others have created that don't realize that triggers need to account for set-based approaches, not just row-based approaches. When you see something like "SELECT...

Oh totally, if I was just learning today I can guarantee you that I'd probably use EXCEPT. But I've been doing left anti-semi joins (and it rolls off the...

I always try to think of "elegant" as being synonymous with "speedy" ;). Though when I first read about the new except/intersect syntax, I was definitely interested to find...

EXCEPT is a newer syntax in SS2K5. The traditional method for this (and much better performing than NOT IN) is what's called a left anti-semi join like this:

SELECTa.colA

FROMTableA a

LEFT...

Linked servers, yes. Log shipping, not so much (requires the machines to be on the same network).

Moreover, I'd highly recommend that if you're going to go this route you...