<div>
<div class="content wysiwyg-content">
I have a stored procedure that returns 12 rows each time I run it. &nbsp;The database was designed that it is storing a record for each Month in rows for example:<br />
<br />
Table: &nbsp;MonthAmounts<br />
Fields:<br />
MonthID, &nbsp; &nbsp;MonthAmt<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5.00<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10.00<br />
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17.50<br />
4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.50<br />
......<br />
<br />
I want to get everything in one row if possible. &nbsp;I will always be pulling 12 rows. &nbsp;Do I have to write a cursor to handle this or can I get it all into 1 record across for all months? &nbsp;Thanks
</div>
</div>


I have a stored procedure that returns 12 rows each time I run it.  The database was designed that it is storing a record for each Month in rows for example:

Table:  MonthAmounts
Fields:
MonthID,    MonthAmt
1               5.00
2               10.00
3               17.50
4                 3.50
......

I want to get everything in one row if possible.  I will always be pulling 12 rows.  Do I have to write a cursor to handle this or can I get it all into 1 record across for all months?  Thanks

SQL Statement using Case

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.