Post reply

How to create a procedure which takes multi value parameter -Urgent Help Needed

  • October 1, 2012 at 12:42 am

    #262385

    Hi,

    I need to create a procedure which takes 2 input parameters and using this stored procedure in crystal reports for creating reports.

    Input Params:

    p_name1 & p_name2.

    p_name1 should take the values from a column in a table so that in crystal report it will show as dropdown where the user can select one value.

    anyhelp in this is much appreciated.

    Thanks

  • October 1, 2012 at 3:43 am

    This was removed by the editor as SPAM

  • October 1, 2012 at 8:15 am

    #1543998

    Thanks for the response!!

    Yes, I have the query in the same format...But how can I link a dataset to the input parameter @p_name1 in my stored procedure.

    Basically I was looking a format like

    CREATE PROCEDURE MySchema.MyProcedure

    @p_name1 Dataset ='select columnA from table', @p_name2 DataType[/]

    AS

    SELECT ColumnList FROM Table WHERE ColumnA = @p_name1 AND ColumnB = @p_name2

    GO

    @p_name1 should hold the result set of columA from a different table.

    Thanks

    Pradeep GS

  • October 1, 2012 at 8:27 am

    This was removed by the editor as SPAM

  • October 1, 2012 at 10:04 am

    #1544044

    Hi SSCRAZY,

    I am very new to SQL Stored procedure.I did not understand the second wasy of doing using filters.

    I did not understand where we are inserting the dataset to input paramter p_name1.

    Can you please provide me a sample procedure for using filters.

    Also, regarding the first approach using table-value.I have created a type but do we need to create a temporary table also for that to insert the values in the table? for every execution of stored procedure, this table will created and deleted after executing ?

  • October 3, 2012 at 1:41 am

    This was removed by the editor as SPAM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply