Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Modifying a procedure to accept multiple conditions
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...- carlcom
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Print now, don't wait
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?- carlcom
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Subreport not printing on first page
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...- carlcom
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Subreport not printing on first page
I'm here (first time) for the very same problem. Any word on what to do?- carlcom
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
