How to make SQL branch wise in SQL server

Question

0.00/5 (No votes)

See more:

, +

I have following Result in sql server From table and table name is DailyCash

Amount Company PaymentMode
88659 Head Office CASH
95879.50 Head Office CREDIT CARD
93.00 Branches CASH
33.50 Branches CREDIT CARD

so i want result like that

Head Office
88659 / Cash
95879 / Credit Card

Branches
93 / cash
33.50 / Credit card

What I have tried:

how i can write sql query for this type of result

Posted 2-Jul-19 23:50pm

Aitzaz Ahsan

Updated 3-Jul-19 0:28am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Accepted Answer · 2019-07-03T00:29:00

SQL

SELECT Amount, PaymentMode FROM DailyCash WHERE Company = 'Head Office';
SELECT Amount, PaymentMode FROM DailyCash WHERE Company = 'Branches';

But ... that's a very poor design. You shouldn't bew sorting "Company" or "PaymentMode" as strings: they should be in two separate tables each with an IDENTITY based ID column which you reference via a Foreign Key from your DailyCash table, via a JOIN.

Doing it your way both wastes space (strings are bigger than IDs) and encourages errors as the string field could be badly entered: 'Heed Office' or 'CEDIT CARD' for example.