Oh well. Never mind then.

Who?

(now where's that new angelic emoticon?)

SELECT MAX(date)

FROM (

SELECT date

FROM @Table1 T1

...

Gentlemen,

There are indeed many fine ways to write an in-line number generator!

My point was simply that the originally posted code was not one of them.

All very interesting though.

Good point. 😎

No...but it is a pretty trivial query to...

Semantics...:-P

Initially, just by looking at it. Then by checking the execution plan. Then by testing it.

SET STATISTICS TIME ON;

;WITH

Tens (N)...

Can't believe that no-one has posted a link to Erland's article on this topic yet.

Arrays and Lists in SQL Server[/url]

Best guide there is, IMO.

If the statement was generated by an automated procedure, you need to check that code. If you post it here, we can take a look.

BTW sp_change_users_login is deprecated and...

APPLY would have been much cooler :laugh:

Glad you found the solution!

WayneS (3/23/2010)

---

In MY experience, those people that go to college from high school, get a degree in an IT field (even a masters!), and then join the work force have...

Dave Ballantyne (3/23/2010)

---

Not odd, ive always thought the exams...

Kevin,

For brevity, I am going to assume that you know all about the evils of T-SQL scalar functions, those that do data access in particular.

Nevertheless, I would join Stefan in...

The Dixie Flatline (3/23/2010)

---

True, but then you create headaches for the poor, struggling UI developer who has to learn how to handle two different types of output from a single...