SoftadminGuide.Generate_Calendar_Resource_Sql
Type:
Stored procedure
Creates the procedure for a "Calendar" menuitem in "Resources with time scale" mode.
Parameters
@AllowDrag
optional
bit
Whether or not to dragging is allowed.
Default 0.
@AllowResize
optional
bit
Whether or not resizing is allowed.
Default 0.
@DatetimeFromColumn
mandatory
sysname
@DatetimeToColumn
mandatory
sysname
@HeadingColumn
mandatory
sysname
Name of the heading column in the table.
@MainResourceTableName
mandatory
sysname
@OverwriteProcedure
mandatory
bit
Whether or not it is allowed to overwrite an existing procedure.
@ProcedureName
mandatory
nvarchar(600)
Name of the created procedure.
@TableName
mandatory
nvarchar(600)
Name of the table to base the procedure on.
@TextColumn
mandatory
sysname