Click here to Skip to main content
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 OriginalGriff 404
1 Nirav Prabtani 268
2 _Amy 230
3 CHill60 170
4 Sergey Alexandrovich Kryukov 166
0 OriginalGriff 8,004
1 Sergey Alexandrovich Kryukov 7,017
2 Maciej Los 4,039
3 Peter Leow 3,738
4 CHill60 2,912


Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2014
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