re: Katmai: Looking into Row Constructors

Ericga — Thu, 23 Aug 2007 22:21:54 GMT

Real nice (and we will use it!), but what everyone was expecting was:

Select *

From MyTable

Where (1,'44') in (Select A, B From Other Table...)

xmldeveloper — Sat, 13 Oct 2007 16:01:21 GMT

Hi Duncan,

The following example works for me:

DECLARE @Employees TABLE(

EmployeeID INT,

FirstName NVARCHAR(64),

LastName NVARCHAR(64));

INSERT INTO @Employees(EmployeeID, FirstName, LastName)

VALUES (1,'John','Smith'),(2,'Peter','Anderson');

INSERT INTO @Employees(EmployeeID, FirstName, LastName)

VALUES ((SELECT 1+MAX(EmployeeID) FROM @Employees),'Brad','Johnson');