Viewing 15 posts - 31 through 45 (of 620 total)
Here are the DDL for the tables
Here is the data for Shelter table:
Michael, did you read the link I posted yesterday? *All of it*? You are heading in...
January 16, 2013 at 8:30 am
kevin.phillips
Thanks again for all the code, but more importantly your reasoning and discussion behind why you did what you did. At least now I'll have some knowledge and some examples...
January 16, 2013 at 5:19 am
wolfkillj
it's been about six weeks since my "real" work has allowed me any time to tinker with it.
Don't you just hate when that happens? I think I'm going for...
January 15, 2013 at 12:02 pm
CELKO
You do not know how to program in SQL to the point you are danger to your employer and the public. Please think about that.
Joe, you do not...
January 15, 2013 at 11:45 am
dwain.c My personal preferences in cases like this is to combine the calendar (time slot) generation with the Tally table
Yep, mine is to always keep things as separate and granular...
January 15, 2013 at 10:48 am
Michael, read this article, then post some sample data and ddl. http://www.sqlservercentral.com/articles/Best+Practices/61537/. It's hard to figure out what you are trying to get at without seeing what you...
January 15, 2013 at 9:53 am
Oliver, you could try this... http://www.sqlservercentral.com/articles/Tally+Table/72993
January 14, 2013 at 11:22 am
Michael Valentine Jones
Your example doesn't make sense according to your stated requirement.
The prior month for next month, February, would be Jan 2013, but 4 and 5 are for Jan...
January 14, 2013 at 11:02 am
AllHype, is this for a class? You should read this article, http://www.sqlservercentral.com/articles/Best+Practices/61537/
, then post your sample data, ddl, and what you have tried so far. You do not...
January 14, 2013 at 10:16 am
Alan.B
That Levenshtein business is a little more complicated than I thought. I am going to keep at it and I'm dying to see what Dwain puts together.
I kind of thought...
January 14, 2013 at 9:55 am
Kevin, also, I did not notice this was your first post, so welcome to the forum, and thank you for posting sample data as you have. You will notice...
January 14, 2013 at 9:42 am
Kevin, there's some good stuff around about how to make calendar/schedule tables. Anyhow, I have a couple of questions. Do you want to see vacant time slots when...
January 14, 2013 at 9:24 am
In addition to the above two explanations, you also need to think about whether or not your code will scale well. For example, you might have a table with...
January 13, 2013 at 3:35 pm
dwain.c
Looks like you may have beaten me to it.
Oh, don't worry about that, Dwain. Admittedly, I did look at it thinking it was only a minor tweaking of Alan's...
January 12, 2013 at 4:22 am
Oh, I heartily agree with you Jeff...but as long as they keep askin'.
January 12, 2013 at 4:14 am
Viewing 15 posts - 31 through 45 (of 620 total)