sql - Insert another parameter along with table type -

sql - Insert another parameter along with table type -

the table tbleffort has 3 columns employeename, effort, date. first 2 column values table type parameter , have insert mutual date these values.

do not have alternative include timesheetdate in dtcsv there should other way running update 1 time again on inserted columns right?

the below code gives error - must declare table variable "@timesheetdate"

create type dbo.saveeffort_tabletype table ( employeename varchar(200), effort decimal(18,2) ); go create procedure saveemployeeeffort ( @timesheetdate datetime, @dtcsv dbo.saveeffort_tabletype readonly ) begin insert tbleffort(employeename,effort,[date]) select * @dtcsv,@timesheetdate end

you need set variable select clause, not from clause

create procedure saveemployeeeffort ( @timesheetdate datetime, @dtcsv dbo.saveeffort_tabletype readonly ) begin insert tbleffort(employeename,effort,[date]) select employeename,effort, @timesheetdate @dtcsv end

sql tsql sql-server-2012