Search results for query: *

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

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

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.

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

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

What does DDL and DML mean

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

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.

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

What does the (id int) mean?

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.

I use sharepoint. How is this done here?

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

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.

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

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.

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

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

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

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