Click here to Skip to main content
11,647,828 members (60,242 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
i have two columns in sqlserver in a table columns names are receiptno and amount.
if i have two receiptno's and amounts 200 and 300.now i want receiptno=2,3
and amount=500 how it can be possible.please help me as soon as possible
Posted 31-Jan-13 17:40pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Query:


SELECT  STUFF(
               (SELECT      ',' + Cast (recno as varchar(10))
               FROM     test
               FOR XML PATH('')), 1, 1, '') AS RecceiptNumbers,sum(amount) FROM test



My table structure
create table test
(recno int,
amount decimal)
 
INSERT INTO test VALUES (3,300)
 
SELECT  STUFF(
               (SELECT      ',' + Cast (recno as varchar(10))
               FROM     test
               FOR XML PATH('')), 1, 1, '') AS RecceiptNumbers,sum(amount) FROM test
  Permalink  
v3
Comments
er.deepshikha at 1-Feb-13 0:40am
   
@SANTOSH:THNX ALOT SIR
Santhosh Kumar J at 1-Feb-13 0:41am
   
ya welcome

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 jyo.net 500
1 F-ES Sitecore 410
2 DamithSL 290
3 CPallini 290
4 OriginalGriff 277
0 OriginalGriff 1,342
1 jyo.net 994
2 DamithSL 971
3 Sergey Alexandrovich Kryukov 873
4 CPallini 845


Advertise | Privacy | Mobile
Web01 | 2.8.150804.4 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100