How is it possible to export this to a XML file? Do I need to use BCP and cmodify the code into a string?

Hi,

Also, how can I do nesting?

Thank you very much!

awesome! thank you!!!

Thank you!

You just saved my day! Thanks so much!!!:-)

Hi Eirikur and thank you!

The senario I really am trying to achieve is:

/* Will not work */

SET @AcctType = 'ABC,GHI,JKL'

SELECT COUNT(AcctID)

FROM Customer

WHERE AcctType IN (@AcctType);

How do I make this work...

that is it! thank you very much! =)

nevermind, I just realized I was missing: ExecJob.Connection = cn;

Hi,

I would like to get the results of three different queries and put them all into one temp table. I am trying as follows but does not seem to...

Thank you Luis, I appreciate your help! =)

Yeah, that's what Im looking for! Thank you very much!

Hi,

Thank you. The part I am getting hung up on or just don't understand is having the parameters for a where statement be variable. How do I make...

Thanks again!!!!!!!:-)

This forum is awesome!

Thank you both!

Sean, I should have been more clear, I have a date field that I am calling myDate and want to check against the field (not using current date/GetDate())....