thanks Markus!

I didn't realize about the implicit CREATE TABLE.

Pretty poor answer to this Q. the addition of XMLA is a small part of a larger upgrade!

reference: http://technet.microsoft.com/en-us/library/ms170363.aspx

In fact it is a shameless plug by Apress and...

Thanks for your time Peter. I believe though that this still represents a range col1 would be A? to EX not just EX.

I would like to classify the States in...

I realized only afterwards that I posted my question in the wrong section.

sorry

You are going to have to put the whole cursos declaration into a vaiable and execute it

DECLARE @SQL varchar(8000);

SET @SQL = 'DECLARE MY_CURSOR Cursor FOR Select ID, Event From Sometable...