Hi,

With SQL 2012 (11.3.3128), you only need to declare "WITH" if you are using FORCESEEK.

Artur

Hi Jeff,

Thanks for your reply.

You're right... this can be used as an example of RBAR.

But if we consider that this specific operation is limited to 8000 characters, its a very...

Hi guys,

why dont we keep it simple?

CREATE TABLE #test (id INT NULL, NAME NVARCHAR(20) NULL)

INSERT INTO #test ( id, name )

VALUES ( 101, 'Apple' ),

...