Concat symbol % with Result - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Concat symbol % with Result

Author

Topic

taj
Starting Member

39 Posts

Posted - 2013-08-30 : 03:28:41

Hi all,

SELECT ROW_NUMBER() OVER (ORDER BY BM.BILL_NUMBER_V) AS [SL_NO],PP.KID_ID_NO_V AS [KID_NO],(PP.FIRSTNAME_V + SPACE(1) + PP.LASTNAME_V)AS [PATIENT_NAME],
CONVERT(VARCHAR(10),PP.UPDATEDDATE_D,101)AS [VISIT_DATE],BM.BILL_NUMBER_V AS [BILL_NUMBER],CONVERT(VARCHAR(10),BM.BILL_DATE_D,101) AS [BILL_DATE],
ROUND(BM.BILL_AMOUNT_M,2) AS [BILL_AMOUNT],ROUND(BM.CONCESSION_AMOUNT_M,2) AS [CONCESSION_AMOUNT],ROUND(BM.TOTAL_AMOUNT_M,2) AS [TOTAL_AMOUNT],
ROUND(BM.CONCESSION_AMOUNT_M * 100/BM.BILL_AMOUNT_M,2) AS [PERCENTAGE],CASE WHEN BM.BILL_REMARKS_V IS NULL THEN ' ' ELSE BM.BILL_REMARKS_V END AS [CONCESSION_REASON]
FROM BILL_MASTER BM
INNER JOIN PATIENT_PROFILE PP ON BM.PATIENT_ID_N=PP.PATIENT_ID_N
INNER JOIN PATIENT_REGISTRATION PR ON PP.PATIENT_ID_N=PR.PATIENT_ID_N
WHERE BM.BILL_SETTLED_C='Y'
AND BM.BILL_CANCELLED_C='N'
AND BM.BILL_AMOUNT_M IS NOT NULL
AND BM.TOTAL_AMOUNT_M IS NOT NULL
AND BM.CONCESSION_AMOUNT_M >0.00

In the above query i want to concat symbol '%' for output of percentage column. How to do that?

Eg: PERCENTAGE
30.00%
50.00%

Thank You

waterduck
Aged Yak Warrior

982 Posts

Posted - 2013-08-30 : 04:00:06

[code]SELECT
ROW_NUMBER() OVER (ORDER BY BM.BILL_NUMBER_V) AS [SL_NO]
, PP.KID_ID_NO_V AS [KID_NO]
, (PP.FIRSTNAME_V + SPACE(1) + PP.LASTNAME_V)AS [PATIENT_NAME]
, CONVERT(VARCHAR(10),PP.UPDATEDDATE_D,101)AS [VISIT_DATE]
, BM.BILL_NUMBER_V AS [BILL_NUMBER]
, CONVERT(VARCHAR(10),BM.BILL_DATE_D,101) AS [BILL_DATE]
, ROUND(BM.BILL_AMOUNT_M,2) AS [BILL_AMOUNT]
, ROUND(BM.CONCESSION_AMOUNT_M,2) AS [CONCESSION_AMOUNT]
, ROUND(BM.TOTAL_AMOUNT_M,2) AS [TOTAL_AMOUNT]
, CONVERT(VARCHAR(18), ROUND(BM.CONCESSION_AMOUNT_M * 100/BM.BILL_AMOUNT_M,2)) + '%' AS [PERCENTAGE]
, CASE WHEN BM.BILL_REMARKS_V IS NULL THEN ' ' ELSE BM.BILL_REMARKS_V END AS [CONCESSION_REASON]
FROM BILL_MASTER BM

INNER JOIN PATIENT_PROFILE PP ON BM.PATIENT_ID_N=PP.PATIENT_ID_N
INNER JOIN PATIENT_REGISTRATION PR ON PP.PATIENT_ID_N=PR.PATIENT_ID_N

WHERE BM.BILL_SETTLED_C='Y'
AND BM.BILL_CANCELLED_C='N'
AND BM.BILL_AMOUNT_M IS NOT NULL
AND BM.TOTAL_AMOUNT_M IS NOT NULL
AND BM.CONCESSION_AMOUNT_M >0.00[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources