Recent content by joelwenzel

also, note that session variables can hold any object (eg,, you can put a whole array in a single session variable)

Here are some ways to do this...i know there are others as well but I do not know the sytax off he top of my head. Method 1: Session variables in asp script write something like Session("FirstName") = textboxID.text Do the same thing on the second page except replace the first name with the...

ok, I've come up with a design for showing the schedule. This will work in combination with a simple booking system. What do you think? I realize that my syntax is not proper. Also, I know it is bad to select everything. I was just trying to get the idea out there. -stores the regular weekly...

Ok, I realized a major problem with my design. I was thinking of it as one system (for booking) but what it really is is two systems...one for storing bookings, and one for showing a schedule of available time slots. It is the schedule part of this problem that I am having trouble with. Does...

I like your post. It is a good example. I was hoping I could avoid mapping out everyday of the year however Anyway, my system has a couple considerations that makes it hard to adapt to your system. First, I think your sysem requires all the time slots to be the same length right (eg all...

I am trying to create a booking database...but the design I keep coming up with makes me a bit uneasy. I don't really like it (because of massive joins involved in determining what time slots are available) but I don't see any other way to do this. So this is my design. --This table stores...

Hi, I have this select statment in a view (SELECT s.MyTime,p.FK_CategoryID, (s.Col1-p.Col1) as Diff FROM stats_main s,stats_comparison p WHERE s.FK_ComID = p.ComID) UNION ALL (SELECT s.MyTime,p.FK_CategoryID, (s.Col2-p.Col2) as Diff FROM stats_main s,stats_comparison p WHERE s.FK_ComID =...

ok, I've now looked into partitioning a bit more and I understand it now...just had to find an example. My original plan was to separate my table into several smaller tables specific to a category ID (that was in my original huge table)...and then find some way to do a SELECT from @TableName...

Well, for the application I am creating, people are almost as likely to search through data from 5 years ago as data from yesterday.

I found this article on dynamic SQL in case anyone else is interested. It is a very good overview of the advantages and pitfalls. http://www.sommarskog.se/dynamic_sql.html I am aware of horizontal/vertical partitioning but I have never fully understood the advantages. Suppose that I choose...

yes...I vaguely remember learning about query plans a long time ago. What it really sucks that i ccan store the query plan. Unfortunately, I don't know how else to do this. If I use dynamic SQL, I can break up my main table into several smaller tables (each with less then a million rows). If...

hmmm this is interesting. I should be doing stuff like this more often...I'm not thinking about the actual issues enough but I guess that will come with experience. My issue was actually the query time length...but from what you are saying, I might as well be using denormalized tables (in...

yeah....I was thinking of something like that. Seems to be the way to go I guess. My tables are too long so I think I will break them up this way. thanks for the syntax.

so, I was thinking, one way to do this would be to create a stored procedure that would first select the tablenames from MyTable, then create a string select statement joining the tablenames to the string. And then it would call execute to run the string as an SQL statement. This would return...

Hi, I want to do something like SELECT * FROM (SELECT tableName FROM MyTables WHERE userID =3) tableName is a column in the table MyTables. tableName is the name of another table in the database. So what I want is to select from the data in the table whose name is tableName. What I don't...