| Author: shilpa 06 Apr 2007 | Member Level: Silver | Rating:  Points: 2 |
Hi chitra,
How r u ?...
here is ur Answer............still problem, let me know Ms.Chitra
Create Procedure prInsertNewSchedule
@intLeaseId int,
@intLeaseFrequencyId int
As
Insert LeaseSchedule(LeaseId, StartDate,
EndDate, LeaseFrequencyId)
Values (@intLeaseId, GetDate(),
DateAdd(Year, 3, GetDate()), @intLeaseFrequencyId)
return @@Error
******************
-- update information
update Equipment
Set Make = @chvMake,
Model = @chvModel,
EqTypeId = @intEqTypeId
where EquipmentId = @intEquipmentId
if exists(select EquipmentId
from EquipmentBC
where EquipmentId = @intEquipmentId)
update EquipmentBC
Set EquipmentBC = @intNewEquipmentBC
where EquipmentId = @intEquipmentId
else
insert EquipmentBC (EquipmentId, EquipmentBC)
values (@intEquipmentId, @intNewEquipmentBC)
end
return
|
| Author: Chitra A 07 Apr 2007 | Member Level: Silver | Rating: Points: 2 |
We have problem in inserting and updating the data using INNER JOINS and OUTER JOINS.We are using ASP.NET 2005 and SQL SERVER 2005 using SQL DATASOURCE.Please give us the sample code
of INSERT and UPDATE using INNER and OUTER JOINS for
joining the tables.Please give prompt reply.Its very
URGENT.......
|
| Author: Chitra A 07 Apr 2007 | Member Level: Silver | Rating: Points: 2 |
We have problem in inserting and updating the data using INNER JOINS and OUTER JOINS.We are using ASP.NET 2005 and SQL SERVER 2005 using SQL DATASOURCE.Please give us the sample code
of INSERT and UPDATE using INNER and OUTER JOINS for
joining the tables.Please give prompt reply.Its very
URGENT.......
ThankU
|