I have a sp called SP_Qlikview that returns columns A, B and C so in my script I have the following:
Load
A, B, C
Sql exec SP_Qlikview.
Question is what table does this load into in the script as when i run the reload the table viewer doesn't show anything. In addition, in my script preceding this statement as a number of concatendate load statements for three fact tables.
Actually, you do need to put the Set Nocount ON as well.
but.. No you don't replace the '' with the name of the field. the example is designed to tell you to put nothing or a zero in the field and make sure it is returning the same data type in the select statement as the results of your actual query.
Also I don't see any return data set in your query. At the end of your SP. Try to do a SELECT field,field from #CostA
