<div>
I first part was achieved by the following query<br />
SELECT USER_REGISTRATION_ID,Sum(U<wbr />SER_REGIST<wbr />RATION_ID)<wbr /> FROM NOTIFYDEALS_LOGISTICS_VIEW<wbr /> GROUP BY USER_REGISTRATION_ID<br />
but how do i get the remainder of the column and still show the aggregrate
</div>


<div>
I have 3 records and all the record show up but i do not see the count showing up with the right value. Since all the 3 records are for the same USER, (ie USER_REGISTRATION_ID =1)<br />
the resultant should be 3 records showing the count column value (ie idcnt) as 3.<br />

</div>


<div>
<div class="content wysiwyg-content">
I have a sql statement as follows:<br />
<br />
SELECT USER_REGISTRATION_ID,DEALS<wbr />_NAME,VEND<wbr />OR_NAME,PR<wbr />OCESS_DATE<wbr /> FROM NOTIFYDEALS_LOGISTICS_VIEW<wbr /> GROUP BY USER_REGISTRATION_ID<br />
<br />
I wish to get the following output.<br />
<br />
Generate a list that is grouped by user_registeration &nbsp;and get the total count (based on the no of occurrance of the user_registration-id in the table), Also i wish to retrieve the remaider of the columns.<br />
<br />

</div>
</div>


I have a sql statement as follows:

SELECT USER_REGISTRATION_ID,DEALS_NAME,VENDOR_NAME,PROCESS_DATE FROM NOTIFYDEALS_LOGISTICS_VIEW GROUP BY USER_REGISTRATION_ID

I wish to get the following output.

Generate a list that is grouped by user_registeration  and get the total count (based on the no of occurrance of the user_registration-id in the table), Also i wish to retrieve the remaider of the columns.



I first part was achieved by the following query
SELECT USER_REGISTRATION_ID,Sum(USER_REGISTRATION_ID) FROM NOTIFYDEALS_LOGISTICS_VIEW GROUP BY USER_REGISTRATION_ID
but how do i get the remainder of the column and still show the aggregrate

I have 3 records and all the record show up but i do not see the count showing up with the right value. Since all the 3 records are for the same USER, (ie USER_REGISTRATION_ID =1)
the resultant should be 3 records showing the count column value (ie idcnt) as 3.


Help with Group By clauses

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.