<div>
I am not able to follow it. could u pls help me.<br />
<br />
thanks<br />
<br />
ayha
</div>


I am not able to follow it. could u pls help me.

thanks

ayha

<div>
let's see with a non-dynamic version<br />

<pre><code id="code-7956464">SELECT PartNo  
     , PartName
     , s1
     , s2
  FROM ( SELECT p.partno, p.partname, s.stockno, sum(s.saleamount) sales_amount
           FROM partstable p
           LEFT JOIN SalesTable s
             ON p.partno = s.partno 
          GROUP BY p.partno, p.partname, s.stockno
        ) p
    PIVOT ( SUM(sales_amount)
             FOR StockNo IN ([s1],[s2] )
           ) AS pvt</code></pre>
</div>


let's see with a non-dynamic version


SELECT PartNo  
     , PartName
     , s1
     , s2
  FROM ( SELECT p.partno, p.partname, s.stockno, sum(s.saleamount) sales_amount
           FROM partstable p
           LEFT JOIN SalesTable s
             ON p.partno = s.partno 
          GROUP BY p.partno, p.partname, s.stockno
        ) p
    PIVOT ( SUM(sales_amount)
             FOR StockNo IN ([s1],[s2] )
           ) AS pvt

<div>
<div class="content wysiwyg-content">
I have &nbsp;the folloiwng table structure<br />
<br />
partstable<br />
partno (PK) partname<br />
P101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; part1<br />
<br />
stocktable<br />
partno (PK) storeID(PK) &lt;---Combined PK stock<br />
P101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100<br />
p101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50<br />
<br />
How can I retrive all rows from store stocktable and related records from partstable? I want the result as follows<br />
<br />
PartNo &nbsp;partname &nbsp; s1 &nbsp; s2<br />
P101 &nbsp; &nbsp; &nbsp; part1 &nbsp; 100 &nbsp; 50<br />
<br />
pls. help<br />
<br />
ayha
</div>
</div>


I have  the folloiwng table structure

partstable
partno (PK) partname
P101           part1

stocktable
partno (PK) storeID(PK) <---Combined PK stock
P101             s1                        100
p101             s2                         50

How can I retrive all rows from store stocktable and related records from partstable? I want the result as follows

PartNo  partname   s1   s2
P101       part1   100   50

pls. help

ayha

SQL command

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications