Just an observation, but you really should evaluate if the Primary Key (Reservation ID) is actually the best choice for your clustered index on the table. You should review...

And doing this can result in your query not taking advantage of indexing on a table. If your tables are small, you may not...

The code samples I provided will actually go either way. They go backward with positive values, and forward with negative values. A little counter-intuitive, but that was because...

I don't think the comments here are meant to be elitist, just frustration. There have been threads on some forums where more information has been requested, the OP has...

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...