I ran into a similar issue recently using OpenQuery to connect to an Oracle instance. The failure was being caused by comments being inside the string that was passed thru...

I think you've misunderstood. This sp has 25 separate inserts that are all executed individually by setting the Query to a string and executing sp_executesql. Each insert is set to...

As long as you're using SSRS 2008 and you know the parent id this should be possible. In your report, go to the group properties for the Detail level of...

I think you could make an argument for any of the answers. There wasn't enough information given in the question to choose a truly clear-cut best answer. char(1) and varchar(1)...

BOL lists Reporting Services as only being available on Enterprise, Standard, Workgroup, Web, and Express Advanced, not for regular Express edition. So shouldn't the You cannot have an Express edition...

It's finally starting to make sense. Thanks for taking the time to help me out!

Could you expand a little on what makes rdl's impossible to apply styles to and the difference in rdl's and traditional xml? I'm still confused on what the differences actually...

Thanks for your help. I've read the articles and I am investigating whether or not utilizing workaround custom assembly driven "style sheets" is the best solution but what I want...

Thanks, I think that will accomplish what I need.

I was afraid that was the case. Thanks for all your help! I appreciate it.

Here's the xml attached in a text file for better viewing.

Sorry, here's the code snippet I meant to include in the previous post(with {} replacing <>):

{questionset}

{question vo="" id="1" returnOnIncorrect="false"}Will this work?{answer id="1" correct="0"}{input}Maybe{/input}{output vo=""}That is correct.{/output}{/answer}{/question}

{question vo="" id="2" returnOnIncorrect="false"}What time...

I have encountered a new issue that I think may be due to poorly formatted xml but I'm not sure. I have this snippet of code:

...

Thanks, it worked just fine. I'm still very new to using xml in sql so this helped out tremendously. Thanks again.

I think the answers should have been more detailed(for once). 32 Bit SQL Server 2008 alone does not support hot-add memory. It has to be Enterprise Edition and have AWE...