This works but I faced another issue:

No global profile is configured. Specify a profile name in the @profile_name parameter.

Which version of SSIS are you using?

The information posted at this URL might help you to resolve the issue:

https://connect.microsoft.com/SQLServer/feedback/details/552940/sp-send-dbmail-throws-error-22051-file-is-invalid-when-attaching-files-from-a-share-unc-notation

Yes.

1. Use row_number() or

2. compare the senderid, requestseq of 2nd row with first row and if equals hide those columns in 2nd row etc.

For remaining duplicate rows, can you try setting visibility = false at column level ?

I clearly mentioned that its additional information.

I knew that, I've provided additional useful information.

Thanks Luis, that adds more value.

You need to query the ReportServer Catalog table to get the reports running statistics.

The following links would help you:

http://sqlsrv4living.blogspot.in/2014/01/ssrs-get-list-of-all-reports-using.html

https://thesqlpro.com/2012/07/09/ssrs-report-usage-statistics/

Hi Steve,

Thanks for providing the sample data.

Here is the solution which would work for you.

CREATE PROC uspupdatetest

(@id int =null

, @param1 CHAR(5) = null

, @param2 CHAR(5) =null

)

as

begin

set nocount on;

set xact_abort on;

update...

Option1 is will impact the performance severely as database will be hit for n times for n parameters.

Hi,

I think its more to handle in formatting the data i.e. pro-grammatically we need to hide the columns based on sender, requestsequence values using expressions.

If you are using reporting tools...

Can you provide brief table structures with sample data to better help you?

I think its possible for you even though the UI interface not yet ready.

have you tried this?

SELECT RequestID, ReqSeq, ROW_NUMBER() OVER(PARTITION BY RequestID, ReqSeq ORDER BY ReqSeq )

FROM Layout;

Hi,

We must create a login mapping between the linked servers. When SQL Server connects to a linked server in order to execute a distributed query or a stored procedure, it...

Can you explain little more, in spreadsheet for 3 request IDs 1,2,3 the customer ref number is different.

What's the significance of this number and how you want the customer ref...