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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. fuyuki11

    Error Msg 7314, Level 16, State 1

    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...
  2. fuyuki11

    creating a "% of total" columnin the script

    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
  3. fuyuki11

    creating a "% of total" columnin the script

    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...
  4. fuyuki11

    Sections

    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...
  5. fuyuki11

    Createing job with scheduling

    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...

Part and Inventory Search

Back
Top