Thanks a lot Craig!

"Data access mode" in OLE DB Destination.

That's where the problem was!

As soon as i switched to fast load

it took only 2 min to load 3 half a...

See the screenshot attached.

I am using

for MS Access connection:

Native OLE DB/Microsoft Jet 4.0 OLE DB Provider

(the actual mdb file is Access 2000 version)

For SQL Server 2005:

Native OLE DB\SQL Native Client

No transformations.

I'm using...

Bhudev!

Excellent query!

It is a huge problem for us to quickly identify the SubscriptionID

when user forwards an email generated by Subscription (built-in, not DDS).

With your query it becomes a lot easier.

Bhudev,

Do...

Hi Luke L.

You are right. Trying to update ReportServer.dbo.Subscriptions directly is probably not a good idea.

I tried it the whole day yesterday with:

UPDATE Subscriptions set Parameters =

REPLACE(CONVERT(VARCHAR(MAX),Parameters),'qweqwe',

'<ParameterValues><ParameterValue><Name>P_FILTER_RISK</Name ....(the whole XML...

Dear lmu92,

Thank you for trying to help but ...

your article is very big. I didn't have time to search through it to find if it's relevant to my case.

There is...

I'm on SSMS 2005

and not sure how to save Graphical Execution Plan.

Plus it never stops executing. It gets stuck at

INSERT INTO

#FlatResults

(........

I included STATISTICS ON...

and got an error:

'XML' is not a recognized statistics option

The database is running on SQL Server 2000 server.

I guess that's why?

Florian,

I use JOIN:

......

INNER JOIN #ParseString2 ON F.RiskIdShortName = #ParseString2.item

That's exactly what I did...

SET @P_RISKID = 'CAD,USD,EUR,GBP,JPY,CAD+CSW,USD+USW'

create table #ParseString2(item varchar(15))

insert into #ParseString2(item)

select * from dbo.fn_ParseString2(@P_RISKID,',')

.......

INNER JOIN #ParseString2 ON F.RiskIdShortName = #ParseString2.item

and it runs endlessly....

Florian,

You were probably right.

With JOIN #ParseString ON #ParseString.item

it was running for 3.5 minutes and then crashed with an error:

Msg 0, Level 20, State 0, Line 0

A severe error occurred on...

Sorry.

I reduced the amount of code.

I'm not sure you understand the problem.

I am talking about multi-value string parameter.

In Report Manager I can select three different values:

CAD

CAD+CSW

EUR

How can I do the same thing in Query Analyzer?

This...

You have to keep in mind.

We have about 150 reports for 5 or 6 different groups/departments.

Each report is serving different needs and tasks.

We cannot create a table ParamCurrenct or something...

So far we came up withia set of tables to build our own DDS system.

Below is the schema.

USE [Subscribers]

GO

CREATE TABLE [dbo].[UserInfo](

[UserEmail] [varchar](50) NOT NULL,

[Name] [varchar](50) NULL,

[Format] [varchar](50) NOT NULL,

[Attach] [bit]...