Steven Willis (4/4/2013)

;WITH sampledata AS

(

SELECT * FROM

(VALUES

(1,5,6,3),

(2,4,2,5),

(3,1,1,2),

(4,4,2,3),

(5,1,2,7)

) DATA (ID,C1,C2,C3))

SELECT TOP(1)

...

Getting a few errors in the query

COL.VALUE - Cannot find either column "COL" or the user-defined function or aggregate "COL.VALUE", or the name is ambiguous.

T - 'T' has more columns...