Hi Guys,

Am very sorry for not giving enough details.

Let me explain the scenario as follows:

I have a stored procedure to publish a report which in turn is calling many sub...

Thanks for the quick reply, it works.

Will let you know again if i find any problem.

Subhash

Hi All,

Thanks a lot for all the inputs.

Yes, 'FROM' is missing in the query and after correcting its executing.

The same is :

SELECT D.CUSTNMBR,sum(d.SLSAMNT)'Total' FROM

 (

  SELECT CUSTNMBR,SLSAMNT FROM RM20101

  WHERE CUSTNMBR...

Hi There,

Yes i did consider it as a comment and also executed, but still gives the same error 🙁

Just for showing as an example i have used the same table...

Thanks Jeff,

But was there any syntactical error in the first query, when i attempt the same its giving error :

                  "Incorrect syntax near 'D' "

Please find below my...

Thanks Mark.

No, I have downloaded RSEVAL.exe from Microsoft website. While running it i'm getting that error

Thanks Hanslindgren

Good Article Vasant, wrote in a very simple and easy way.

I have one doubt here about  sp_xml_preparedocument.

In BOL and also in the mentioned article XML document/content is assigning to a varchar...

Thanks Guys,

For all your replies and answers.

I also found one more way using subQuery, but donno how effective it will be compared to the other ways.

Atlast i found different ways...

Hi,

The below mentioned script might help you to write similar script for generating Where clause Dynamically.

Hope it helps you .

CREATE PROC KTP_WhereClauseForPR

@deptfrom...

Thank You Helen.

Yes Steve,

I have encrypted data in the said Binary column. I'm not even editing any VBScript code generated by it. For converting or casting, where can we edit.. do we...

HI all,

Its almost going to solve my problem, may have to do some modifications according to my requirement.

Thanks Once again.

Subhash

Hi All,

Thanks for all your suggestions.

I will try all of them and get back to you.

Subhash