Viewing 15 posts - 736 through 750 (of 1,473 total)
Friday afternoon fun with Tally tables! I decided to go the table route rather than a single variable route (As the original post seems to indicate that he needs...
August 28, 2009 at 2:55 pm
Take a look at this article[/url] written by Jeff Moden. About halfway through the article there is an example doing exactly this.
If you get stuck or have questions, post...
August 20, 2009 at 10:41 am
Having the data gives you a lot more options. Just throwing out a couple ideas of things you could do with it in that case:
Set up an a scheduled...
August 19, 2009 at 9:21 am
After I:
º Restructured the tables multiple times to avoid dynamic SQL
º Wrote some of the queries
º Planned out a system to dynamically generate forms via the website for this variable...
August 17, 2009 at 3:11 pm
In sitting here trying to justify the existence of this field with an example, I think I've decided that it's something that really shouldn't be done. I was primarily...
August 17, 2009 at 10:33 am
RBarryYoung (8/15/2009)
You might also consider using the sql_variant data type. This is after all what it was intended for.
Sounds like a plan. Thanks Barry.
Any comments from anyone on...
August 17, 2009 at 9:26 am
I think this is the longest thread I have ever seen. I read page 1 and page 248.
As to whether or not the posts have gotten worse,...
August 16, 2009 at 10:13 pm
Thanks for the input Matt. Unfortunately, I don't believe we'll ever get past the point where this is a temporary answer. My circumstances require this level of fluidity....
August 15, 2009 at 5:15 pm
I think you're going to need some sort of uniquely identifying field in your base table so that you can isolate rows for deletion. It doesn't need to stay...
August 15, 2009 at 7:42 am
To answer the question of storing aggregates vs. storing all the data, you simply have to answer another question: Is the ability to drill down or get more information...
August 14, 2009 at 4:42 pm
Updated the original topic again with additional information about some constraints on this project.
If anyone feels that there is a better solution to this 'opportunity' than my EAV...
August 14, 2009 at 4:16 pm
It always does =).
I updated the first question in the actual post.
As to the second, the information mainly be queried in two different ways.
The first would be just...
August 14, 2009 at 2:12 pm
Jeff Moden (2/9/2009)
Garadin (2/8/2009)
Is it good practice then to add all criteria to the derived tables instead of the outer query? Guess that makes more sense overall anyways.
I hate...
February 9, 2009 at 1:43 pm
Jeff Moden (2/7/2009)
Garadin (2/7/2009)
February 8, 2009 at 11:01 am
I think I could. The problem is, the estimated showed no issues at all, and the actual either ran in milliseconds or I had to kill it after a...
February 8, 2009 at 2:06 am
Viewing 15 posts - 736 through 750 (of 1,473 total)