re: Incorrect syntax near '[Insert Arbitrary Column Name]'

Brannon — Wed, 18 Jan 2006 23:22:52 GMT

Check out the new WITH statement in SQL 2005.

You could write your SQL like so:

WITH Results AS
(
SELECT
ContactId,
FirstName,
MiddleName,
LastName,
ROW_NUMBER() OVER (ORDER BY ContactId ASC) AS RowNumber
FROM
Person.Contact
WHERE
MiddleName IS NOT NULL
)
SELECT * FROM Results WHERE RowNumber BETWEEN 1 AND 15

** I don't have AdventureWorks installed on my SQL 2005 instance, so I couldn't test the exact syntax/query, but it *should* work.

-Brannon

re: Incorrect syntax near '[Insert Arbitrary Column Name]'

Anonymous — Wed, 25 Jan 2006 17:40:51 GMT

Who the heck really wants to read this stuff? Write about something more interesting! :)