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 John Tel 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: wheels0323
  • Content: Threads
  • Order by date
  1. wheels0323

    Order By Sequence SQL - Need Help

    select distinct homelaborleveldsc2 from vp_person and employmentstatus = 'Active' order by homelaborleveldsc2 Results: District 1 District 10 District 11 District 12 District 2 District 3 District 4 District 5 District 6 District 7 District 8 District 9 Drivers Home Office Regional Office...
  2. wheels0323

    NULL VALUE Problem

    SELECT TTBL.RD_DISTRICT, TTBL.LOCATION, JOBTITLE, NAME, JOB_ENTRY_DT, SORTORDER FROM (SELECT RD_DISTRICT, LOCATION, JOBTITLE, JOBCODE, SORTORDER FROM (SELECT DISTINCT JOBTITLE, JOBCODE, SORTORDER=CASE WHEN JOBCODE = 1231 THEN 1 WHEN JOBCODE = 1405 THEN 2...
  3. wheels0323

    Extra row with null values I need to get rid of

    SELECT TTBL.RD_DISTRICT, TTBL.LOCATION, JOBTITLE, NAME, Date, SORTORDER FROM (SELECT RD_DISTRICT, LOCATION, CONVERT(CHAR(26), JOBTITLE) as JOBTITLE, JOBCODE, SORTORDER FROM (SELECT DISTINCT CONVERT(CHAR(26), JOBTITLE) as JOBTITLE, JOBCODE, SORTORDER=CASE WHEN JOBCODE = 1231 THEN...
  4. wheels0323

    Question on how to grab 'next' value in query

    ISNULL((SELECT top 1 CONVERT(CHAR (26), JOBTITLE) FROM dbo.PS_RD_EMPLOYEES_VW B WHERE JOBCODE IN ('2336','2337') AND B.LOCATION = A.LOCATION), 'Grocery Operations Manager')AS GOM, (SELECT top 1 NAME FROM dbo.PS_RD_EMPLOYEES_VW B WHERE JOBCODE IN ('2336','2337') AND B.LOCATION = A.LOCATION)AS...
  5. wheels0323

    Round to one decimal place from two datetime values

    Need help rounding to one decimal place from two datetime fields. So far I have. SELECT PERSONNUM, ROUND(convert(decimal(10,1), datediff(minute, shiftstartdate, shiftenddate) / 65.0), 1) FROM VP_SCHEDULE WHERE PERSONNUM = '016902' AND SHIFTSTARTDATE = '2007-03-27 06:00:00.000' That brings...
  6. wheels0323

    Adding Fields In SQL by Increments

    select personnum, timeinseconds, wageamount, applydate, startdtm, enddtm from vp_totals where personnum = '103786' and applydate >= '2008-11-30 00:00:00.000' and applydate <= '2008-12-06 00:00:00.000' and paycodename = '01 REG' Let's say I have the following code. The attachment file is a...
  7. wheels0323

    Help With Converting Numeric Minute Value To Time Value hh:mm

    CASE WHEN i.TotalWeekHoursMinutes > MRW.MAXHOURSNUM THEN 'Worked more than ' + CAST(CONVERT(DECIMAL(5,2), MRW.MAXHOURSNUM / 60.00) AS VARCHAR(5))+ ' total week hours' WHEN i.DayTotalMinutes > MRD.MAXHOURSNUM and i.applydate = i.schoolcalendardt THEN 'Worked more than ' +...
  8. wheels0323

    Help with reporting services and time conversion

    I need a way to convert this field into hh:mm =Fields!TotalTimeSeconds.Value It comes back as total seconds for a day. I need to do this in reporting services somewhere inside the field textbox itself. I was using Convert(VarChar(2), sum(timeinseconds) / 3600) + ':' + Convert(VarChar(2)...
  9. wheels0323

    Help with summing fields by another field (SQL programming)

    I have this code. select laborlevelname2, laborlevelname3, personnum, applydate, laborlevelname4, personfullname, laboracctname, timeinseconds, Convert(VarChar(5), DateAdd(Minute, timeinseconds / 60, 0), 108) As HourMin, wageamount, laborleveldsc5 from vp_totals where applydate >= '2007-01-01'...

Part and Inventory Search

Back
Top