If you are wanting to view your reports in a browser, one great solution is offered by SSW http://www.ssw.com.au. It's an access based reporting tool that converts access...

Hey Guys, thanks for the great discussion. I love this site because there are always people willing to have an interesting discussion on a good topic.

I strongly agree with scorpion_66...

Hey, Vince's VB SQL Formatter Actually works, I like it. It could probably be enhanced a bit with a UI or something but it's great to find that someone has...

Steve, thanks for the great article, it will create a lot of discussion. Here's my 2c worth.

All of these rules are GREAT if you use a text editor environment. But...

Thanks for the article, it is very useful.

I would love to see your > solution and can I ask for a between solution also.

This is the query that I'm trying...

Using Cast comes unstuck when you want to use a GUI tool to look at your SQL Queries. I often use Visual Interdev to look at my SQL Queries because...

Thanks for the thought provoking article, I agree entirely with Andy; and Steve - you really should check out SQL Compare, it's a great product.

I think that a text based...

Steve, thanks for the Article, I also don't use interdev because now, it doesn't support SQL Server 2000 and does not handle UDF's.

Steve, what I was not clear about is...

quote:

---

When working on tables I always keep a copy of the data dictionary handy and that's how I determine the data type...

Andy, thanks for the start of what I'm sure will be a very interesting series.

On Hungarian Notation, I agree that it's probably WP to use it on column names but...

Thanks Andy, that is some very good sound advice.

I tried things differently this week and we had a meeting between all parties involved in the next piece of work. I...

Thanks, GRN for your thoughts, I think that is the answer, and I'm just about to try that again now with some spec's I'd previously written in the same manner,...