Just a piece of advice: Always its a good practice if you can post the code for creating objects and data. That way, it will be easy for every one...

-- Not sure what the Business requirement is but for you to get the output as TRUE, use this:

DECLARE @req_1 varchar(50)

DECLARE @req_2 varchar(50)

set @req_1='AAM'

set @req_2='VVE'

if (@req_1 ='AAM' OR @req_2 ='VVE')

print...

Thanks a lot friend. It worked like a charm.

Thanks a lot guys for quick reply.

What does PosNo Stands for in your Code below?

on c2.PosNo = c1.PosNo

Thanks a lot Jeff. Really helpful and you saved 2 days of my time ..

Very well written.

We have Sql 2008 and the operations we are doing right now can also be done with SQL 2005. I am sure Microsoft will come up with SQL 2014 in...

Thanks Lynn. Good solution. I will follow that.

Thanks Lynn for the quick reply. Will there be any performance difference between the two. Meaning 1) having more columns in the table VS parsing a single column?

Guys, I got it . Never mind.

Thanks

This might help you partially: please go through the links below.

http://stackoverflow.com/questions/2592300/filler-dots-for-table-of-contents-in-reporting-services

http://www.bidn.com/blogs/Anil/ssas/1441/sql-server-reporting-services-generating-manual-table-of-content-toc-for-pdf-report-output

I found this video too: http://www.youtube.com/watch?v=fWPrbOOBod4

Thanks Gail, SScoach and Nate. I will choose 95 as my initial FF.

If I see any page splits down the road, I would go down to 90 and...

Thanks Gail Shaw for the quick reply.

I have read the article below and concluded 100% fill factor on Tables with Clustered Index on Identity Column: So, I thought...