help help help(sql) :(

[ad.hasareli]

I want a help abt sql .I am using SQL Server 2008. I have a table like below

I want output like below

[stdId] [stdmarks]
.1 .........70
.1 .........20
.1 .........40
.1 .........50
.1 .........60
.2 .........25
.2 .........42
.2 .........53
.2 .........89



create query

CREATE TABLE [dbo].[stddtls](
[stdId] [int] NULL,
[stdmarks] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[ami] ([stdId], [stdmarks]) VALUES (1, N'70,20,40,50,60')
INSERT [dbo].[ami] ([stdId], [stdmarks]) VALUES (2, N'25,42,53,89')

 

[ad.hasareli]

bmp

 

[mjayanatha]

select * from tblname order by [stdId] , [stdmarks] ASC

 

[ad.hasareli]

select * from tblname order by [stdId] , [stdmarks] ASC

mehema newei machan mata output aka oni me widihata



[stdId] [stdmarks]
.1 .........70
.1 .........20
.1 .........40
.1 .........50
.1 .........60
.2 .........25
.2 .........42
.2 .........53
.2 .........89

 

[mjayanatha]

mehema newei machan mata output aka oni me widihata



[stdId] [stdmarks]
.1 .........70
.1 .........20
.1 .........40
.1 .........50
.1 .........60
.2 .........25
.2 .........42
.2 .........53
.2 .........89

select * from tblname order by [stdId] ASC

 

[chirart1]

ane manda ohoma ekak dakkamai

sry wenna one danne na uththre

 

[ad.hasareli]

select * from tblname order by [stdId] ASC

hariyanne nehe ban

 

[ad.hasareli]

ane manda ohoma ekak dakkamai

sry wenna one danne na uththre

bump

thnx machnala.... rep+++

 

[mjayanatha]

danui prasne therune poddak inna try ekak dennam

 

[amarawansadinith]

Machan ube thiyena table eke pic ekak dapan..... koi widiyatada table eke data thiyenne???

 

[ad.hasareli]

danui prasne therune poddak inna try ekak dennam

ok machan.....

 

[mjayanatha]

machan ubata thawa temp table ekak hadanna puluwan da?

 

[chathuranga8887]

bump try now

 

[ad.hasareli]

machan ubata thawa temp table ekak hadanna puluwan da?

tawa tble akak hadanne nethuwa wede karanna berida machan ????

 

[mjayanatha]

tawa tble akak hadanne nethuwa wede karanna berida machan ????

puluwan ..mama try ekak dennam

 

[ad.hasareli]

puluwan ..mama try ekak dennam

thnx thnx thnx a lot machan

 

[chathuranga8887]

http://social.msdn.microsoft.com/forums/en-US/transactsql/thread/4126a010-6885-4eb0-b79c-c798c90edb85

 

[ad.hasareli]

http://social.msdn.microsoft.com/fo...l/thread/4126a010-6885-4eb0-b79c-c798c90edb85

 

[ad.hasareli]

 

[ad.hasareli]

bmp