Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GaneshRamanan
Starting Member
40 Posts |
 Posted - 2011-01-12 : 05:58:42
|
| sp 1[OPM].[AppointmentExtend](@DoctorID Varchar(5),@AppointmentDate Datetime,@FromTime datetime,@ToTime Datetime)opm.appointmentextend fromtime totime appointmenttime 2011-01-12 11:03 2011-01-12 11:06 1900-01-01 00:03:00 doing computation in this sp to split fromtime, totime, based on appointmenttimesp 2[OPM].[appointmentExtension](@doctorid Varchar(5),@appointmentdate datetime,@specialistid int,@fromtime datetime,@totime datetime,@userid bigint)Create table #TmpScheduleDetail(ID int ,FromTime datetime,AppointmentTime datetime,ToTime datetime,Status varchar(5));insert into #TmpScheduleDetail Exec [OPM].[AppointmentExtend] @DoctorID,@AppointmentDate,@FromTime,@ToTimeSP2 Insert the values into the Appointment tablesSP1 RETURNS VALUES TO THE SP2 SP2 INSERT THOSE VALUES INTO TABLESbut i m getting fromtime, totime in sp2 SP2 passes the values to the SP1 I want to restrict the values which is already inserted into the appointment tablesfor eg:11:00 to 12:00 if it is already inserted into the appointment tablei dont want to insert into again.can you please tell me the condition?Thanks in advance,Ganesh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
|
|
Urgent help!!!