I am not sure I follow your logic in this and I would think about the process flow. I would argue that if this is to unltimatley load...

try

CREATE DATABASE Accounting

ON

(NAME = Accounting,

FILENAME = 'C:\Program Files\Microsoft SQL SERVER\MSSQL10.SQLEXPRESS\MSSQL\DATA\AccountingData.mdf',

SIZE = 10,

MAXSIZE = 50,

FILEGROWTH = 5)

LOG ON

(NAME = AccountingLog,

FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\AccountingLog.ldf',

SIZE = 5MB,

MAXSIZE =...

SQL 2012 includes the Immediate If function and could be used for this.

Do you have a specific question or a part you are having trouble getting? There are a ton of articles on the web with this process described in detail.

Sorry should have thought of that. Try DATEDIFF ( week, startdate , enddate )

If you add something like this you should get what you need

select datepart(week,'09/26/13')-datepart(week,'09/18/13')

This would give you the difference between the two dates and you could simply add the "T" to...

is this based on a set Fiscal year?

Here is a good link with information on how to check if the file exists.

http://www.bidn.com/blogs/DevinKnight/ssis/76/does-file-exist-check-in-ssis

Gail,

Thank you for your help I actually found the row I needed to fix and was able to get this problem taken care of. It has helped me realize though...

There are many posts on the internet that go into detail on trouble starting SQL server agent on express addition but I will say that this would in no way...

Query Result

DBCC results for 'ADVANCED.BIF041'.

Msg 8970, Level 16, State 1, Line 1

Row error: Object ID 292196091, index ID 1, partition ID 72057617438736384, alloc unit ID 72057617450598400 (type In-row data), page...

I tried that and got the same error as before.

row ID 21. Column 'L_EXCLUDETRANS' was created NOT NULL, but is NULL in the row

I have looked at ROW 21 extensively...

have you tried using an unpivot function? that may be a good approach assuming I have understood your problem correctly.

Unfotunaley this is not our case we are doing backups directly to SAN drives and we already have three Nics teamed in the server so that should not be the...

"It is my way of learning" One of the posters said above. I think that summs my problem up perfectly. What about those of us who do not...