We are using the below table to display data in a GridView:

-- Create a Demo Database

create database crosstab_demo

GO

use crosstab_demo

GO

-- Create a demo Table

create table demo1

(

field_id int IDENTITY(10000,1) CONSTRAINT [PK_field]...

We are sorry for the confusion created.

Below is the html code which you can save as a HTML file and view it in your Internet Browser which demonstrates how exactly...

Jeff

Thanks for the prompt reply.

But it seems u have misunderstood my post.

The "pipe" used in the post is just for structuring the data in a table format.

Kindly execute the query...