SQL Server database programming

Hello, I have a stored procedure that gets it's data from a View in SQL server: Select "WO Number", "Part Number", "Complete Date", "WO Quantity" Where [Work Center] Like @WorkCenter Order By [Complete Date] ASC I have code in my client app that returns this as a recordset. ...

Hello there I have some quries that do distinct part of some data I'm wondering in this case what is better: select distinct ... from ... or select .... from group by ... ...

Hello: The following is a formula that I created in SQL to add the payment/credit memo amount, discount taken amount, and the write-off amount of each invoice as a column that I call "TOTAL CREDITS": COALESCE(RM20201.APPTOAMT, '0') + COALESCE(RM20201.DISTKNAM, '0') + ...