How to pass month year as parameter in store procedure?

Question

1.00/5 (2 votes)

See more:

I am displaying attendance details of each student on basis of month and year.
I want to display the monthly attendance (one or many months).
In application,i had two text boxes,one for starting month and another for ending month.
I want to pass this two values as parameters.
I want to caluclate the number of days in that month and store in variable,and to display that variable as column in output.
another is to calculate the present days and absent days, and display these two values in separate columns in output.

Posted 23-Nov-15 23:27pm

Hussain Javed

Add a Solution

Comments

George Jonsson 24-Nov-15 5:43am

What is the problem?

Hussain Javed 24-Nov-15 5:49am

I want to display monthly attendance of each student.
I am passing two parameters one start date another end date.
In my table In_time and Out_time columns are there if student in_time is stored in database that means he is present otherwise absent.

[no name] 24-Nov-15 5:45am

What have you tried yet?

Hussain Javed 24-Nov-15 5:52am

how to set condition, In my table, In_time and Out_time columns are there if student in_time is stored in database that means he is present otherwise absent.
these result is stored in variables,i can display as output

F-ES Sitecore 24-Nov-15 5:45am

This is not a question, it is a request for someone to do your work for you. Break each problem down and attempt it yourself and if you have a specific problem then ask a specific question.

Hussain Javed 24-Nov-15 5:50am

how to set condition, In my table, In_time and Out_time columns are there if student in_time is stored in database that means he is present otherwise absent.

1 solution

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)

sanjay243657 · Answer 1 · 2015-11-24T00:32:00

Below are sample procedure it will help you

C#

Create Procedure Usp_SelectStudentPresetDetails
As
@FromDate Datetime,
@EndDate Datetime
Begin

Select StudentName,intime
From TableName 
where DATEDIFF(d,@FromDate,FromDate) >= 0
			  AND DATEDIFF(d,@EndDate,ToDate)<= 0
			  AND intime IS NOT NULL


end