Hello,
When trying to complie a stored proc, I get the following error message for one of the tables it is looking at:
OLE DB provider 'A' does not contain table '"B"."dbo"."EMPLOYEES"'. The table either does not exist or the current user does not have permissions on that table.
I checked...
Hi, here is some sample data (columns B, D and C). "% Yes" (out of total for each D) is the column I want to calculate and achive.
B D C % Yes
-------------------------------------------
Yes X 10 0.303030303
No X 23
Yes Y 188 0.497354497
No Y 190
Yes Z 65 0.792682927
No Z 17
Hello.
I have Table A with columns B, C and D. Column B contain status ('Yes' or 'No'), C is a measure, and D is area ('X', 'Y' or 'Z'.
What I want to do is to work out % of Yes out of total - (C where B=Yes)/(C where B=Yes)+(C where B=No), then to be grouped by D.
So the output to look like...
Hello. I have a report with two tables in one tab. I want to do is to have Tables 1 and 2 on the first page, then both tables 1 and 2 Sectioned by A and B from page 2 onwards.
Problem is, I cannot seem to force the Section to start on the 2nd page. I can force the actual table to start on 2nd...
Hiya. In the company I work, we always schedule the backup (that's run using Backup Exec) through another software as part of whole overnight procedure, so all I ever needed to do was to create a backup job in Job Setup tab.
In version 8.6 I never had trouble of doing this - but we recently...
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.