Davy, assuming this code and your Rule Number 1, what do you do:
|create procedure GetSomething ( @SomeFlag ) select * from SomeTable where SomeColumn<> @SomeFlag|(just to be clear this query will not return rows where SomeColumn is null, assuming @SomeFlag=1)
On 18/01/2012 11:24 PM, David Rhys Jones wrote:
Rule number 1, Don't do business logic in the database. .02c Davy,The US Congress voted Pizza sauce a vegetable. Don't even try to convince me of anything in the states is sane any more!