Hi..

Thanks for thea bit of useful tip.

I modified the query like this and the rows getting divided into 5 perfectly...

SELECT

[SequenceNumber]

,[SampleColumn] = 'Sample' + CONVERT(VARCHAR(10),(([SequenceNumber] /...

NTILE just divides the dataset into the given number in NTILE(int) accordingly. But i want to divide the dataset (whatever lines there may be) to 5 - 5 rows..

Hey, it returned duplicate values. distinct did not work. so I wrote like this :

WITH mytable

AS (SELECT DISTINCT CONVERT(VARCHAR(6), DATE, 112) AS MONTH

...

Thanks both of you for youe response....

VbCRLF worked for me.:-)

Hi guys..

Thanks for the responses.

I have dealt it with Unpivot-ing the table. I converted all the required fields into one column and the corresponding values to another column. And...

Yeah..am using SSRS

Exactly what u had assumed/ understood.

I want to build a report that shows a table of user selected columns from a list of available columns..

How do you do...

Thanks for the efforts..

I have fixed it up by using unpivot.. Thanks lutz for the spark.

Suggestions??

Hi LutZ

Thanks for the response.

I had created the table manually in access. I have jus ported the replica of the access table in SQL server.

The table looks something like this.

Area...

Hi Lutz..

Thanks for the response..

Hi..

Thanks for the response.

But then i had already mentioned that i want to find the fields and not values in the fields.

select * from mytable

where myfield in (@parameter)...