Thanks, but can you describe it further, so that I can work on it.

Thanks David, for sharing that insight.

I have put the end date default date as:

=DateAdd(DateInterval.Day,14-Weekday(Today,FirstDayOfWeek.Monday),Today).

I hope it is correct.

Thanks Gila for that post.

I avoided the error, achieved this way:

SELECT convert(nvarchar(max),LF.description) AS Results

Ok,

What is the difference between varchar, nvarchar, and ntext?

Which datatype is the best suited to represent a string data?

Thank You, it has worked for me.

Also, it is showing the table headers now, Is there any way to show one empty row under that, for tables with no value.

nvarchar(100) is the datatype used.

If you have understood the problem, please write the code for the solution. I am working for almost a week on this. Thank You.

I want to pass the comma separated values to the SSRS report to display there.

That's why I have used @Hcodes for output parameter.

I want to pass the comma separated...

Thank You for that.

But how to return the value in column v (table variable column) to be assigned to @HCodes(SP output variable).

The code presently I having is below:

ALTER...

I have made a break through. I found that the setting hazard code to NULL in the first select statement, is the where the problem occurs.

i.e. NULL AS hazardCode,

The...

Hi,

I am posting my query here. Please help me to find a solution. Thanks.

SELECT *

INTO #Activities

FROM (

select

MIC.materialItemContainerCode,

Mi.materialItemCode,

MIC.receptionDate,

OP.operatorName as receivedBy,

MIC.supplier,

MIC.grossAmount,

MIC.netAmount,

UG.unitName as grossunit,

UN.unitName as netunit,

S.siteName,

MIC.otherReference,

-----------

MI.materialItemName,

MIC.batchNumber,

TM.typeOfMaterialItemName,

MIC.expiryDate,

-----------

---MaterialsItems.usedInGlpStudies,

MI.color,

AP.appearanceName,

-----------

MI.isSafetyDataSheetAttached,

H.signalWord,

NULL AS hazardCode,

MI.otherHazard,

NULL AS precautionaryStatementCode,

MT.storageTemperatureName,

MI.storageCondition,

MI.isCertificateOfAnalysisAttached,

MI.certificateOfAnalysisDate

FROM

local_MaterialsItemsContainers MIC

INNER...

This is the query part:

; with BaseProjects (

materialItemCode,

hazardCode)

as (

select

Mi.materialItemCode,

CAST(H.hazardCode as NVARCHAR(1000)) as hazardCode

...

I am getting this error message when the JOIN() in ssrs is used.

[rsRuntimeErrorInExpression] The Value expression for the textrun ‘Textbox96.Paragraphs[0].TextRuns[0]’ contains an error: Overload resolution failed because no Public...

The columns are constant columns in a table.