Sql 2 values in to one

Asked Jul 15 '16 at 11:30

Active Jul 15 '16 at 11:30

Viewed 41 times

I have a query below:

SELECT distinct CBP.Liability 
FROM Markets M 
INNER JOIN BetTransaction B ON B.MarketId = M.MarketId AND BetSize > 0
OUTER APPLY
(
    SELECT ISNULL (min(Liable),0) AS Liability FROM ClientBetPosition WHERE MarketId = M.MarketId AND ClientId = 349
) AS [CBP]
WHERE M.MarketId NOT IN (SELECT MarketId FROM Transactions WHERE MarketID IS NOT NULL)
AND B.ClientId = 349

Which is showing me result of 1 column and 2 rows, i need to add them in to one row

edited Jul 15 '16 at 11:30

Tim Schmelter

450,073
74
686
939

asked Jul 15 '16 at 11:30

Muhammad Mutahar

please provide expected result and actual result – TheGameiswar Jul 15 '16 at 11:34
Please sometime use google.... http://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string – xdd Jul 15 '16 at 12:00
sorry to bother you all it is soo simple i just need to edit first line SELECT sum (distinct CBP.Liability ) – Muhammad Mutahar Jul 15 '16 at 12:13

Sql 2 values in to one

0 Answers0