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

    Using the WIld Card symbol in Crystal

    Is there a way to set a parameter and only type in part of the word? Below is what I currently have: {?Recruiter} = "All" or {Command.FullName} like {?Recruiter} I am entering Recruiter as: 'Amb%' I am using like because one might not know the full/correct spelling of the recruiter name so...
  2. renee35

    Incorrect Syntax Error

    I am struggling with the "Incorrect syntax near the keyword 'UNION'" in the below code. Could someone please tell me what I am doing wrong in the below code: DECLARE @StartDate datetime SET @StartDate = '2008-1-1' DECLARE @EndDate datetime SET @EndDate = '2008-1-31' Create table...
  3. renee35

    Printing values as column headings

    Does anyone know how to print a value as a column heading in the report? Here is the data I am pulling: [Week1] = sum( case when DATEPART(ww, weekending) = 1 then isnull( e.AllTCHours, 0) else 0 end ), [Week2] = sum( case when DATEPART(ww, weekending) = 2 then isnull( e.AllTCHours, 0) else...
  4. renee35

    Issues with Joins in Query Results

    What I need to accomplis is: 1- get all candidates who has at least 90-180 days between startdate and @quarter: declare @quarterstart datetime SET @quarterstart = '4/1/2009' Create table #candidates (candidateid int, indentificationdetails nvarchar(50), firstname nvarchar(50), lastname...
  5. renee35

    Calculating Fields based on a Month

    Below is the current code I have summing data based on a month, how can I get it to be broken down by week? Here is the code: [Jan] = sum( case when Month( WeekEnding) = 1 then isnull( e.AllTCHours, 0) else 0 end ), [Feb] = sum( case when Month( WeekEnding) = 2 then isnull( e.AllTCHours...
  6. renee35

    Using Case statement in and or statement

    I am trying to create a or statement and what I have is a case statement to handle the 2nd half of it. This is what I need to accomplish: anyone who has at least 90 days of employment between their earliest start date of all of their jobs, and their latest end date of any of their jobs (or the...
  7. renee35

    Help With Invalid Column Name Error

    I have the below code: --build our data for each profit center: INSERT INTO #profitCenterSummary(profitCenterId,workperiodnum, fiscalyear, tempsonstreet, clients, totalhrs, reghrs,otherhrs,avgpayrate,avgbillrate, fulltimeeqiv, avgtothrs, avgreghrs, aveotherhrs, markuppct...
  8. renee35

    Help With Calculating Year

    I have the below code and it is not giving me the correct return value: DECLARE @PeriodStartDate datetime DECLARE @LastYTD datetime DECLARE @EndDate datetime SET @EndDate = '2009-2-15' select @PeriodStartDate = StartDate from FiscalWeekMap where EndDate = @EndDate SELECT @LastYTD =...
  9. renee35

    Stored Procedure Error

    What am I doing wrong in the below codeto generate the error below. I added the open and close parentheses, but that didn't fix it: Incorrect syntax near the keyword 'if' Create PROCEDURE WeekEnding ( @endDate datetime, @weekEndingDate datetime OUTPUT, @WorkWeek int OUTPUT ) AS if @endDate...
  10. renee35

    Date Range Question

    I am creating a report and need to pull all active employees whose startdate is at least 90 days prior to the first day of each quarter (1/1, 4/1, ect.) and the enddate is null. Please advise! Thanks a bunch!! -T
  11. renee35

    Help With Case Statement

    Is this Case Statement written correctly: 'AvgPayRate' = Case when sum(isnull(o.pay,0)) = 0 then 0 when sum (isnull(o.totalhours,0)) = 0 then 0 else sum(isnull(o.pay,0))/sum (isnull(o.totalhours,0)) end, 'AvgBillRate' = Case when sum(isnull(o.billing,0)) = 0 then 0...
  12. renee35

    Help WIth Error

    Below is the code that I am receiving this erorr for: Server: Msg 156, Level 15, State 1, Line 21 Incorrect syntax near the keyword 'Group'. Please help because I cannot seem to figure it out! Create table #vacationpay_types (paycodeid int, paycodedesc varchar (255)) insert into...
  13. renee35

    IF Statements

    Could someone please explain to me why the below IF Statement will not return the word 'NULL": If {Command.fullname} ="" then 'NULL' else {Command.fullname} Thanks! Thanks a bunch!! -T
  14. renee35

    Divide by Zero Error Encountered

    Could someone pleasssssse help me with the error above? Here is the code: select m.parentprofitcenterid, workperiodnum, fiscalyear, c.customerdescription, 'TempsonStreet' = count (distinct o.candidateid), 'Clients' = count (distinct o.clientid)...
  15. renee35

    Case Statements

    Could someone please help me figure out what I am doing wrong in the code below: Select 'Customer' = c.name, 'EmployeeID' = h.employeeid, 'First Name' = h.firstname, 'Last Name' = h.lastname, 'Job Description' = h.jobdesc, 'Regular Pay' = Case when r.paycodeid = 1 then t.payrate else 0 end...
  16. renee35

    How to Remove Default Parameter Values

    Does anyone know how to remove the default parameter values that appear in the drop-down list? **The parameters were created in SQL? Thanks! Thanks a bunch!! -T
  17. renee35

    Calculating Values with Blank Cells

    Could someone help me figure out how to calculate the below formula without getting the #DIV/0! error: =AVERAGE(D8,J8,P8,V8,AB8).. What is happening is at some points one of these cells may be empyt. I tried using the is Blank function, but that doesn't help. For this week, D8 is null...
  18. renee35

    Trimming a data field

    I have the below formula: CONVERT(varchar(10), m.DOB, 101) that returns: 12/23/2008, how can I get it to return only 12/2008? Thanks! Thanks a bunch!! -T
  19. renee35

    Help with Aggregate Functions

    I have the below formula: Case when sum(isnull(o.payrate,0)) = 0 then 0 else sum(o.payrate)/count (distinct o.candidateid) What I need to say is: Case when sum(isnull(count (distinct o.candidateid),0)) = 0 then 0 else sum(o.payrate)/count (distinct o.candidateid) But I can't use count...
  20. renee35

    DateAdd Function

    Could someone please help me figure out how to change the below code: a.effdate between @PrevQtrClose + 1 and @enddate to say between @PrevQtrClose + dateadd (sec + 1)? What I need is to capture all data between the prevqtrclose and the next day, and right now I missing anything that falls in...

Part and Inventory Search

Back
Top