bitbucket-25253 (11/9/2010)

---

Is this what you are seeking:

SELECT DATEADD(mm,-3,DATEADD(day, 1, GETDATE()))As '3 months ago',GETDATE() AS 'Today',

DATEADD(day, 1, GETDATE()) AS 'Today plus 1 day'

Results:

3 months ago ...

Are you using SQL 2008 ?If not then it will error out.

select convert(date,dateadd(mm,-3,GETDATE()+1))

That wont be much of a problem.any of the above solutions posted will work.

select top 1 status from yourtable where status='Failure'

IF @@rowcount>=1

select 'Failed'

else

select 'Success'

declare @t table(id int identity,dt date NULL,stepid int)

insert @t

select '2008-03-03',1 union all

select '2008-03-04',1 union all

select '2008-03-14',5 union all

select null,5 union all

select '2008-03-20',6...

Is the last full backup and log file available.If yes then you need to

1)Take a Tail log backup.

2)Create a new database and then restore the full backup.

3)Restore the Tail log...