Reporting Services - Looping SQL w/o Stored Proc?

[bassist695]

I need to loop an entire SQL statement so that it runs for each month in an accounting range. I can accomplish this in a stored procedure, but that just adds another level of complexity.

What syntax capabilities do we have in the Free SQL area when you're building datasets? What I mean by that is the dataset SQL that looks like:

=IIF(Parameters!code.Value=1,"SELECT code FROM t_code","SELECT other FROM t_code")

Can this SQL be looped based on parameters?

Thanks