Click here to Skip to main content
15,170,096 members
Home / Discussions / Database
   

Database

 
GeneralRe: Database SQL Pin
Syafiqah Zahirah11-May-14 4:43
MemberSyafiqah Zahirah11-May-14 4:43 
AnswerRe: Database SQL Pin
Peter Leow11-May-14 5:13
professionalPeter Leow11-May-14 5:13 
GeneralRe: Database SQL Pin
Syafiqah Zahirah11-May-14 5:45
MemberSyafiqah Zahirah11-May-14 5:45 
GeneralRe: Database SQL Pin
Syafiqah Zahirah15-May-14 7:50
MemberSyafiqah Zahirah15-May-14 7:50 
GeneralRe: Database SQL Pin
Peter Leow15-May-14 15:47
professionalPeter Leow15-May-14 15:47 
QuestionArithmetic rounding Pin
Richard.Berry1009-May-14 12:04
MemberRichard.Berry1009-May-14 12:04 
AnswerRe: Arithmetic rounding Pin
Richard Andrew x649-May-14 13:26
professionalRichard Andrew x649-May-14 13:26 
GeneralRe: Arithmetic rounding Pin
Richard.Berry1009-May-14 21:58
MemberRichard.Berry1009-May-14 21:58 
Hi Richard

Thanks for your reply. In my case here, a customer was requesting a Purchase Order in pdf format, as well as Excel format. I was doing the rounding with a formula in Excel, but the formula did not always fill down to all the rows of the table which is why I decided to do the rounding in the query.

Also, quite often, in Winform apps, I pull a query into a DataTable, and set the DataTable as a DataGridView DataSource, in which case it seems more practical to do the rounding in the query as opposed to looping through the DataTable, and adding the rows with the rounded value to the DataGridView?
AnswerRe: Arithmetic rounding Pin
Andrius Leonavicius9-May-14 16:02
professionalAndrius Leonavicius9-May-14 16:02 
GeneralRe: Arithmetic rounding Pin
Richard.Berry1009-May-14 21:45
MemberRichard.Berry1009-May-14 21:45 
GeneralRe: Arithmetic rounding Pin
Andrius Leonavicius10-May-14 5:28
professionalAndrius Leonavicius10-May-14 5:28 
QuestionFetch records efficiently Pin
avi_dadi20029-May-14 10:15
Memberavi_dadi20029-May-14 10:15 
AnswerRe: Fetch records efficiently Pin
Richard Andrew x649-May-14 11:30
professionalRichard Andrew x649-May-14 11:30 
AnswerRe: Fetch records efficiently Pin
Richard MacCutchan9-May-14 22:49
mveRichard MacCutchan9-May-14 22:49 
QuestionNeed to fetch from two data sources Pin
avi_dadi20029-May-14 10:11
Memberavi_dadi20029-May-14 10:11 
AnswerRe: Need to fetch from two data sources Pin
Richard.Berry1009-May-14 22:40
MemberRichard.Berry1009-May-14 22:40 
QuestionSSAS Cube Pin
Mycroft Holmes6-May-14 15:42
professionalMycroft Holmes6-May-14 15:42 
QuestionNeed help in forming a query Pin
Member 99559846-May-14 1:07
professionalMember 99559846-May-14 1:07 
AnswerRe: Need help in forming a query Pin
Richard MacCutchan6-May-14 1:21
mveRichard MacCutchan6-May-14 1:21 
Questionlogin and logout differenece at back end Pin
Syed Rehman5-May-14 19:59
MemberSyed Rehman5-May-14 19:59 
AnswerRe: login and logout differenece at back end Pin
Mycroft Holmes5-May-14 20:20
professionalMycroft Holmes5-May-14 20:20 
QuestionMigration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 8:48
MemberKala Vairakkannu5-May-14 8:48 
AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
ZurdoDev5-May-14 10:36
professionalZurdoDev5-May-14 10:36 
QuestionMigration error from SQL 2014 to SQL 2012 Pin
Kala Vairakkannu5-May-14 8:27
MemberKala Vairakkannu5-May-14 8:27 
AnswerRe: Migration error from SQL 2014 to SQL 2012 Pin
Kornfeld Eliyahu Peter5-May-14 8:34
professionalKornfeld Eliyahu Peter5-May-14 8:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.