simple question about sql server and c#

Question

0.00/5 (No votes)

See more:

, +

Hi everybody.
I cant ponder how to do that. We have clients who use our transportation service. I constructed sql server table with name Debt its relationed with transportation ID and client ID. Clients always pay money at end of month. How can i do with c# or sql server that count all entries from month begining to end of month ?
Sorry for my bad English.
I hope that my question is understandable.
Please Advice me something...

Posted 24-Nov-10 22:09pm

lester555

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Toniyo Jackson · Answer 1 · 2010-11-24T22:20:00

Solution 1

As i understand ur question,

Select count(*) from tablename where paidDate >= '01/11/2010' and paidDate <= '30/11/2010'

Posted 24-Nov-10 22:20pm

Toniyo Jackson

Sandeep Mewara · Answer 2 · 2010-11-24T22:22:00

Well, first of all design the datavase tables such that you can capture all data.

For now, assuming once a transporationID is related to a ClientID, whole month is used. It would give something like, transportation cost of that transportationID * 30 days!

Thus, to be generic, you need to capture all the used days with cost and then at the end write a query for that client and get all data.

Toniyo Jackson · Answer 3 · 2010-11-24T22:49:00

Solution 4

First u get the last month amount and keep it in one variable,

Select Sum(amount) from tablename where paidDate >= '01/11/2010' and paidDate <= '30/11/2010'

then,

insert into tablename(remain_amount) values(last_amount - 1000)

1000 is the currenty entered amount.

Posted 24-Nov-10 22:49pm

Toniyo Jackson

Updated 24-Nov-10 22:55pm

v2

lester555 · Answer 4 · 2010-11-24T22:40:00

Solution 3

Thanks guys
but I forgot to say that operator who use this application at the end of month will input integers which must Subtraction that value which is from month to month

Posted 24-Nov-10 22:40pm