Two SQL updates into One?

[slboytoy]

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'...?

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)

[r937]

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

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

[slboytoy]

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.

[r937]

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