Search results for query: *

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

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

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

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,

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

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!

I have the below field: command.date, this is how it shows on the report now: 2009-7-22, how can I get it to show 'Monday' as opposed to the date itself? Thanks!

I am testing my XML code in AltovaXMLSpy...

I have the below code: 'PTEHeadwayFee' = (SUM(case when y.paycodeid = 259 and y.computeonunits = 1 then (y.billunits*y.billrate) when y.paycodeid = 259 then ISNULL(y.billrate,0) ELSE 0 end)+ SUM(case when y.paycodeid in (33,286,337,1959) and y.computeonunits = 1 then...

I am a newbie to XML and I have an assignment to create CSV file using XML? I have the below XSLT code and it returns the values in CSV, now I want to add the column headings to the file as well, how would I go about doing this? Below is my code: <xsl:stylesheet version="1.0"...

Can you not use named columns in the where clause? Here is what I have: Select a.cancount, b.clientcount, sum(d.compcount) as compcount, c.candidateid, clientname, firstname, lastname, cs.employmentcode, 'status' = case when a.cancount < (b.clientcount + sum(d.compcount)) then 'incomplete'...

In the code below, I am trying to sum a couple of my columns that are using case statements. The column at the bottom, PTEFee is the column where I am trying to sum everything up. Here is the code: Select 'TotalMilieage' = SUM(case when y.paycodeid = 261 then isnull(y.units,0) else 0 end)...

I have the below code: If isnull({Command.missingdocs}) or {Command.missingdocs} ="" then 'NULL' Else {Command.missingdocs} What I am trying to do is have the formula display "Null" if the row is empty. The value of that field is a number there fore the error is saying I need a number where I...

I have the below parameter being passed in: Declare @rundate datetime Set @rundate = dateadd(dd,-3,getdate()) select @rundate It currently returns: 2009-09-11 11:07:30.487 How can I get it to return: 2009-09-11 00:00:00.000

I am getting an "incorrect syntax error" with the below code: Having SUM(case when checkdate = dateadd(wk,-4, '2009-9-18') then d.units end) < 30 or Having SUM(case when checkdate = dateadd(wk,-3, '2009-9-18') then d.units end) < 30 or Having SUM(case when checkdate = dateadd(wk,-2...