Any inputs ?

I strongly suggest the author mentioned Answer is wrong.

It should display all the columns in descending order ,with the mentioned column as first.

I got the following output:

, 05/JAN/2008

My Requirement is

I want to display the row in seperate column.

Ex:

Table Name : Dating

Date

01/JAN/2008

02/JAN/2008

03/JAN/2008

Expected output:

C1 ...

Mahesh,

It is not working.I don't know why ?

Table Structure:

create table Dating

(

Date varchar(25)

)

insert into Dating

select '01/JAN/2008'

union all

select '02/JAN/2008'

union all

select '03/JAN/2008'

union all

select '04/JAN/2008'

union all

select '05/JAN/2008'

Query:

Declare @strSQL VarChar(255)

Select @strSQL = ''

select @strSQL =case...

Hi,

Thanks for your interest.

But it is giving the last row only.

Code:

Declare @strSQL VarChar(255)

Select @strSQL = Case When @strSQL is null then Date else @strSQL + ' ' + Date End

From...

I think we can't use CASE statement. Because we don't know the exact row count.

Note:

The output should be stored in each column.

I found one solution,But i don't know whether it is correct or not.

-----------------------------------------------------------------

create table Dating

(

Date varchar(25)

)

insert into Dating

select '01/JAN/2008'

union all

select '02/JAN/2008'

union all

select '03/JAN/2008'

union all

select '04/JAN/2008'

union all

select '05/JAN/2008'

--drop table #Dating

Select ID...

char :

Fixed-length non-Unicode character data with a maximum length of 8,000 characters.

varchar :

Variable-length non-Unicode data with a maximum of 8,000 characters.

If you post the error message,then you will...

You are correct ! Thanks !

I have used the following code to find out the columns and Datatypes of all the tables for a DB.

Code:

-------------------------

Create table #Tables

(

ID numeric identity,

name varchar(75)

)

Create Table #FinalResult

(

TableName varchar(75),

ColumnName varchar(50),

DataType varchar(50)...

Any inputs ?

Gila,

As you suggest i used sysindexes table.

Code:

select Name,Count = RowCnt

from sysobjects a,sysindexes b

where a.id = b.id

and a.type = 'U'

and a.name not in ('dtproperties')

It works fine in sqlserver2000.But i will have...

----------------------------------------

------------------------------------------

Can you tell me why ?

I am using sql2000. But most of the tables doesn't created with proper index.Thats why i...

It's in Euro's not in Pound's.

Please give me your feedback.

Thanks.

They will give `480 perday and for administration(like accomadation etc.,)they will take `350 per month.

please give me your feedback.