Hai, I used a table for generating grade for students. for thati used the fields: UpperBound[int] LowerBound[int] Grade [varchar(50)] I have some datas such as : UpperBound LowerBound Grade 61 70 D 71 80 C 81 90 B I sent the value 80.09 to Stored procedure. Stored procedure something like this: [CODE]select * from SCH_Grade_Master where SCH_Grade_Master.Lbound<=80.09 and SCH_Grade_Master.Ubound>=80.09 [/CODE] But no result get for values like 80.09, 70.08 etc but get results for 81.02 79.00 etc Can u help me to solve this. Thanks in advance, Sreevidya

Member Avatar
Member Avatar
+0 forum 2

Hi I am working on a procedure to log the users and times of our reports. Our reports are all executed from stored procedures. The generic logging proc which will be placed in the 30+ report procedures. I'm having a problem with getting the start and end times for the report. I know I can get both times by putting the current time in a variable before I execute the report and doing the same afterwards. This is however a last option. Currently, I call the proc before I execute a report, that way it gives me the start time …

Member Avatar
Member Avatar
+0 forum 1

The End.