Search results for query: *

Thanks!

I have tried to change a column in my table several ways: ALTER TABLE ClientIDtoClientRollup RENAME COLUMN Description to RollupDesccription; ALTER table ClientIDtoClientRollup change Description RollupDesccription varchar(255) They both returns errors: Incorrect syntax near the keyword...

Could someone please tell me what I am doing wrong in the statement: SUM(CASE WHEN paycode IN (1,2,3) THEN (d.billunits*d.billrate/(d.payunits*d.payrate)) ELSE 0 END

I am using 2000? I left out the first part of the query, whcih has my select statement: DECLARE @TimeCardInfo Table (intid int, fieldid int, extid int, timesheetid int, tcid int, firstname varchar(50), lastname varchar(50),TimeSheetPay decimal(19,6), StaffServPay decimal(19,6), CheckPay...

I am getting the below error: An aggregate may not appear in the set list of an UPDATE statement. When trying to do this: UPDATE t SET [StaffServPay] = SUM(case when d.paycodeid = 1 and computeonunits = 1 then (d.actualunits*d.payrate) when d.paycodeid = 1 then...

Thanks!

Select o.orderid, firstname, lastname, 'EMAIL' = isnull(email, email2), 'SUPERVISOR' = MAX(CASE when userdefinedfieldid = 83 and userdefinedanswer = 'Yes' then 'Y' ELSE 'N' END), 'LOCATION LONG TITLE' = Case when oc.workfromhome = 1 then pa.municipality+', '+r.regioncode...

I have the below select statement: Select o.orderid, firstname, 'SUPERVISOR' = MAX(CASE when userdefinedfieldid = 83 and userdefinedanswer = 'Yes' then 'Y' ELSE 'N' END), Where SUPERVISOR = 'N' I get the following error: Invalid column name 'SUPERVISOR' even if I enter it like this...

I have a report where I need to calculate units for the year: date between '2009-01-01' and '2009-12-01' How can I write the dates so it automatically pick the current year without having to change it manually? Thanks!!

How can I suppress the data from showing on the last page of the report? There is information that I only want to display until I get to the final page, and there I want it supressed so the grand total will only display in the report footer. Thanks!

I am currently using getdate() in one of my queries as such: where checkdate = getdate().. problem with this is it prints out the time: 2009-10-23 09:38:48.673 How can I set getdate() to not include the time: 2009-10-23 00:00:00.000 Thanks!!!

Okay, thanks!

I am trying to create a report with drilldown sections and the first sections looks like this: Dept. StatusCnt ------ ----------- A 4 B 15 C...

Yes there are multiple grouping on invoices based on the store no. associated with the invoice. If I put it in the report footer it will display the overall total after each store grouping which will be misleading.

It is an invoice that I have created and I only want the total to display in the page footer, not the report footer; is there a way to accomplish this?

How can I get my total to only print on the last page of the report. I went into Section Expert, Suppress but not sure how to tell it to print on last page. Thanks,

Thanks!!

I am trying to update a table I created that have NULL in one of the fields. UPDATE clientidtoclientrollup SET rollupid = clientid WHERE clientid is null Returns: (0 row(s) affected) Thanks for any suggestions...

Thanks!!

I have created a report and currently entering the date range needed, what I want to do is be able to run this report for the current year as below: checkdate between '2009-01-01' and getdate() How can I have the date range entered without having to enter a date in for the (2009-01-01)? Thanks!