You should read about the restore command in SQL Server 2005 Books Online.

http://msdn.microsoft.com/en-us/library/ms178615(SQL.90).aspx

It would be much simpler if you just stored that actual start and end times as datetime datatypes as the actual start datetime and end datetime. Then is is...

Another variation from Lynn's version:

;with

a1 as (

select 1 as N union all select 1 union all select 1 union all select 1 union all

select 1 union all select 1 union...

When you do a backup with append, you are writing a new backup set to the end of the same file. When you restored you probably did not specify...

.

I think this illustrates the problem with the OP picking the best solution:

http://www.sqlservercentral.com/Forums/Topic673876-1291-1.aspx

The best solution is debateable in this situation, but I doubt the OP was really able to judge...

I just assumed you would be...

The account that xp_cmdshell is running under will have to have permission to delete the file.

xp_cmdshell runs under the SQL Server service account if it is executed by a sysadmin...

select

Random_String =

substring(x,(abs(checksum(newid()))%36)+1,1)+

substring(x,(abs(checksum(newid()))%36)+1,1)+

substring(x,(abs(checksum(newid()))%36)+1,1)+

substring(x,(abs(checksum(newid()))%36)+1,1)+

/* and so on for as many characters as needed */

substring(x,(abs(checksum(newid()))%36)+1,1)

from

(select x='0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ') a

Results: ...

Bruce W Cassidy (3/11/2009)

---

[font="Verdana"]Can I put my hand in the air and recommend a Calendar table? It's a specialised version of a Tally/Numbers table, and you can do all...

The last one (For rounding off to the nearest minute) does not work for the entire range of datetime. I have posted a more general method below.

print 'Limited start...

Luke L (3/11/2009)

---

Michael any reason why you like 17530101 as opposed to 0? I'd never really thought to use the 17530101 like you are doing, but I picked up...

The code below is the standard way to get a date without the time in SQL Server.

Extensive testing (by me and many others) has shown that casting a date...

select

*

from

MyTable

where

-- Date greater than or equal to Monday of last week

MyDate >= dateadd(dd,((datediff(dd,'17530101',getdate())/7)*7)-7,'17530101')

and

-- Date before Saturday of last week

Mydate < dateadd(dd,((datediff(dd,'17530101',getdate())/7)*7)-2,'17530101')

Shorter.

select [Month] = right(100+month(getdate()),2)

Results:

Month

-----

03