Hi Dan,
If I understand that you just want to add the where clause, try this:
CREATE PROCEDURE FERPmonthly @selectedview Varchar (20)
as
declare @x as varchar(500)
set @x = 'select distinct((select cast(sum(Number_of_Responses)as float) from ' + @selectedview + ') / (select...
I want a stored procedure to keep me updated on it's progress, but the print statements don't show up until it's finished. How do I make the print contents display when first hit and not kept in a buffer?
That could be nice in other cases. My job is to print an invoice so links are out. The one who started this is long gone and now it's my mess to finish. The subreport has the Report Header w/ New Page Before checked and greyed out so I can't change it. There's a recent change in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.