Application Variable

[geo039]

I need to set my asp.net application variable to today's date so it can check when a last database refresh was done. I have data coming from one view into a table used by my application so I need to insert or update based on if data exists or not.

Basically I just need the update to run once a day so the variable just needs to check to see if it was run each day. So every time the application loads, if the refresh was run today don't run again if so run??

I'm pretty new to this so any help would be appreciated.

[radcaesar]

Why did u prefer to use application variable for this requirement. If a update has already done on that date, use a flag and date column in the DB itself for your check. If the flag is set then show a message to the user by check that date with today's date.

[geo039]

I'm new to all this just learning. I talked to a few other developers here and both using a column and flag and application variable came up. When my boss wrote down what to do he said to start with setting the application variable to date(today). Then write the sp. Right now i'm sort of confused about the best way to accomplish this.

I don't know how to use a flag. The inherited sp currently looks like this. I say inherited because I took an application another dept uses to modify it to our needs. They are using a view to insert new employees, we will be checking whether an employee personnel # exists, if so then update if not then insert. I am trying to figure out their logic, apply our logic and learn what i'm doing at the same time =)

-- insert newly found employees
INSERT INTO dbo.employee
    (NTusername, full_name, cost_center, location, job_title, supervisor )
SELECT empUserName, full_name, cdcstcntr, cdlocation, job_title, supervisor_name
FROM dbo.v_wqtimenewemployees
 
-- update fields in the employee table
UPDATE  dbo.employee 
SET full_name = t.full_name, cost_center = t.cdcstcntr,
    cost_center_desc=t.desccstcntr, job_title=t.job_title,
    supervisor=t.supervisor_name
FROM dbo.v_WQTimeEmployees as t RIGHT OUTER JOIN 
    dbo.employee ON t.empUserName = dbo.employee.NTUsername
WHERE t.empUserName = dbo.employee.NTUsername 
    AND (dbo.employee.manual IS NULL or dbo.employee.manual=0) 
 
-- update location if it is set for automatic updates
UPDATE  dbo.employee 
SET location=t.cdlocation
FROM dbo.v_WQTimeEmployees as t RIGHT OUTER JOIN 
    dbo.employee ON t.empUserName = dbo.employee.NTUsername
WHERE t.empUserName = dbo.employee.NTUsername 
    AND (dbo.employee.manual_loc IS NULL or dbo.employee.manual_loc=0)
 
-- archive those no longer in wqtime
UPDATE  dbo.employee
SET inactive = '1'
FROM dbo.v_WQTimeEmployees RIGHT OUTER JOIN 
    dbo.employee ON dbo.v_WQTimeEmployees.empUserName 
    = dbo.employee.NTUsername
WHERE (dbo.v_WQTimeEmployees.empUserName IS NULL) 
    AND (dbo.employee.manual IS NULL or dbo.employee.manual=0) 
        AND (dbo.employee.inactive is null or dbo.employee.inactive=0)