It the case of a NOLOCK situation do you not already have a company policy on this?;)

Regards,

Shaun

Matt: I was reserving my opinion on it till someone had real world facts.

You know how when someone comes up with an idea and it just doesn't feel right but...

MI:

MS SQL Server is a tool to manage data.

When we talk of a design issue - we are referring to the design of the database schema being used not the...

Kas:

I do agree with you, but that is a different issue;

My point was about table design.

Your point is about 'query results'.

Both are valid.

The COALESCE function then comes into play.

--Shaun

Kas:

although I agree with you in principle a function will cover bad design - if you mean zero then zero should be what is in the column; 😀

I think the...

DNA test them...oh sorry this is not the CSI forum?

--Shaun

Current petrol prices here are abou $7.73 per gallon(US)!!!!!

:crying:$6.18 of that is tax!!!!!:crying:

--Shaun

Jeff: Would those be USA gallons then? (English gallons are bigger!) 😉

--Shaun

Sorry - had not read all of the posts before posting!:rolleyes:

--Shaun

Whitt: can you not 'just';

1. Use your data cleaner (.NET app) and have it out put a well formatted CSV file.

then

2. Use SQL Server to import the data...

So Whitt was using extreme RBAR?:sick:

--Shaun

:D...the sum of the parts is greater than the whole....:D

--Shaun

Fix the problem not the _users er blame!

Steve your an idealist, and not towing the corporate line!:D

--Shaun

Everyone not in the know should read this;

http://www.sqlteam.com/article/more-trees-hierarchies-in-sql

--Shaun

'spreading something that could be knowledge'

And I thought it was a description of your way of life. 😀

--Shaun