custom sql tableau

CREATE FUNCTION [dbo]. [Fn_topgetorgbyusername] (@UserName NVARCHAR (128)) RETURNS @showOrg table (id NVARCHAR) asbegindeclare @baseOrg table (ID NVARCHAR ($), FullPath NVARCHAR ($), shortname NVARCHAR (+), ParentID NVARCHAR (+), [level] int,index_baseorg INT) INSERT into @baseOrgSELECT id,fullpath,shortname, Parentid,[level],row_number () over (ORDER by id) from Sysorganization WHERE ID in (SELECT OrgID from Sysposition, Sysuserpo Sition,sysuserwhere sysposition.id=sysposition and Sysuser.id=s

Label:1, creating a stored procedure Create PROCEDURE [dbo]. [P_company_insert] @CompanyCollection [Companytabletype] READONLY as INSERT into Tb_company ( [CpID] , [cphiid] , [ Cpbuyselltypeid] , [CPName] , [cpshortname] , [cpindustry] , [Cpsell] , [cpbuy] , [ CPADDRESSID] , [cpaddress] , [cppost] , [Cptel] ) SELECT oc.[cpid] , oc.[cphiid ]