Click here to Skip to main content
12,290,956 members (46,218 online)
Rate this:
 
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 1-Feb-13 0:40am
   
@SANTOSH:THNX ALOT SIR
Santhosh Kumar J 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160518.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2016
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