Click here to Skip to main content
16,006,442 members
Home / Discussions / C#
   

C#

 
AnswerRe: Current Date and Time Pin
CWIZO7-Mar-06 2:48
CWIZO7-Mar-06 2:48 
QuestionControl for Main Button Window Pin
jahangir70007-Mar-06 0:01
jahangir70007-Mar-06 0:01 
AnswerRe: Control for Main Button Window Pin
Steve Hansen7-Mar-06 0:44
Steve Hansen7-Mar-06 0:44 
GeneralRe: Control for Main Button Window Pin
jahangir70009-Mar-06 20:09
jahangir70009-Mar-06 20:09 
QuestionC# Webservice Pin
H he el el oooo6-Mar-06 23:35
H he el el oooo6-Mar-06 23:35 
AnswerRe: C# Webservice Pin
Steve Hansen7-Mar-06 0:45
Steve Hansen7-Mar-06 0:45 
GeneralRe: C# Webservice Pin
H he el el oooo13-Mar-06 16:55
H he el el oooo13-Mar-06 16:55 
QuestionProcedure Pin
Support1236-Mar-06 23:31
Support1236-Mar-06 23:31 
Hi All,


I'm having trouble putting my question into words, so if it sounds funny, i'm sorry. But here goes...


I've created a View in SQL that contains all the info i need from the different tables i have. The view contains Example:

TransactionDate, StaffID, StaffName, BrandID, BrandName, TotalCash, TotalQty


2006/03/01, 1, Jan, 2, Loreal, 250, 10
2006/03/01, 1, Jan, 3, Kerastase, 200, 8
2006/03/01, 2, Koos, 1, Revlon, 200, 11
2006/03/01, 2, Koos, 2, Loreal, 290, 12
2006/03/02, 1, Jan, 1, Revlon, 500, 25
2006/03/02, 1, Jan, 3, Kerastase, 345, 15
2006/03/03, 1, Jan, 3, Kerastase, 100, 6
2006/03/04, 2, Koos, 1, Revlon, 120, 3


With this examle jou see that i've calculated the totals on the TransactionDate for each Staffmember for each Brand.

I want to know if it is possible to write a procedure in SQL and send from C# a DateValue and BrandID to SQL to let the procedure know that it should only do the calculation between a specified Date and on every Brand. I need One total for each brand between the specified date: example 2006/03/01 - 2006/03/03.

I can do the calculation in C# but i need to speed up the processing time by using the database to do the calculation and not the application we wrote. Would Using a procedure in SQL actually speed up the Process or Would our application still run more or less the same time because it has to send a value to the database and wait for the calculation to complete and get the Value back from the Database?

I need to know rather urgantly Please. Thank you in advance.
AnswerRe: Procedure Pin
goyal manish6-Mar-06 23:52
goyal manish6-Mar-06 23:52 
GeneralRe: Procedure Pin
Support1236-Mar-06 23:55
Support1236-Mar-06 23:55 
AnswerRe: Procedure Pin
Guffa7-Mar-06 0:20
Guffa7-Mar-06 0:20 
QuestionTextBox Array in WebApplications ??? Pin
Abubakarsb6-Mar-06 23:22
Abubakarsb6-Mar-06 23:22 
AnswerRe: TextBox Array in WebApplications ??? Pin
Ingo7-Mar-06 0:31
Ingo7-Mar-06 0:31 
GeneralProblem is still There.... Pin
Abubakarsb7-Mar-06 22:22
Abubakarsb7-Mar-06 22:22 
AnswerRe: TextBox Array in WebApplications ??? Pin
darkelv7-Mar-06 0:48
darkelv7-Mar-06 0:48 
AnswerRe: TextBox Array in WebApplications ??? Pin
Chandana Subasinghe7-Mar-06 0:56
Chandana Subasinghe7-Mar-06 0:56 
QuestionHow to access TextBox Array in WebApplications ??? Pin
Abubakarsb6-Mar-06 23:19
Abubakarsb6-Mar-06 23:19 
QuestionHow to access TextBox Array in WebApplications ??? Pin
Abubakarsb6-Mar-06 23:17
Abubakarsb6-Mar-06 23:17 
Questionerror handling Pin
fmardani6-Mar-06 22:51
fmardani6-Mar-06 22:51 
AnswerRe: error handling Pin
albCode6-Mar-06 23:53
albCode6-Mar-06 23:53 
AnswerRe: error handling Pin
Le centriste7-Mar-06 3:02
Le centriste7-Mar-06 3:02 
QuestionHow to retrieve contacts list other Outlook user Pin
alexandrelupov6-Mar-06 22:42
alexandrelupov6-Mar-06 22:42 
QuestionDrawing in a web form Pin
Rohit Dev6-Mar-06 22:23
Rohit Dev6-Mar-06 22:23 
AnswerRe: Drawing in a web form Pin
lmoelleb6-Mar-06 23:12
lmoelleb6-Mar-06 23:12 
GeneralRe: Drawing in a web form Pin
Rohit Dev7-Mar-06 0:52
Rohit Dev7-Mar-06 0:52 

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.