Insert data via a case statement

[dhulbert]

I'm trying to insert a line of data into a table dependant on the result of a case statement.

So look at the table 'Data_Table' if there is a row where the date = 'Run Date' then do nothing
Else insert a row of data with 'Run Date', 'Header' and 'Colour'

Any help would be appreciated.


I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[simian336]

select Run Date, Header, Colour
into Newtable
from datatable
where date <> @Run_Date


Simi