Here is a very detailed description: this date only 1 table
custcode cust1 cust1, Cebu city Cust1 general
In my report I have to keep this report in my report viewer
Customer's name Location 1 Location 2 Location 3 cust1 capital, cebu city general
< Div> Itemprop = "text">
If you have a location field that you have not shown to us that can differentiate the prefix What does it mean to go to the column?
select the custcode, MAX (case when location = 1 THEN address END) position 1, max (position in position = 2 then address END) place 2 Custom code by X Group from location 3 as Max (in case case = 3 then address END) If you are relying on a SQL Server specific answer line command.
It assumes that you have an ID field, from which the order of the "first" row can be calculated. CUSTOM CODE, AS 'SELECT 1 AS ID,' CUST1 'AS CUSTCODE,' CAPITAL, CABU CITY 'AS UNION ALL CUSTOMERS AS 2 AS ID,' cust1 ', with' x ' General Maxilom, Cebu City 'AS Address Union All 3 AS ID,' cust1 'as custcode,' guadalupe, cebu city 'as address Union all association 4s id,' custom 2 'passport of AS,' Pekanan , As the address of 'Mandey City', select Union All 5 AS ID, 'Custom 2' ASCXcode, 'Besak, Mandye City', as the address of the Union All No 6 AS ID, 'Cust 2' AS Kotakcode, 'Lapu-Lapu City'), YAS (Select ROW_NUMBER ()) (address from RI, CORX, XER) (Exchange as per compliance order ID) Select [1], AS space 1, [2] AS space 2, [3] as place 3 to Y PIVOT (Max (address) for RNI ([1], [2], [3])) A. P. Pitotable;
Comments
Post a Comment