As per the the error message and create procedure statement, it appears that the table type does not exist. You might need to generate a user-defined table type for
tblURLabelHeader
.
CREATE TYPE tblURLabelHeader
AS TABLE
( ColumnName1 datatype,
ColumnName2 datatype );
GO
You can verify the table types through the following query for '
tblURLabelHeader
' and other newly created tables.
SELECT *
FROM sys.table_types
WHERE name = 'yourtabletypename'
You can also refer to the below example/link for more details about how to create a user-defined table type.
CREATE TYPE (Transact-SQL) - SQL Server | Microsoft Learn[
^]