Carl,

Thanks for your responses... I've read the Sommarskog's stuff so many times I can't recall the count right now... there is a point as well where you need to see...

Andy,

I've never tried what you are attempting, so I can't help you there... but having worked with both Oracle & SQL SPs, the only thing that comes to mind that...

Michael,

Thanks for your post/info with the "health care providers" stuff.  It was very informative for me (and I'm sure the others following this thread).  Your excerpts are right on the...

Ray (& everyone) thanks for all the responses so far!

I would of course rather leave the table names out, but there are other "issues" at play here.  If I could...

Vic,

OF COURSE I pay taxes, they come off my paycheque automatically every month.  I pay at the minimum, CIT ~1000/paycheque right now (and EI ~ 90.00/paycheque and CPP ~ 200.00/paycheque)... oh and I...

Tales from up north!  Not a DBA, and I live in Canada, so our tax deadline is April 30^th.

And while there are some things about the US that are better...

BTW... just came across this article that sort of touches on a similar vein:

http://www.itbusiness.ca/index.asp?theaction=61&sid=58575

Cheers,

Michelle.

Steve,

Interesting topic... it's one that has come up in lots of ways... I.e. what is "journalism" really?!

I think maybe you touched on this topic a while back in a way…...

About the data type, SQL Server determines it based upon what you provide as the calculation. That statement and more can be found at this link: