Hi Scott

I'm working with SQL2K and importing from Excel files using server linking, however I get a similar error message...

Server: Msg 7399, Level 16, State 1, Line 3

OLE DB provider...

You give me way too much credit Mr Moden, and on a wednesday too, when I get to work from home

<<exactly the same way as noon belongs to pm.>>

Absolute rubbish as usual.

http://www.worldtimezone.com/wtz-names/wtz-am-pm.html

Do try to get something right.

Hello

If you know the maximum depth, or there's likely to be a sensible maximum depth, then you don't necessarily need to use recursion. If this is indeed the case then...

Rarely. Really.

Here's another expression representing a number: "pair". It means 2. Like "one third" (or 1/3) it's a text expression, not a number, although it requires no evaluation.

Here's a handy example of usage:...

You've finally got something right.

Nope, like 0.(3) it's NOT a number, it's a representation of a number. An expression.

1/3 isn't a number, it's two numbers and an operator - an expression. Any child could tell you that. So why ask how to store 1/3 as a single number when...

SELECT ...

FROM table

WHERE NULLIF(field,'') IS NOT NULL

or

SELECT ...

FROM table

WHERE ISNULL(field,'') <> ''

I'm gonna have a beer now...on second thoughts, think I'll have a beer instead, just for a change.

Julia, try a slightly different syntax:

UPDATE C

SET ITEMS = ITEMS + 1 ---