Posted by Hugo Kornelis on 04/05/06 00:43

On 3 Apr 2006 19:55:38 -0700, --CELKO-- wrote:

(snip)
> Each VIEW could be changed to include a list of accounting codes that
>would choke a moose if you had to have each and every programmer do it
>by hand for each query.

Hi Joe,

Please, for the sake of who- or whatever you believe in, don't do this!

Put the list of accounting codes in a table and add a join to your view.
That's how proper SQL programmers do it.

--
Hugo Kornelis, SQL Server MVP

[Back to original message]