Well, basically, a float is an imprecise datatype, and you can't rely on retrieveing it exactly as it was entered. You will always experience rounding errors with floats.

If the format...

If you are certain that the first number always denotes the start of the reference number, then you can substring it using patindex as start marker and take 4 chars...

You then need to first find which date is closest for each ItemNo, and then you can join against that..

SELECT i.*

FROM

  (

 SELECT ItemNo, MAX(regDate) as maxDate

 FROM...

Well, exactly what are you asking for?

How would you phrase your question (with your testdata) in "plain" english?

/Kenneth

If you view the update of all transactions as one unit, then yes - you could (or even should) wrap it in an explicit transaction - if for nothing else,...

Indeed it does.

In that case, I wonder what it is that's 'not working'... The query is correct written as is it seems.

If it...

There is a lot of good info on userdefined functions to be found in BOL. (Books On Line) The answer to many questions can be found there

Agreed.

2nd approach isn't even specific for nullhandling, it's more generic to resort to dynaminc SQL - which you should always try to...

Have a look in BOL for OBJECTPROPERTY and COLUMNPROPERTY

/Kenneth

Somewhere between the db and asp page there is a layer that has the same type of truncation of length...

Have no clue what or where though...

Well, again, I'm not sure that I have understood the entire problem posed here, I'm so far just assuming what the poster's intentions are.

In any case, your input/output doesn't correlate...

Short answer - no.

Long answer could involve a discussion as to why order of columns would be an issue at all, since there is no order in relational theory

In QA, go to menu Tools => Options => (tab) Results and set "Maximum characters per column" to a greater value.

/Kenneth

This doesn't work according to the example.

Note that the 'A-person' id has both 1 and 0 as values for 'A', but on different dates. This probably means that each  column...

Try change all ISNULL to COALESCE instead. That should do waht you want..

/Kenneth