Yes here ClassAttendanceDate vary according to months.

Ok but for Deleting the record it requires atclAttendanceClassId and atstAtclId.

For Example :

I've to write delete query inside catch block :

"Delete From tblAttendanceStudents Where atstAtclId = 34"

But if error...

This is just a small DataSet where I'm using .NET code to extract it.

Now I want to delete the data using StateId.

Thanks

ok Thanks

Yes Its lil bit Closer...

Can you tell me how and from where to start second transaction ?

As there is another If - else inside Else If Statement.

Here I'm inserting records...

Thanks for your Effort....

The logic of stored procedure is simple. I request to go through the meaning of tables.

I'm inserting all values using for loop from front end.

First if Save...

ok, lil bit closer to it.

The only thing that I've to check whether attendance of that particular date is done or not.

If attendance is done then save record of student...

Thanks For Your Reply,

There is not much difference in SP just add one line before Selecting @BatchId.

SELECT @ContactId = ISNULL((SELECT ContactId FROM Contacts Where ContactName = @FirstName), 0)

Another thing is...

Here it is -

ALTER PROCEDURE [dbo].[SP_AttendanceStudentClass]

(

@FirstName VARCHAR(50),

@DOB DATETIME,

@TotalPresent INT,

@TotalAbsent INT,

@AttendanceDate DATETIME

)

AS

BEGIN

DECLARE

@ExeQry int,

@ClassAttendanceId Int,

@ContactId int,

@BatchId int

---- Select Batch Id here

SELECT...

Actually I tried it both ways.....

Actually I'm getting an error at ''2010 ......

FirstName LastNameLogDate

-------------------------------------------------

SamDeSouza2011-04-19 17:31:02.923

JohnWilson2011-04-19 18:50:27.233

TinaAlbert2011-04-20 10:29:50.547

RosyPinto2011-04-20 12:04:54.127

Select FirstName, LastName, Convert(varchar(10),LogDate,126)LogDate

From Employee

Where <Desired Date Paramater Here>

Here I want to send the desired paramater for...

Actually, I've already done it in using .NET code but

I want to do the same thing using javascript.

I've something like this----

function CompareDateTime()

...

ok, let me explain it.

I’m sending messages to all staff members.

But I want to validate this when we are off.

i.e. messages should not be sent except office hours.

I know the...