Thank You..it worked...

I want to show the above column in a SSRS table, as an expression(as I have to join two columns from different tables.).

Thanks everybody.

I fixed the issue, this way using SSRS report expression

Format(CDate(Fields!DateOfReportManagement.Value), "dd-MMM-yyyy")

Thanks for the reply. I fixed it. The problem was with the study code used in the other report parameter query for audit code.

Still I cannot fix the bug. Please explain more on this, how to fix it.

Hi Luis,

I have a doubt.

How to post the SQL part and the result set as in a SSMS environment, as you have posted in your post? Please help me as...

Thanks Luis Cazares, for your prompt reply. That helped me lot.

Can anybody suggest a alternate query without using PIVOT in the existing query? Urgent help is appreciated.

Hi

I somehow managed to get it here's the code,

SELECT S.studyCode AS studyCode,

A.activityCode AS activityCode,

ISNULL(TCBOV.cboValueName, '') AS PhaseType

FROM Activities A WITH(NOLOCK)

INNER JOIN TypesOfActivities TOA ON A.typeOfActivityIncId = TOA.typeOfActivityIncId AND A.typeOfActivitySqlId...

Lend me a helping hand rather than preaching.....

I want a query like this. Please help..Urgent...

CREATE Table #Tab (studyCode, StudyDirector, activityCode, PhaseType, ActivityOwner,TQSDComment,TQPIComment)

INSERT #Tab (studyCode, StudyDirector, activityCode, PhaseType, ActivityOwner,TQSDComment,TQPIComment)

SELECT S.studyCode,

SOP.operatorName AS StudyDirector,

A.activityCode,0,0,0,0

FROM Activities A WITH(NOLOCK)

INNER JOIN TypesOfActivities...

Please help me to modify the query so that temp table can be used for updating the various columns like

PhaseType, TQSDComment, TQPIComment, thus avoiding the left join using the same...

How can I modify the query such that LEFT JOIN on activities, typeofactivities can be removed, so that query performance is good? This is my query:

SELECT S.studyCode,

SOP.operatorName AS StudyDirector,

A.activityCode,

CASE...

Thanks Gail. But Chris hasn’t written the code for the splitter function there. I need that code.

Hi

I achieved it through this way. The code below is working.

If any flaws are there in my approach, replies are welcome.

ALTER PROCEDURE [dbo].[eusp_e5_eSM_AS01_MaterialItemContainerlabelReport]

@containerCodes varchar(MAX)

AS

SELECT

MC.MaterialItemContainerCode,

MC.ReceptionDate,

C.clientName ,

MI.materialItemName

FROM

MaterialsItemsContainers MC

INNER JOIN MaterialsItems MI...