Hi Parthi,

You have give it as

MAX(rvalue)

FOR rvalue IN( [20 Apr 2010],[23 Apr 2010],[21 Apr 2010],[22 Apr 2010] )

the values are from dates table but you have given rvalue. It...

Hi ,

I agree with you that any of your table or text boxes are not there near to that edge, but still cross check it, better do this check by...

Hi Ramanathan,

Also please note that you cant give the parameter within the single quotes. It should be

If @parametername is not null

set @sql = @sql + 'and columnname = '...

Thanks for the reply.

Now when I tried to create it again , it got created without any error, don't know how... 🙂

Hi Ramanathan,

In that case better go with the dynamic SQL as Jeffrey mentioned.

You can check whether each of the input parameter of the SP is NULL or not, if it...

Hi,

Are you in a position to change the table definition for these fields ? Will you be able to make it unique field? .

As you know if these fields...

Hi Krishna,

The problem is in the section.

Where ([Provider Type]=@[Provider Type])

AND ([Sub Timely Category]=@[Sub Timely Category])

Please give the parameter name same as you have given in the "Report Parameter" part...

Thanks for the reply.

Unfortunately I didn't check these two things... And as I mentioned, when I dropped and recreated the SP it was fine, so no chance to replicate it.....

Hi

I think the below two sys tables in MSDB will help you. You can filter it for your Jobname

select * from sysjobs

select * from sysjobservers

Regards,

MC

Hi

Ron thanks for reply and sorry for not following the style of posting which you mentioned.

In my case as I told when I executed it as a script it completed...

Hi,

I think the @@Version provides the version details (Service Pack) of the OS. If we have different Service Packs for OS and SQL we can see the difference between by...

Hi,

Could you please try using a Data Conversion task in between Excel source and table destination. And in this task give the required format for the column.

Regards,

MC

and....also it looks like the topic got deviated from my doubt... 🙁

Is the max width of table report in SSRS 2005 is 406cm ? , my report has lots and...

Hi Sorry I mentioned length, I wanted to know the max width of the table item in SSRS 2005.

Regards,

MC

Hi thanks for reply.

But in this link I could see the Max Capacity of the table object, but what I was tryin to know is the max length of the...