Ryan1 (8/16/2013)
So there is more input than just dbo.table? How does this work?
dbo.Table is not input. That is the data source you are querying.
The input parameters are very simple. I would call the stored procedure in a manner similar to the following.
Execute [dbo].[Procedure_table] @Adult = 1
But you should understand if any of the parameters are required first from the person(s) that wrote it.
Also, the definition of the procedure should be changed to remove the duplicate comma in the following
@Adult tinyint = NULL, ,
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events