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 derfloh 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: titans4771
  • Content: Threads
  • Order by date
  1. titans4771

    How to Change a column name in a table

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

    Incorrect Syntax

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

    Update statement error

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

    Using alias in the where clause

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

    Date Range Filter

    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!!
  6. titans4771

    Suppress on Last Page

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

    Getdate Function

    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!!!
  8. titans4771

    Displaying Results in the First Level DrillDown

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

    Printing Total on last page

    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,
  10. titans4771

    Updating NULL values

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

    Date Range for current year to date

    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!
  12. titans4771

    Converting Date Field to Day of the Week

    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!
  13. titans4771

    Character "c" is gramatically incorrect

    I am testing my XML code in AltovaXMLSpy...
  14. titans4771

    Converting Dollar amount to 2 decimal places

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

    How to add column names to XML

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

    Using named columns in where clause

    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'...
  17. titans4771

    Summing Multiple Case Statements

    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)...
  18. titans4771

    Error in Formula &quot;Number is Required Here&quot;

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

    How to remove time from date parameter

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

    Incorrect Syntax Error

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

Part and Inventory Search

Back
Top