I used this for my solution and seems to work just fine. We faced a problem with creating extract files that an Excel PowerPivot is to import and if the...

So is this a homework assignment? There are missing details here, like what is the type of accounting periods are they expecting, calendar based or something like a 4-4-5 accounting?...

Victor Kirkpatrick (7/15/2010)

---

The key isn't random just because it's an identity, as long as when the records for the date table were created in the correct "month" order. And no,...

One thing I think could be improved is the key for the tables should not be a random key, I would suggest to use the date as the key. So...

According to this post http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/589ca193-3541-4c5e-965c-4c515d6b476b/[/url] is suggests it will not work with SQLExpress.

The mutiple OR clauses will not always get you to hit indexes, so that is not a good idea.

Kimberly Trip recommends to perform UNION ALL instead of OR statements.

Otherwise...

While I don't agree with the approach, and I have created survey apps that did not stuff everything in one column, there is the potential to store your data as...

Normally to search different docs not included is to obtain an iFilter from the vendor. Adobe does have an iFilter that allows the full-text searching to crawl these files.

I just...

We are using the Idera SQL Compliance product. It is able to run without having Admin permissions for the OS. The account that does the auditing does have to be...

The prior was an example for SQL 2000, I noticed you wanted something from SQL 2005, so here is a different example. There are new views that make it easy,...

Here is a quick example of how you might do something like what you want to do:

DECLARE

@ServerName NVARCHAR(128)