Nandy (11/18/2008)

---

Hi All,

I have used the cursor in the stored procedure to delete the data from the table. I'm deleting the data from table where I used the same table...

Once you "recover" the database doing a restore with recovery you can no longer apply differential or transaction log backups to the database. You have to redo the restore...

With mput, I think you would have to cd down a level first.

SQL Server Equivalent: select dateadd(mm, datediff(mm, 0, @TestDate), -1)

I have to agree as well. Most of us do want to help others who are having difficulties. Look at how many of the regular contributors now have...

Actually, it is always adding a leading...

Here is some test code for you to check out:

declare @TestDate datetime,

@Interval smallint;

set @Interval = 0;

set @TestDate = getdate();

select dateadd(mm, datediff(mm, 0,...

Quick question, how is the second value used? Does it always go backwards or can it go forward.

Example:

declare @TestDate datetime;

set @TestDate = getdate(); -- 2008-11-18 11:15:35.333

select SOM(@TestDate, 0); --...

declare @str char(2);

set @str = '1';

select right('0' +...

Also, besides providing the sample data, be sure to provide the expected results when the query is run. We need something to check against.

I have tried to help with particular problem as well. It is a form of running-total problem and prehaps what would help is more than just a couple of...

delete from

dbo.MainTable

from

dbo.MainTable mt

inner join dbo.DeleteTable dt -- table of primary keys to be deleted

...

You only need the REPLACE option on the RESTORE if the .mdf/.ldf files already exist on the server you are restoring the database.

Going in a different direction, away from your queries, to indexes. How are you indexing your tables? Will you have a primary key on each table? Will...

I would agree when the Developer Edition of SQL Server was more expensive. With the Developer Edition only costing $50.oo, and it can be used in the development, test,...