<div>
This fature dosn't exist in SQL server, the easiest way is to attach the &nbsp;table in Access and use it's function<br />

</div>


This fature dosn't exist in SQL server, the easiest way is to attach the  table in Access and use it's function


<div>
A useful procedure for doing this in T-SQL (Microsoft SQL Server) is given on this web page:<br />
<br />
<a href="http://www.sqlteam.com/item.asp?ItemID=2955" rel="ugc">http://www.sqlteam.com/item.asp?ItemID=2955</a>
</div>


A useful procedure for doing this in T-SQL (Microsoft SQL Server) is given on this web page:

http://www.sqlteam.com/item.asp?ItemID=2955 [http://www.sqlteam.com/item.asp?ItemID=2955]

<div>
<div class="content wysiwyg-content">
Is there a comparable function to Access's PIVOT?? I would like to sum all<br />
the records by employee location by Job Title, where i'd be doing a group by Job Title and pivot on Location;<br />
<br />
<br />
JobTitle    LocationA    LocationB    LocationC    Total<br />
Job01            22          22           3<wbr />3         77<br />
Job02            11          10           1<wbr />0         <wbr />31<br />
<br />
etc....<br />
<br />
<br />
ANy help is appreciated greatly..................<br />
<br />
<br />
John<br />
jcorbin@apci.net<br />
<br />

</div>
</div>


Is there a comparable function to Access's PIVOT?? I would like to sum all
the records by employee location by Job Title, where i'd be doing a group by Job Title and pivot on Location;


JobTitle    LocationA    LocationB    LocationC    Total
Job01            22          22           33         77
Job02            11          10           10         31

etc....


ANy help is appreciated greatly..................


John
jcorbin@apci.net



PIVOT Equiv in T-SQL??

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.