Thanks Mate, is there any other ways to do it in 2005, or in 2008 🙂

Thanks G-Squared you mean Case when date1 > date2 then Date1

...

Ops Posted on wrong forum, apologies for this 🙂

Hi Nikel

This seems fine, the basic is that if you enable the option not null to be true,...

Why cant you combine all this 3 jobs into one job with 3 steps, if step 1 fails exit the job, else continue the job.

if you don't want to go...

I would suggest the same as Luke, Create a table and then insert columns for 7 days and then update the columns for each day, this gives you a growth...

its .dat

can you post the insert statement, there is something wrong on the syntax according to the error 🙂

How did you install it, was this a VM machine 🙂

Check the table structure, and see if the column allows null values. post us the structure of the table you are trying to insert 😀

Hi Niyala

This sounds strange, i will check my installation and let you know 🙂

There is not one particular answer for this, there are many ways you can do it, and its not only the SQL that you have to check, you have to...

so this is a problem with SP which suddenly behaves badly:), can you post the SP, we can check on the code 🙂

Just a simple backup from the machine will do, specify the remote location as backup location. 🙂

Use SQL command on the first step(before inserting) of SSIS package, then insert into the table 🙂