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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: Michael57
  • Order by date
  1. Michael57

    Declare an integer

    When I do not put quotation marks around HRDIF it tells me it is not a column name.
  2. Michael57

    Declare an integer

    HRDIF comes from the subtraction of variables in two different tables.
  3. Michael57

    Declare an integer

    SQLSister, HRDIF is created in the code and does not go to a talbe is there a way I can declare it and integer to avoid this problem. They are all numbers.
  4. Michael57

    Declare an integer

    I tried this and it returns all records including negative ones.
  5. Michael57

    Declare an integer

    Select PMCATGT.CONTRACT,MAX (PM.MANAGER)as Manager,PMCATGT.PROJECT,PMCATGT.COSTTYPE, SUM (PMCATGT.CURQTY) AS BUDGETHRS,SUM (PMCATGT.ACTQTY) AS ACTUALHRS, SUM(CASE WHEN PMCATGT.COSTTYPE = 'ASSYLAB' THEN 0 WHEN PMCATGT.COSTTYPE = 'CNCLAB' THEN 0 WHEN...
  6. Michael57

    Declare an integer

    What does DDL and DML mean
  7. Michael57

    Declare an integer

    THis does not work. I don't get the error but it does not bring back any data. All data is numbers no letters.
  8. Michael57

    Declare an integer

    I have some code that subtracts to items to get a result HRDIF and this code works fine until I add a where statement that asks to show only records wher HRDIF is >0. At this point I get an error "Conversion failed when converting the varchar value 'HRDIF' to data type int." How can I stop this.
  9. Michael57

    Write to a temporary table

    how would it look if I had more than one column? (id int, id2 int)
  10. Michael57

    Write to a temporary table

    What does the (id int) mean?
  11. Michael57

    Write to a temporary table

    I was told you can write the output of a query to a temporary table to be use again with some other query. How can this be done.
  12. Michael57

    Ask for a variable in a query

    I use sharepoint. How is this done here?
  13. Michael57

    Ask for a variable in a query

    In access you can ask the user to type in a variable when the query starts that will be used to execute the query. How is this done in sql
  14. Michael57

    Microsoft Office Sharepoint Designer

    Im creating a aspx page in ms sharepoint designer and I would like to know if there is a way to hook up a button to activate an sql query in a microsoft sql database.
  15. Michael57

    Create table and update

    I want to create a table with an sql script that will take only some values from another table. How can I do this.
  16. Michael57

    Link and update a table

    I need to update a field in one table "Work" based on a value in another table "Job". The two tables should be linked by the field "job#". I want script to update a field "status" in table Work based on the value of "status" in the table "Job". Can anyone please help me on this. Thanks in advance.
  17. Michael57

    Need to outp a value based on criteria in data

    What if I had other items that would require a 0 output. How can I set up multiple cases?
  18. Michael57

    Need to outp a value based on criteria in data

    I need to output a value of 0 for COSTDIF whenever PMCATGT.COSTTYPE is = LAB in the following program but I'm not having any luck. Help is much appreciated. Select PMCATGT.CONTRACT,PMCATGT.PROJECT,PMCATGT.COSTTYPE,SUM (PMCATGT.CURQTY) AS BUDGETHRS,SUM (PMCATGT.ACTQTY) AS ACTUALHRS,SUM...
  19. Michael57

    Add a subtraction result to a query

    I have a query that produces a form and I would like to have the query put out a column that basically subtracts one column from the next. I would like to create a field that subtracts SUM (PMCATGT.CURQTY) AS BUDGETHRS from SUM (PMCATGT.ACTQTY) AS ACTUALHRS. I can't get this working. My code is...
  20. Michael57

    Label that is conditional on other field

    I would like to generate a specific title on a report that is dependent on a value of a field in the report. So if a value of 30 comes up I want the title to be "OPEN" and if the value is 60 I want the title to be "CLOSED".

Part and Inventory Search

Back
Top