Grant Fritchey (12/27/2008)

---

Don't be too sure about that. I remember interviewing this guy once who never got an answer wrong. He could talk all day long about the databases. We...

Joshua Perry (12/26/2008)

---

... A good example is that most schools now have whiteboards that allow shared input by students with several wireless tablets, so they have the ability to...

Like this:

IF APP_NAME() = N'Microsoft SQL Server Management Studio'

BEGIN

ROLLBACK TRAN

RAISERROR 'You are not allowed to edit tables with the GUI', 15, 1

RETURN

END

Please see this article on how to get better results from these forums: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Brain Cells? You have Brain Cells?!? How do I get some of those??

😛 😛

Is this for SQL Server 2005?

In Excel turns, referencing horizontally is easy, vertically requires a little bit more work.

First you need a column or columns to unique ly order the rows. In your case...

Well, gotta have something to fall back on if that Auto Industry thing doesn't work out, huh?

I find his books really irritating. Codd was better than Date, IMHO, but they both have this habit of saying contradictory things all the time. And Date in...

Brain Cells? You have Brain Cells?!? How do I get some of those??

😛

Heh.

Happy Holidays to everyone!

You know I am really not crazy about this...

Yes, but any View solution can be converted to a pre-aggregated solution just by doing: SELECT * INTO PreAggTable FROM MyViewSolution

Jeff Moden (12/24/2008)

---

I'm not sure why folks try to use so many bitwise integer columns. It makes the column "multi-purpose" which is not what the definition of a column...

"Michigan Pork Chops"

Sort of like "Omaha Steaks", only faster! 😀