InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 17:47:03 GMT20http://www.sqlservercentral.com/Forums/Topic1381492-391-1.aspxI checked default template does not cater to my changing parameter reuirement. Also it is not showing me how to make table type paramter as optionalTue, 06 Nov 2012 06:52:07 GMTKrishna1http://www.sqlservercentral.com/Forums/Topic1381492-391-1.aspx[quote][b]shilpaprele (11/6/2012)[/b][hr]Dear AllI need to create procedure with variable parmaeter list. I am trying to achive it through table value parameter.Is it the correct approch?Also I need this parameter to be optional. But when i give folloing syntax i get errorCREATE PROCEDURE [P1] @param1 VARCHAR(40), @ParameterTable ParameterTable READONLY = NULLas.....[/quote]Table-valued parameter is the best for passing table-like data, but not variable parameter list.Let say you want to pass multiple Customer Id's together with relevant Customer Names. Table-valued parameter is upto this task.But if you want to pass list of different parameters eg. not-related to each other and having different datatype, I would recommend using XML.Tue, 06 Nov 2012 06:03:54 GMTEugene Elutinhttp://www.sqlservercentral.com/Forums/Topic1381492-391-1.aspxYou can use default Stored Procedure Template from Template Explorer.it will help youSSMS > View > Template Explorer > Stored ProcedureTue, 06 Nov 2012 05:01:14 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1381492-391-1.aspxDear AllI need to create procedure with variable parmaeter list. I am trying to achive it through table value parameter.Is it the correct approch?Also I need this parameter to be optional. But when i give folloing syntax i get errorCREATE PROCEDURE [P1] @param1 VARCHAR(40), @ParameterTable ParameterTable READONLY = NULLas.....Tue, 06 Nov 2012 04:46:20 GMTKrishna1