Thanks guys, VIEW SERVER STATE did the trick. Got thrown by the fact that it threw an error about a deferred prepare.

That worked! Thanks very much Peter, I hadn't considered casting as XML.

Cheers

Unless the table is a clustered index,...

If you want an XML fragment to retain the special characters the leaf of the node needs to be either [*] or [node()]. Since your leaf (td) is neither...

Sorry to bump this, but I really need an answer. Has anyone got any ideas please?

Lowell (10/20/2011)

---

i believe the issue is this;

FOR XML PATH('tr'), TYPE)

in that case, TYPE escapes out all the brackets (less than,greaterthan, quotes, etc) that would have been HTML.

FOR XML PATH('tr'))

will...

Thanks for the replies guys. Turns out one of the analysts was inserting 27 million rows and doing a lot of sorting on non indexed columns. He finished his run...

I do not have a problem with the transaction log, it's the actual database files.

Thanks...

Thanks for the advice. Turns out that the telco already made a payment to us and therefore hosting the solution and just providing the service to them is not an...

Fixed it. The second tablix was overlapping the first tablix ever so slightly. Moved it down a notch and redeployed the report, the problem with printing is gone now.

rjohal-500813 (3/2/2011)

---

Hi

It might be because you are mixing old and new style joins in one statement. Do either of the following two work?

SELECT

invoice.contactid, invoicedetail.invoiceid, RecType=2, DetailID=invoicedetail.id, invoice.trandate, Reference=ISNULL(ItemCode,''), Details=ISNULL(Description,''),...

Sorry for the delayed answer. I didn't provide any DDLs because I was sure that something wasn't right. I eventually got the string manipulation working, but found that the function...

Using either of your examples, I get the values returned as multiple rows. SQL then only filters on the first row. For example, if @Fund = 'Annual Giving 2008, Annual...

ALTER PROCEDURE [dbo].[sp_AllFundraisingPayments]

@Fund NVARCHAR(MAX)

AS

BEGIN

SET NOCOUNT ON;

CREATE TABLE #Fundraising(

AccountNo INT,

ContactID INT,

AccountTo NVARCHAR(MAX),

FundraisingGreeting NVARCHAR(MAX),

FirstName NVARCHAR(MAX),

PreferredName NVARCHAR(MAX),

LastName NVARCHAR(MAX),

MailingAddressID INT,

Address1 NVARCHAR(MAX),

Address2 NVARCHAR(MAX),

Address3 NVARCHAR(MAX),

Postcode NVARCHAR(MAX),

Country NVARCHAR(MAX),

FundInvoiceID INT,

DueDate DATETIME,

FundId INT,

FundCode NVARCHAR(MAX),

Fund NVARCHAR(MAX),

SubfundID INT,

SubFundCode NVARCHAR(MAX),

Subfund NVARCHAR(MAX),

Amount INT,

PaidDate...

Looks like I might be on the wrong track, my apologies for the confusion.

Here's a bit of background. I have a SSRS report running that has the ability for users...