In order to digest, start with my two examples, then read the bit in Books Online on "Create View". You'll see the elements from that in the examples.

Once you...

Sorry I didn't give an example, glad you worked it out. I've seen that kind of error lots of times, and it's almost always caused by dividing integers by...

Memorial Day in particular is about remembering those who have fought and even died for our freedom. My grandparents were WW II vets, my great grandparents were POWs in...

I used to have the first 100 or so books. Definitely entertaining.

I can easily see:

"I am created...

Bob Hovious (5/21/2009)

---

I'll play it safe, just the same, Steve. 😉

You never know... she might be of those Zen archers. Walks out into her yard... tests...

Here's another example. In this one, I set the ID column of one of the tables to be negative 1 with an increment of minus 1, so I can...

A view with Union All in it can allow for edits to the underlying table data, IF there is a key in the two tables that indicates precisely which table...

Are the numbers integers? If so, cast/convert to float as part of the calculation.

For the entertainment value, obviously.

I've always maintained I'd have to drive a long ways in reverse to get back to crazy.

GSquared (5/19/2009)

---

Greg Snidow (5/19/2009)

---

I often see code with semicolons here, but usually without. I have...

Greg Snidow (5/19/2009)

---

I often see code with semicolons here, but usually without. I have queried...

Linked tables may be the way to go now. What I was doing was Access 2000, then 2003, on SQL 2000, then 2005. I haven't worked with later...

That's very similar to the situation I had when I started out. Access as the front-end to SQL as the database works quite a lot better than just plain...

Having an "OR" in the Where clause often eliminates the ability for SQL Server to do an index seek. Instead, it ends up being forced to do index scans....