thanks frnds for the suggestions...

thanks.but i dont have the backup....and the transaction is committed,....In this scenario is there a possibility of getting the data back????

thanks.but i dont have the backup....and the transaction is committed,....In this scenario is there a possibility of getting the data back????

ok got the Idea.Im Saving my Data Directly using getDate().

Thanks for all the Help.

hello again,

i have one more query.Can i get the Date and Hour using a Query.

I want to Insert the Date along with the hour part in the Table.Like this 2011/11/25...

hello again,

i have one more query.Can i get the Date and Hour using a Query.

I want to Insert the Date along with the hour part in the Table.Like this...

Thanks mate for ur Help.

Im done with my issue.

Thanks again.

M i suppose to mark as asnwered or solved for this question.I dont find any such Option

Cant i use the Date filter with (yyyy/MM/dd) format only.Just to check the year,Month,Day and bring the time part in the picture.

cant i use the- convert(varchar(10),getDate,111) to compare the...

hi thank u so much for the reply,

i want to add another filter to the Query i.e the Date.There is a Date column in Attendance.

I want to get the records...

I have three Tables.One is

EmployeeMaster(EmpCode,EmpName,MobileNo)

Sample Date EmployeeMaster(1,SameerKhan,4512541321)

ClassMaster(ClassId,ClassName,EmpCode)

Sample Data ClassMaster(1,ClassA,1)

Here EmployeeCode in ClassMaster is the EmpCode from EmployeeMaster.

Attendance(StudentID,Class,Status)

sample data Attendance(445,ClassA,Absent)

Here Class will come from ClassMaster

Now suppose there are...

Hi frnds,

Im trying something like this for the same issue.

select BalanceAmt,(select Amt from FeeChequeStatus where ProcessStatus='Cleared' and RegNo=101106001)as ChequeAmt

,BalanceAmt- (select Amt from FeeChequeStatus where ProcessStatus='Cleared' and RegNo=101106001)

from FeeRecieptMaster where...

Hi friends

thanks for the reply.

I have tried the query posted by John and giving me the expected result.

Im in the testing process of that,if required i would post my further...