Hi All,

You will have to excuse me if this is not the right forum for this sort of
question but it seemed like a good place to start. I am trying to return
some data from Sql Server, I will try and give as much detail as possible. I
have written a very complex query in TSQL which pass's in a selection of
defined variables into a selection of select statement, What I would like to
do if at all possible is rather that passing the variables into the stored
procedure in TSQL and populating tables and then just creating a basic select
statement in Microsoft Query, is it at all posssible to get the Excel Sheet
to ask for the variables, so in theory and it is very much a theory is there
a way of programming such a complex statement into Microsoft Query. I hope
that makes some sort of sense and I can paste the code if anyone needs it.

Thanks in advance Philip