Kent,

Thanks for your prompt reply. Carry on !

I think it won't work in Sql2000. I am using sql2000.

John Thanks.

But they dont have the option to choose the table name. Only Drop down box will show the list of columns. In that case, i think we need to...

They will choose it from a dropdown list.

It Would be highly appreciable if anybody help me to solve my issue.

Thanks Ryan.

Again i want to add some more logics.

Suppose if any user want to add a new column in the select list,our query has to do it.

Say for example,

ID ...

But Andras i dont want to use any functions. Because i dont have the permission to create functions.

Or you can modify your code little.

Hi All,

Any ideas why this always returns NULL? Help would be greatly appreciated!

DECLARE @Count int

DECLARE @sql NVARCHAR(2000)

SET @Count = 1

WHILE @Count < 20

...

I am using sql2000.

But i dont want to use while loop or Cursor. I want to acheive it by using SET BASED logic.

Can anybody help me ?

Ok.

FOR EXAMPLE,

Create table ColumnDesc

(

ID int,

ColumnList varchar(4000)

)

Insert into ColumnDesc

Select 1,'Select A.Eno,B.Salary,C.Dept from Emp A,Payroll B,Department C'

Union All

Select 2,'Select A.Eno,A.Ename,B.Dob from Emp A,Payroll B'

Union All

Select 3,'select A.Eno,A.Ename,A.Address,A.Email,B.Salary,B.DOB,C.Dept,D.Remarks from Emp A,Payroll B,Department...

Any input?

Ryan,

Thanks.But you have hardcoded it as a seperate string. But i don't want to hard code it.

Because it may change in future like From Company A,Department B,Employee C,EmpHistory D...

Any inputs will be highly appreciated.

Andras,

Concur.

Any Inputs ?