473,461 Members | 1,433 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

simple question about sql server and c#

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...
Nov 25 '10 #1
1 1229
code green
1,726 Expert 1GB
How can i do with c# or sql server that count all entries from month begining to end of month ?
Wel a SQL query would be something like
Expand|Select|Wrap|Line Numbers
  1. SELECT COUNT(id) FROM table WHERE date_ent BETWEEN start_date AND end_date
Nov 25 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

10
by: Haris Bogdanovic | last post by:
I'm trying to implement chess server program so I started by implementing simple echo server. When client is trying to connect to the server everything works fine but when server tries to echo...
2
by: Gelo Ilzi | last post by:
I'm trying to implement a very simple http server with cgi functionality. The code is simple: import CGIHTTPServer, BaseHTTPServer httpd = BaseHTTPServer.HTTPServer(('',8000),...
0
by: Jesse Noller | last post by:
Hello - I am looking at implementing a simple SMTP server in python - I know about the smtpd module, but I am looking for code examples/snippets as the documentation is sparse. The server I...
0
by: zoran | last post by:
Hi, I have a simple TCP server client in .net and for some reason the Accept() function in the Server part never gets called and never returns a new socket. This thing has been driving me nuts for...
1
by: lucifer | last post by:
hi, i am creating an simple http server ie it serves only static pages . u can compile the code then use ur browser if it is IE then the it shows the page but the http header is also shown...
2
by: lucifer | last post by:
hi, i am creating an simple http server ie it serves only static pages . u can compile the code then use ur browser if it is IE then the it shows the page but the http header is also shown...
14
by: robert | last post by:
For testing purposes I'm looking for a simple DAV server - best a python thing serving a folder tree. Don't want to install/change/setup the complex apache dav .. Found PyDav...
0
by: Wolfgang Hercker | last post by:
I want to setup a simple web server (not a huge Apache or similar elephant) for which I can setup WAP/WML web pages for mobile phones. In other words it should be possible to add more MIME types...
5
by: Tzury Bar Yochay | last post by:
hi, the following sample (from docs.python.org) is a server that can actually serve only single client at a time. In my case I need a simple server that can serve more than one client. I...
4
by: shreedhan | last post by:
hi i am trying to write a simple client server chat program. the code of server program is: #define PORT 9999 int main() { struct sockaddr_in server_addr,client_addr;
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.