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

    Seems Basic but Difficult Sql Query

    I have a table with 1.date 2.casenumber 3.errortype 4.pagenumber columns I want to pull all records in the table . but, if an error_type of '2' is present for a pagenumber/case_number on the same day that there are other error types for that page, I only want to pull the error type 2 log...
  2. Khanson82

    SQL GETDATE

    Im trying to get all records that are >= (previous day at noon) This would seem easy but not so much for me..... Our dates are stored like '1995-01-01 00:00:00.000' The time is in military units.(0-24) Any ideas? Thanks again..
  3. Khanson82

    Select Expert With Year Select

    I have this right now.. year({@Hire Date}) = year(currentdate) - 1 and month({@Hire Date}) = month(currentdate) Which originally everyone wanted, now they want the same exact thing but instead of just last year, I want it to take in all previous years... Basically, every month this report...
  4. Khanson82

    Reference Material

    Wanted to get some ideas for good books or sites that I could get to learn StoredProc/Temp Tables/Variables/MyCursor ...Stuff similar to that... Sql Server 2005-2008.. I've been learning sql for a few months now and I think I'm ready to jump into those.. Thanks again..
  5. Khanson82

    Date Range Inclusion

    I have a hire date in this format (mm/dd/yyyy)..the report will run the 1st day of every month and I want to capture all records that are within the same month, 1 year ago for th whole month... For example, if it 07/01/2010, I want the report to capture all records with a hire date of...
  6. Khanson82

    Easy mask

    In crystal, if i have a column that includes nulls and numbers..How can I make the Nulls show up as 0 and the other fields show up as what they are? Thanks again..
  7. Khanson82

    On first record and Last

    I have this in my suppress section: {Command.ProviderID}<> previous({Command.ProviderID}) and {Command.ProviderID}<> next({Command.ProviderID}) And want to add except on first record and last record.. Is this possible? Im basically wanting to hide any records where the providerid used is the...
  8. Khanson82

    Group By

    Is there a way to use this below top part, but not use any of the fields in the group by other than:a.Zip,a.clientid,a.state,a.agent? By adding the other fields in the group by, it is messing up the results. But since those fields are in my case statements, it makes me use them in the group by...
  9. Khanson82

    Sum through time periods

    Right now I'm getting the sum of unused hours for a time period.. I am wanting to change it to where I get a sum of unused hours for that time period if it is in the future.. If today is the first day of the itineray or somewhere in the middle of it, then I want unused hours from tomorrow-the...
  10. Khanson82

    ;with cte help

    I have this:: ;with Monster as (select a.caseno,a.applid, a.applname, s.clientname,a.clientid, a.serial, (a.status +'/'+ a.statusreason) as Status, b.Appt_DateTime as Rescheduled, b.providerid as currentprovider,c.fudate from vwapp0 a with(nolock) inner join vwaccount s on s.clientid=a.clientid...
  11. Khanson82

    Null Values in Parameter

    I have this in my select expert: (({?Members} = 'Yes' and {command.members} > 0) or ({?Members} = 'No' and isnull({command.members}))) The parameter only has a choice of Yes or No to the User..Yes being members with 1+ in the field.No being members with a null value.. My problem is when you...
  12. Khanson82

    Mask Parameter

    I want the parameter to show Yes or No to the User.. "Yes" would be if a number field in the report would be any number greater than 0. "No" would be if that number is 0. How is this done? Thanks again.
  13. Khanson82

    Dynamic Parameter Report not Saving to Business Objects

    When I have a dynamic parameter in a report and try to save the report to Business Objects/InfoView I get this: Error with Business Objects Enterprise Failed to read data from report file "my file location" Reason:failed to read parameter object. Any ideas? When I ask anyone here, they just...
  14. Khanson82

    Msg 306 Error

    The below pulls everything I need except one field that I get errors when I try to add it. I'm needing c.notes. I get this error right now; Msg 306, Level 16, State 2, Line 1 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Sql...
  15. Khanson82

    Sum Values for Date period to Match another Date period

    I basically have two tables I'm trying to match up and then sum from one... Table 1: tproviderschedule (basically looks like this)It is a log for peoples travel schedules..Can be a range of dates or just one date.. Name ID travelstartdate travelenddate etc...
  16. Khanson82

    Max Serial Retrieval

    Why will this not pull back all of the max serial rows I'm needing for the notes field? It does it correctly for about 90% of the records? Any other ideas for getting max record pulled for a notes(text) field? The max record row for the notes field will also have text in it everytime never...
  17. Khanson82

    Joining two Sql Statemets

    Below is two sql statements separated by the line. They need to join on a.clientid=a.clientid and a.serial=a.serial and bring in the dttime field from the second sql statement and display all from the first..Any ideas. I'm in need of a sql answer. I've tried doing it in crystal where the end...
  18. Khanson82

    Returning Dates not in table

    If I have this below. How can I have it return dates where no activity happened so it will return zero values and I can pivot it and have all dates on top with counts below it? Right now it pulls all the dates for what I'm asking. The tables do not have all date stamps in them, so this would be...
  19. Khanson82

    Returning Wrong Value

    The field "d.dttime" is coming back null and it should have a date. Any ideas why it's not working? Sql Server 2005 Management Studio Express select b.clientname,a.agency, a.applid,a.caseno,d.dttime,a.applname, a.status, a.statusreason,'During Scheduling' as SchedulingProcess from vwapp0 a...
  20. Khanson82

    Add Column to End Report

    If I want to just add a column to the output of this report to say "during scheduling" for every value, basically so I can pivot off this field later, how would you do it? All I can find is alter table and add column ref. but that is not really what I'm trying to do I don't think.. select...

Part and Inventory Search

Back
Top