Two SQL updates into One?

Can I make this query into a single one? Maybe like a If Else statement? In a Stored Procedure I could do it, but i'm not sure how with 'Selects and updates'...?

Code:

---

Update WhseOpenOrders
Set LateIndicator = 'L'
FROM WhseOpenOrders
WHERE PromiseDate < CONVERT( varchar(20), getdate(), 101)

Update WhseOpenOrders
Set LateIndicator = '*'
FROM WhseOpenOrders
WHERE PromiseDate BETWEEN CONVERT( varchar(20), getdate(), 101) AND CONVERT( varchar(20), getdate() + 14, 101)

---

you don't need to convert a datetime column to a string in order to compare it to another datetime column

assuming, of course, that your PromiseDate is actually a datetime column and not a string itself

Code:

---

update WhseOpenOrders
  set LateIndicator
    = case when PromiseDate < getdate()
            then 'L'
            else '*' end
  from WhseOpenOrders
 where PromiseDate < dateadd(d,14,getdate())

---

I'm using SQL sever Enterprise, and it always converts my datetime columns to a string. I change it when I use the Query for final production.

I was thinking of using a case statement, and that looks like you beat me too it. Just a few changes, and she works like a charm. Thanks again, this site rocks. :aparty:

sql server always converts datetime strings to integers

internally, datetime values are always stored as a pair of integers

when you display a datetime value, sql server does not show you its internal integer values, instead, it converts the datetime value to a string

i know it's confusing :)