I got a error executing the following code. Please help.

ALTER PROCEDURE [dbo].[eusp_e5_eSM_AS01_MaterialItemContainerlabelReport_COPY]

@containerCodes varchar(MAX)

AS

declare @sql varchar(MAX)

select @sql = 'SELECT

MC.MaterialItemContainerCode,

MC.ReceptionDate,

C.clientName ,

MI.materialItemName

FROM

MaterialsItemsContainers MC

INNER JOIN MaterialsItems MI

ON (MC.materialItemIncId =...

I need a help to modify my query to give comma-separated values as SP parameter. Any help is appreciated. Thanks in advance.

Thanks GilaMonster, You are correct.

But my requirement, is to pass comma separated containerCodes as parameters. That should be supported.

i.e. Single containerCodes and multiple containerCodes should be supported.

i.e. EXEC eusp_e5_eSM_AS01_MaterialItemContainerlabelReport 'MC-00000002-13-0001,MC-00000002-13-0002'

How...

I tried to change the Border area from Solid to Dotted. But it is reverting back to Solid , when I again open the textbox properties.

Please help on this.

HI Luis, I am a newbie and I have a doubt on your code.

What is the purpose of the REVERSE() in your code?

ie. here... REVERSE(FullName)

Open the report in report designer tool (i.e.. Visual Studio) and look for datasets created inside the report.

If you right click the dataset>> dataset properties, you can see the...

Hi..Thanks for the reply. It would have been good if you posted a web link for the same..where it is depicting the same..for my easy understanding.

You are right..Jan Van der Eecken, Its my mistake.

What I really wanted is the query written by Wolfgang.

The duration I have written there is wrong, its only an indicator anyway.

Thank...

Hi friends, pls comment on my query and help me out..

Anthony, can you explain more on it and how it can be done.

Guys, any other ideas are also welcome

Thank You Gail n Mike..You guys really helped me..

Yes Gail, rollback script is what I need.

Can you pls help on this? Just a sample SQl Script will do.

Thanks

I have a query regd SSIS, Please explain how to invoke Crystal Reports report using SSIS Script Task ? Also is it possible to directly export the report to PDF...

Thank You all.. for the replies..!!

Thank You all for the responses...

That provides lots of insight...!!!

Thanks a lot...