Thanks Sankarmagesh for your help.
If I understand, custom SQL is available only with tables (not with stored procedure) so, in this way I should follow this steps.
- Edit the SP like the following
ALTER PROCEDURE [dbo].[ZZZ_SPTestTableau_01]
@ThisDay AS varchar(10)
SET NOCOUNT ON;
INSERT INTO [OutputTable]([Col1],Col2],[DateCol],[Temp])
- Add as data source SP [ZZZ_SPTestTableau_01] as datasource with fixed value of @ThisDay
- Add as data source table [OutputTable]
- Customize the SQL code of the select from [OutputTable], but this is not necessary as the SP run only with fix value of @ThisDay, so I don't have to filter anything.
Is it true? so I am not passing any variable parameter to the SP?
Thank you very much for you help!