How to insert values using Joins in asp.net stroed procedure?
Posted
by
Samba Siva
on Stack Overflow
See other posts from Stack Overflow
or by Samba Siva
Published on 2013-11-07T09:43:11Z
Indexed on
2013/11/07
9:53 UTC
Read the original article
Hit count: 197
CREATE PROC [dbo].[K_HRM_Insert_VehicleAssign]
@vehiclename varchar(50),
@empname varchar(50),
@updatedby varchar(50),
@updatedon datetime
as
begin
insert into K_MasterEmpDetails ME inner join K_HRM_Vehicle_Assign VA on VA.[empname+id]
= ME.Firstname +' '+ME.Lastname+' - '+ME.kjlid as ME.Employee
(VA.vehiclename,ME.Employee,VA.updatedby,VA.updatedon)values(@vehiclename,@empname,
@updatedby,getdate())
end
I am getting an error near ME...please help me
© Stack Overflow or respective owner
