Sorry...

In the above reply example I wanted to give like this

DECLARE @sql NVARCHAR(100)

DECLARE @where NVARCHAR(30)

DECLARE @parameter INT = NULL

SET @sql = 'hello'

IF @parameter is not null

BEGIN

SET @where = @where +...

Gila I do agree with you.

But he has declared @WHERE and assume the first parameter value is not null , the the statement is

SET @WHERE = @WHERE + 'something'

I...

Hi dso808,

Also you have to initialize @Where NVARCHAR(4000) to ' ' otherwise the

entire string will be NULL.

Hi Craig,

Thanks a lot for the detailed reply,either of the above method should solve the issue.

Friends,

My doubt was related to this post thats why I have asked it in this thread itself rather than creating a new, I have seen when some one is...

Hi Gila,

I would like to know something more related to this. I have some applications which are still using

SQL 2000 !!!! , and my understandings are:

1)VARCHAR(max) / NVARCHAR(max) is...

Hi Neharika,

Also you can go through the below link, same question was discussed already. And at the end you can see how to do this in SSRS 2008.

http://www.sqlservercentral.com/Forums/Topic490774-147-1.aspx

Special thanks to...

Thanks Gila,

I understood, and sql-injection your blog was good.

Hi Gila,

Yes and no. There's no need to deal with the conversions to varchar and concatenations into the string that is been done here if sp_executesql is used with parameters....

Thanks Daniel,

Why I asked was , when I make "Keep With Group " = Before/None , the column header was not repeasting to all the pages, it was comming only...

Thanks Daniel,

When I tried the option you have mentioned it worked, with making "Keep With Group " Option = After

Can I know what is the significance of "Keep...

Hi,

Can you try with a page break for the List?

Thats correct 🙂

Thanks Peter, one more question, in the tablix property I have checked the "Repeat row header , Repeat column header " but the Column header is coming...

Hi I think if you write like this it will help you:

ALTER PROCEDURE [dbo].[PTicketSearch]

(

@StartDate datetime,

@EndDate datetime,

@Submitter varchar(100),

@Assigned varchar(100),

@status varchar(10)

)

AS

BEGIN

DECLARE @sql VARCHAR(MAX)

SET @sql = ' SELECT * FROM PROBLEMTICKET WHERE...

Thank you so much Peter,

Yes you are correct I have done it like that, leaving the "=" sign there, now I have deleted the entire row then it worked!!!!

One more...