Hi Sean,

I read the dynamic cross tab post, very interesting. My issue is that the possible columns for each CASE statement (in your post dates) are completely unknown and variable so I cant use a tally table straight off as in your case.

Also I would run straight into the same issue using the tally table of the main dynamic part of the code running over 8000 characters as it is generated, just as it is now.

I guess if I use the incremental field at least I can do it in sections and use multiple varchar variables.

Thanks

Rolf