|
|
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
Navigation:
[Reply to this message]
|