October 1, 2012 at 12:42 am
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
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
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