3D Desk

Well, I got to use my editor at work today. They needed a graphic of an 8 x 10 cubicle for our case managers. Kakoa, our Visio guru was out today, and so I gave it a go with my new editor. I didn't have much time to do the modeling but it turned out okay. I added a little shadowing in Photoshop but that was about it.

Happy Coding!
Jas

SQL Views with an ID column

I was recently given the task of replacing a table with a view and this table had an id column. There is a way to represent this id column in a view.

The following article explains the way to handle it:
http://support.microsoft.com/kb/186133

Keep in mind the limitations of this approach. Your row count can't be that large. If you have a large set of data and can use snapshots, consider using a temp table filled periodically for reporting. This will improve your query size and enable additional indexes if you require them.

Happy Coding!
Jas