Besides the .* issue which sounds like you plan on fixing. What was also odd was the naming prefix for the views being 'tbl_' for a view. When...

It's really about trying to balance the documentation as the needs of the users/process change. Your team and functional staff need to determine what documentation is absolutely essential and...

Codesmith http://www.codesmithtools.com may be a little easier.

We use MyGeneration http://www.mygenerationsoftware.com.

It is a little dated, but the templates allow scripting in vbscript, VB.Net, or C#. You can also build forms...

Here's another way to skin the cat. Try using Common Table Expressions. I'm basically doing a recursive query and appending the values back into the columns and then...

I thought I was a bit long-winded myself. 😉

call.copse (8/18/2012)

---

@charles.byrne

Nice post and pretty much where I stand - although I would say I am far less concerned these days at using ORM technology a little more extensively than...

I'm always on the fence with this one, leaning more toward Stored Procs.

From a developer's perspective I have issues with both.

From an enterprise data perspective, I prefer stored...

This is just a caveat to readers of this thread...

As I stated earlier, Don't build a calendar table on Dates unless you really need to. Again, it depends on...

Robin Sasson (8/9/2012)

---

Just to echo previous comments I've used Calendar tables in which is held all the necessary fiscal/lunar/holiday information required for the business.

Even 100 years worth of data held...

L' Eomot Inversé (7/27/2012)

---

Good straightforward question.

But in the explanation: is that really the parsing order, or are you assuming that's the parsing order because it's the execution order? I...

mtassin (8/7/2012)

---

CELKO (8/7/2012)

---

Why not use a Calendar table with whatever fiscal or reporting years you use? The GAAP had 250+ the last time I looked. SQL is not a computional...

That seems a little complicated for a Fiscal Year function.

The Fiscal Year Logic can be pared down to

select YEAR(DATEADD(m,3,RegistrationDate)) as Fyear

...

I use SQL server Access and Oracle, but I have used SQLite and considering the size and function SQLite. It has it's place and again, the footprint is so...

Forgive my ignorance but...

The MSDN document was a little vague on who could do this:

Requires ALTER permission on the database.

But I know that there are some commands that can alter...

I agree with the question being a little confusing when a different select statement is presented, but after re-reading the text twice and ignoring the select statement I got it...