Thanks everybody, for their valuable contribution on the above subject.

I have created the below sp to accomplish the above task. This adds category dynamically to the main query.

Create proc...

Hi,

Below is the script generated for 2 tables

CREATE TABLE [dbo].[Order](

[OrderId] [int] IDENTITY(1,1) NOT NULL,

[OrdDate] [date] NOT NULL,

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

[OrdValue] [numeric](18, 2) NOT NULL,

CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED

(

[OrderId]...

check the below url

http://sqlaj.wordpress.com/2010/01/12/t-sql-tuesday-002-a-puzzling-situation-the-package-failed-to-load-due-to-error-0xc0011008/

Hi there,

Thnx for your reply. I tried your work around but it seems to be not working, may be I am making some mistake, but let me tell you what...

Hi there,

Nice article, I have one question. When I change your sample code from

use AdventureWorks;

......

declare @t table (col1 int not null, col2 varchar(30));

insert into @t (col1, col2)

values

(

......

TO

use AdventureWorks;

......

declare @t...

Hi there,

Can you please tell in precise what is not working the SP or the Reporting Serv part.

Regards,

a_k93