Viewing 15 posts - 1 through 15 (of 17 total)
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
October 2, 2012 at 6:17 am
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
September 10, 2012 at 9:55 am
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
September 6, 2012 at 6:53 am
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 30, 2012 at 10:09 am
Couldn't agree more. Perfect summation.
I thought I was a bit long-winded myself. 😉
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 20, 2012 at 1:33 pm
call.copse (8/18/2012)
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 20, 2012 at 1:30 pm
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 17, 2012 at 3:40 pm
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 9, 2012 at 5:05 pm
Robin Sasson (8/9/2012)
Even 100 years worth of data held...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 9, 2012 at 4:23 pm
L' Eomot Inversé (7/27/2012)
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 8, 2012 at 6:10 am
mtassin (8/7/2012)
CELKO (8/7/2012)
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 7, 2012 at 3:57 pm
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
...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
August 7, 2012 at 6:48 am
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
July 19, 2012 at 5:59 am
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
July 13, 2012 at 6:20 am
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...
"There is nothing so useless as doing efficiently that which should not be done at all." - Peter Drucker
July 9, 2012 at 1:46 pm
Viewing 15 posts - 1 through 15 (of 17 total)