Hi Brian, good day.
Is there anywhere that I can see the stored procedure structure, I haven't found it anywhere and the book hastn't arrived yet.
I have my sp like this:
alter sp_report_query @id1 int, @date datetime as
begin
set nocount on;
Select id, description, value, city, type from table where
id=@id1 and date between dbo.fu_firstday(@date) and @date
end
go
The expert won't recognize the fields of the query.
Need your help please.
IP Logged
