tags:

views:

32

answers:

1

I haven't seen this before in a query, basically what is going on here?

+1  A: 

Looks to me like "#CHUNKSIZE#" will be replaced with a numeric value and become:

SELECT TOP 10

Or something similar... no idea where it would be replaced. This is apparently answered in the comments.

Adam
+1: SQL Server syntax since v2000. 2005+ saw adding support for brackets so you could use a variable for the number of rows or percentage without needing to use dynamic SQL - [documentation](http://technet.microsoft.com/en-us/library/ms189463.aspx)
OMG Ponies