I know you said you had a solution, but I think you should also give the following a try:

CREATE TABLE...

Michael

If you read post numbers 666817, 666826, and 667164 above, you will see that on Moday you return the previous Monday through Friday. On Tuesday through Friday...

Yep, your right, I had a slight mistake in my code. Here is the corrected code:

declare @pDate datetime;

set @pDate = getdate();

select

dateadd(wk, datediff(wk, 0, @pDate -...

Have you tried turning your script into a stored procedure that you can then execute in a scheduled job?

If your partitioned tables are in separate filegroups you can do filegroup backups. You should check out BOL for more information on this.

Using SSMS, right click on the database you are going to use as a template, click Tasks, Generate Scripts, and use the the Script Wizard to generate everything you need.

Let me point you toward Books Online (BOL). Take a look at the definitions of sys.tables, sys.columns, sys.types.

Can you provide...

Pretty broad request, what are you actually try to get back from the sql query?

Here is another way to accomplish this, based again an Sergiy's original code:

declare @pDate datetime;

set @pDate = getdate();

select

dateadd(wk, datediff(wk, 0, @pDate - 1), 0) as BeginDate,

...

Not quite. If the date is 3 March 2009, the end date should be 3 March 2009 not 6 March 2009. Based on the OP's requirements.

But, I must...

Based on Sergiy's code, I think this is what you are looking for:

DECLARE @Date datetime

SET @Date = GETDATE()

select

@Date as [Date],

DATEADD(wk, DATEDIFF(wk,...

Look in his signature block. He defines RBAR there.

Not a problem. Having another set of eyes makes you look at things you might not have otherwise.

You made sense, and I have no problems. Didn't matter if the database was created from my desktop system or when logged in (rdp) to the server under the...