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
2010-07-27 21:16:23
+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
2010-07-27 21:24:37