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

    Using the WIld Card symbol in Crystal

    Thanks a million; that works perfectly!! Thanks a bunch!! -T
  2. 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...
  3. renee35

    Incorrect Syntax Error

    Okay, I removed that and now I am getting this error: Incorrect syntax near the keyword 'insert'. What am I doing wrong now? DECLARE @StartDate datetime SET @StartDate = '2008-1-1' DECLARE @EndDate datetime SET @EndDate = '2008-1-31' Create table #vacationpay_types (paycodeid int, paycodedesc...
  4. 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...
  5. 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...
  6. renee35

    Issues with Joins in Query Results

    Thanks! I found the error!! Thanks a bunch!! -T
  7. renee35

    Issues with Joins in Query Results

    ...h on h.candidateid = c.candidateid and checkdate < c.startdate Group by h.candidateid, c.startdate )p on p.candidateid = r.candidateid ** the reason I am doing the left outer join is because of the where clause in the report: 3- Once that list is completed based on the join, I need to...
  8. renee35

    Calculating Fields based on a Month

    I got it! Thanks for that information because that is what helped me figure it out. This is what I ended up with: [Week6] = sum( case when DATEPART(ww, weekending) = 6 then isnull( e.AllTCHours, 0) else 0 end ), [Week7] = sum( case when DATEPART(ww, weekending) = 7 then isnull( e.AllTCHours...
  9. renee35

    Calculating Fields based on a Month

    It current prints out like this: Jan Feb Mar Apr 2 4 13 10 What I would like to do is this: Week1 Week2 Week3 Week4 2 4 13 10 based on the parameter being passed: 209-2-1 --> 2009-2-28 Thanks! Thanks a bunch!! -T
  10. 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...
  11. renee35

    Using Case statement in and or statement

    Thanks a bunch! Thanks a bunch!! -T
  12. 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...
  13. renee35

    Help With Invalid Column Name Error

    Help no longer needed. Thanks! Thanks a bunch!! -T
  14. renee35

    Help With Invalid Column Name Error

    ...end, 'MarkupPct' = case when sum(isnull(o.pay,0)) <> 0 then sum((isnull(o.billing,0) - isnull(o.pay,0)))/sum(isnull(o.pay,0))*100 else 0 end, 'TimeCardNormal' = SUM(Case when o.timesheetid is not null and (datediff(d,o.weekending,o.createdate)<7) then 1 else 0...
  15. 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 =...
  16. renee35

    Stored Procedure Error

    Nevermind got it!! Thanks a bunch!! -T
  17. 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...
  18. 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
  19. 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...
  20. renee35

    Help WIth Error

    Thanks! Thanks a bunch!! -T

Part and Inventory Search

Back
Top