Yes.

WHERE NOT (varA = 1 AND varB = 'Green') is exactly what I was looking for.

I knew it was something really simple. It was driving me nuts that...

Oh, yeah. I've used case statements in computed columns before. That's actually part of the reason I was hoping there was a way to do it in default. But you're...

prvmine (6/24/2011)

---

this is one suggestion

with Windows as (

select part,

visit,

dateadd(mm,-6,aptdue) as bigwinopen,

...

create table #test

(Part varchar(10),

...

Nevermind that last post. I got what I need.

Thanks for your help!

I've been trying to play with that, but I am unsuccessful.

I want to add this, right?

(DATEDIFF(dd,ddatetime,getdate()) > 0)

Where do I add that? We're not talking about the outside select statement,...

Jayanth_Kurup:

It looks like common table expressions may work for me.

I've been playing around with it, but could use a little more help if you don't mind.

So, I'm basing this off...

Nothing to be sorry for. 🙂

So persisted is better because it doesn't have to be recalculated every time the record is accessed, which saves time/processing power. That makes sense. I...

Thank you Lowell!

Thanks for replying again Craig.

I do know what persisted and non-persisted mean.

I don't understand what the advantage to one over the other is.

Why do you say I'd want...

Thank you both for your help.

So, this is what I ended up doing.

Created this function:

FUNCTION [dbo].[fnGDSTotal](@Satis int, @DropAct int, @EmpLife int)

RETURNS int

as

begin

declare @NumVars int

set @NumVars = 0

if...