quote:

---

Originally posted by Mahavirjadhav

Hi,
I am new to Sql server. I am not able to present my question in perticular words. But I am trying to explain briefly.

I want to update the Commision table at the end of day, as comision rates may be changes daily or within given time span of dates. So the table Commision should be automaticaly should be updated.
Defination of Commision table is:

comm float,
from_date Datetime,
Todate Datetime,
status nvarchar(10)

status are : 1. Archived ,2. Active, 3. Planned.

Please help me.

Mahavir

---

quote:

---

Originally posted by webfred

Sorry but your question is still not clear to me.

Please read this:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

---

No, you're never too old to Yak'n'Roll if you're too young to die.

---

update Commision
set status = CASE
              WHEN dateadd(d,datediff(d,0,getdate()),0) > to_date then 'Archive'
              WHEN dateadd(d,datediff(d,0,getdate()),0) < from_date then 'Planned'
              ELSE 'Active'
             END

quote:

---

Originally posted by webfred

Test this please:

update Commision
set status = CASE
              WHEN dateadd(d,datediff(d,0,getdate()),0) > to_date then 'Archive'
              WHEN dateadd(d,datediff(d,0,getdate()),0) < from_date then 'Planned'
              ELSE 'Active'
             END

Maybe there is a chance for a WHERE clause to exclude very old records from updates?

---

No, you're never too old to Yak'n'Roll if you're too young to die.

---