Recent content by Michael57

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.