Hi thanks it works I did not know it is this simple I replaced -q with -Q the command prompt closes when the backup job is finished.

Do you think changing the owner of the job works.What confuses me is that when the same backup job is started manually then the job succeeds but fails for schedule...

1> I had tried this earlier and it does'nt work.I tried even now but it overwrites the old backup.

2> The owner of the job is sa

The agent runs in...

I did for Oneday_percentchange column and the results are correct.

The logic for that is given below.

DECLARE @OneDay_percentChange DECIMAL(10,2)

DECLARE @Inventory_code INT

UPDATE dbo.Temp

SET @OneDay_percentChange = OneDay_percentChange...

Now continuing with the previous update. I have added a new column to the table with the column name Onweek_PercentageChange.

Alter table temp add Onweek_percentageChange decimal(10,2).

This column stores the value(percentage) change...

The Detail_ID is in sorted order by Inventory_Code and Detail_Date.

Why is that when I pass a parameter(Inventory_Code) values are updated correctly? If it was not sorted by Inventory_Code and...

Thanks for your advice I was able do it, please see the attachment and help me in optimizing the procedure.

The clustered index on the table is for Detail_id. I have created a procedure for this but it is very slow, for a single inventory update it takes about 8...

As Jeff Moden replied I can even use temp tables if it is not possible with a single query.But it would help if we were to do it in a...

Thanks this is what I wanted.

The output I get for this is

id sum1 Mysum

1100

22010

33030

44060

550100

660150

Which is not my requirement?

Even if I execute this query I cannot exclude the 19"-R character. The " character is main problem.For rest all my query works fine.Is there any way I can exclude...

I did it in a different way. First I generated the script for sql2000 then in

Sql server 2000 I created a database executed the generated script.

From 2000 I once again...

I have used a lot of queries in where I am searching for the existance of the certain data.Suppose I have table Users and I am searching for the existance...

Actully my backup plan is to retain for two days and delete any file older than that.I will change to 47 hours and see if retains for 2 days and...