Updating Column Values using DateLine : <p>Here is my sql table</p>

<pre><code>create table Poll_Question_Table (
PollQuestionId int primary key,
PollQuestionTex varchar(max),
PollStatus int ,
PollStartDate date,
PollEndDate date
)
</code></pre>

<p>i Want to change th status value from 1 to 0 if the current date pass the end date (dateline ) using function or trigger ..... tnx for ur help</p>
