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!

Recent content by skijop

  1. skijop

    CASE statement?...if then...to show only certain records?

    I need to return only certain rows based on some logic: (for each sets of episode nbr and mpi id, if there is a ranking of 1, then ONLY show 1) ELSE (for each episode nbr per mpi id, if there is NO ranking of 1 then just return all rankings no matter what) Is this case statements?? I want to...
  2. skijop

    SQL loop to calculate fields???

    Any examples to point me towards....?
  3. skijop

    SQL loop to calculate fields???

    bed id - discharge_date(stat17) - date_amount 26294 - 1/6/2007 - (diff between 1/6/07 and 1/17/07) 26294 - 2/17/07 - (diff between 2/17/07 and 2/28/07) Basically at every status 17(per each bed_id)to a different client_id, the difference of the effective_dates. I basically...
  4. skijop

    SQL loop to calculate fields???

    Going to try to push this out to a table in a data warehouse....The database that I am using won't allow writing of temp or reporting tables bc of security. Amazing,right?
  5. skijop

    SQL loop to calculate fields???

    I dont have the luxury of creating temp tables in this case...It would just have to be some sort of loop to calculate....?
  6. skijop

    SQL loop to calculate fields???

    Is there an easy way to calculate a datediff of date/time field(effective_date based on the change of another field (client_id) changes by bed_id ? AKA when status_code_id is 17 for a row, then the next row is a different client_id, calculate the datediff of effective date from these 2 rows...
  7. skijop

    2 fields on one line in Detail

    Does anyone know how to do this? All I really want to do is to have this on one line instead of 2.
  8. skijop

    Custom sort in Crosstab

    A stored proc is not an option. Is there any examples of building a manual cross tab with conditional formulas??
  9. skijop

    2 fields on one line in Detail

    The id3 and id14 are related bc they have the same form_id The dates refer to the same person by client_id. Here is a better rendition of how the data goes together. client_id form_id type_ID Desc datevalue 5999 01 3 admissiondate 5/7/07 5999 01...
  10. skijop

    2 fields on one line in Detail

    (CR ver 10) I have 2 lines with 3 fields, but i have to compare id14 to id3 lines to get a comparevalue field (want to show whether admission date is >,< or = to completedate). ID Desc datevalue 3 admissiondate 5/7/07 14 completeddate 6/1/07 I would like...
  11. skijop

    Custom sort in Crosstab

    Is there a way to have all rows/columns show up EVEN if they have 0 as a summary total? For example I would want to see all of the last row, but right now I am not. a b c priority 5 10 2 welcome 4 8 7 financial 0 0...
  12. skijop

    Custom sort in Crosstab

    Is there a way to have a custom sort (not alphabetical and not by summarized field. My current crosstab looks like this: a b c financial 5 10 2 priority 4 8 7 welcome 4 9 3 This is in alphabetical...
  13. skijop

    Cross Tab not suppressing section expert formula

    Row field - formula {@admit} Summary field - count of client_id Cr version 10
  14. skijop

    Cross Tab not suppressing section expert formula

    My @pack formula is as follows: if ({Command.sequence} = 13 and {Command.std_assess_id} = 11569) then "Priority Pack" else if ({Command.sequence} = 27 and {Command.std_assess_id} = 11569) then "Welcome Pack" else if ({Command.sequence} = 51 and {Command.std_assess_id} = 11569) then "Financial...
  15. skijop

    Cross tab percentages dont equal 100%

    ...in CE 10
See more

Part and Inventory Search

Back
Top