How do I know if we have read committed snapshot isolation turned on?

You said use DT - is that a space saver for tempdb? I mostly use declared unless I need an index.

They were report starving. I just don't see how I can give them the data they want without using temp or declared tables. Any other ideas or suggestions?

It was just filling up. Then it got to big obviously and caused other issues. It had been 3 weeks since that server was restarted. Is it...

Yes - our tempdb grew out of control over the last month. I've written a ton of code for reporting purposes for a company that was using spreadsheets to...

Well I've moved all the log files on this server - I just didn't know if there was something special on the system db's.

Yes - I get 1,2

Wayne,

I've put the original code back in the code property and have the same results - nothing returns. However, now that it's back to your code - is there...

This is the function in the code section - which is different from the beginning article.

Function ReturnXML(ByVal MultiValueList As Object, ByVal Root As String, ByVal Node As String, ByVal Element...

This is so frustrating... yikes - I get an error running that just in design view right?

here's the whole detail

===================================

An error occurred while executing the query.

10008 (Microsoft Report Designer)

===================================

10008 (.Net...

First off thank you so much for trying to help me... I've tried the passing and parsing out - that doesn't work. I'm wondering if there's a setting...

this is what I have in my sp

INNER JOIN

@C.nodes('/C/CUSTOMER') as m(item) on cast(CS.CUSTOMER_NUMBER as int) = m.item.value('CUSTOMER_NUMBER[1]','integer')

Dang I wish that were it - it's all caps in both the sp and in the report pieces.

The declare @c1 varchar(max)

set @c1 = convert(varchar(max), @C)

returns my params...

C=Root is the parameter name both in the report and the sp and there is only this param

Customer=Node is the displayed label name of the param

Customer Number=Element is the actual...