Select in a view for more result

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Select in a view for more result

Select in a view for more result

Rate Topic

Display Mode

Topic Options

Author

Message

mhmdsow

Posted Saturday, March 23, 2013 7:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 9:40 AM
Points: 2, Visits: 4

hy !
There is my view
mvtDtate mvtMouvementDebCred TypemvtMouvementDebCred
1/1/2013 154 000 D
2/1/2013 210 000 C
3/1/2013 654 012 D
4/1/2013 213 000 564 C
After more essay : And I want a result as this : the mvtMDebCred type D in a Columm and the same for the type C
mvtDtate mvtMDebCred mvtMDeb mvtMCred TypemvtMDebCred
1/1/2013 154 000 154 000 ----------- D
2/1/2013 210 000 ----------- 210 000 C
3/1/2013 654 012 654 012 ---------- D
4/1/2013 213 000 ----------- 213 000 564 C
thanks ........

Post #1434605

opc.three

Posted Saturday, March 23, 2013 8:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:55 PM
Points: 6,720, Visits: 11,759

mhmdsow (3/23/2013)

What you have posted is difficult to read and does not make it easy for people to help you by allowing them to run tests against your data on their own instance SQL Server. For better, faster answers please provide:

1. DDL in the form of CREATE TABLE statements to create your sample tables
2. DML in the form of INSERT INTO statements to populate the sample tables
3. Your expected result based on your sample data
4. Most importantly: what you have tried so far

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1434616

mhmdsow

Posted Monday, March 25, 2013 9:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 25, 2013 9:40 AM
Points: 2, Visits: 4

hy , thanks members
my problems is resolved ...
there is my query :

SELECT mvtDtate
, mvtMDebCred
, CASE WHEN TypemvtMDebCred = 'D' THEN mvtMDebCred END AS mvtMDeb
, CASE WHEN TypemvtMDebCred = 'C' THEN mvtMDebCred END AS mvtMCred
, TypemvtMDebCred
FROM ...

Post #1434993

« Prev Topic | Next Topic »

Permissions