My apologies. H/T to Alan for the script to set up the DDL:

/****************************************************************************************

(1) Setup DDL

****************************************************************************************/

IF OBJECT_ID('dbo.Chooser') IS NOT NULL DROP TABLE dbo.Chooser;

IF OBJECT_ID('dbo.Book') ...

Hi Alan,

This does a really great job of generating random test data. What I'm looking for is a query that pulls out the data from the Battle table that indicates...

Thanks Rudy - I've used the AD API before and I know that's limited to 1000. I just thought it was odd that the number here through open query...

Looks to me like I get an error unless I bind the results to just the first 901. Is that consistent with what others are seeing? If so,...

@paul_ramster - My thoughts exactly. That is the way I've always done it in SQL and other languages. The only reason you'd need to use a...