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 Chriss Miller 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: *

  1. roody91

    Build date time table

    Angel, your name truly fits. Thank you so much! The only change I had to make was putting the (@TheDateTime) in () INSERT YourTable VALUES (@TheDateTime) Have a wonderful weekend. Thanks again. Frank B.
  2. roody91

    Build date time table

    Hello, I am trying to figure out a way to build a table of each hour of every day from 1/1/2003 through 12/31/2010. The table needs only a single datetime column. It will be used to develop a shared datetime dimension in analysis services that other tables with "real" datetimes will...
  3. roody91

    between times in a date time field

    How do i program a column to show a shift based on the time value od a date field ie if the time portion(HH:MM) of the date time field is between 07:30 and 16:30 then 'Day shift' if between 16:30 and 23:30 then 'Eveneing Shift' etc. Thanks, FB
  4. roody91

    converting string HH:MM:SS to number of minutes

    Thanks for your help; before your reply I got this to work: numberVar HH := ToNumber(Split({ClosedTkt.HO DUR}, ":", 3)[1]); numberVar MM := ToNumber(Split({ClosedTkt.HO DUR}, ":", 3)[2]); (HH * 60) + MM
  5. roody91

    converting string HH:MM:SS to number of minutes

    I've tried but this fails. 4458:55:00 is not a valid format for time. If I try ISTIME() crystal returns a false. I must find a way to strip out the value left of the first : as hours and the value between the first : and second : as the minutes.
  6. roody91

    converting string HH:MM:SS to number of minutes

    I have a string field that shows hours, minues, seconds in the following format HH:MM:SS. This field does not map to an actual time format because the hours part could span tousands of hours ie a typical value could be 4458:32:00 which means 4,458 hours, 32 minutes, 0 seconds. I would like to...
  7. roody91

    Switch Statement Help

    Hello, I have a string field that shows hours, minues, seconds in the following format HH:MM:SS. This field does not map to an actual time format because the hours part could span tousands of hours ie a typical value could be 4458:32:00 which means 4,458 hours, 32 minutes, 0 seconds. I would...
  8. roody91

    Build view from formula or joins

    Hello, I need to build a view which will be used as a fact table in an Analysis cube. I'm having alot of difficulty trying to extract data from the detail table I'm pulling information from. This is a sample of my detail table clrAlarmTest: alarmID clrDT...
  9. roody91

    Split then combine two datetime fields

    Hello, I do not know much about VBscript but i need to use it to manipulate some data imported to SQL Server from an Excel spreadsheet through DTS. I have two datetime columns in a spreadsheet one has the valid date and the other has the valid time (I know this is dumb but it is how info is...
  10. roody91

    Create Chart on Averages

    i have a report in which I've calculated the average of a running total of a datediff field divided by the distinct count of a key field called ticket#. I have #rt, sum distinct count, @avg formulas for each group(one of which is month) in the report and as well as a total for the entire report...
  11. roody91

    from rows to columns

    cbeggan I've tried the your script and it does work but ..... I'm trying to convert the row data into individual columns for each resp1, userid and date time value with the alarm_id being the "key". Your script is great but it throws all the data into a single column. Any ideas on...
  12. roody91

    from rows to columns

    Hello, I hope I don't offend by barging in on this thread but I have a very similar problem to resolve and am very new to SQL programming. My data is such: alarm_id date_timestamp resp1 object va170711 1/25/2003 12:09:44 AM PC b56fwjr va170711 1/25/2003 12:10:26 AM...
  13. roody91

    Updating data from other rows within same table

    Thanks again! This works great. I actually got it on my own before I read your last response. I had been placing the where clause in the wrong location in the message. Thanks for you help
  14. roody91

    Updating data from other rows within same table

    Mean Green, Thanks! your solution seems to be working except for one thing. I believe it updates all records no matter the action_a value(there are about 12 possible values). I would like to only update the records in which action_a = 'new'. I tried adding a where clase before the join but I...
  15. roody91

    Updating data from other rows within same table

    I have a table that contains many records 6 mil today and may grow to over 20m when done. I have a column called alarm_id which can be common to different rows of data. I have other columns called action_a and userid. When a new record comes in with a unique alarm_id the action_a filed is...
  16. roody91

    Create chart with more than 2 "On chage of fields"

    Is it possible to create a chart with more than 2 "on Change of fields" I have a report that groups by: Month closed | |-> Region (3 different Regions) | |-> Technology (2 different Technologies) I build a line chart with the "On chage of&quot...
  17. roody91

    Using Save As to create subreport: Selection causes Data to Disappear

    Hi, I found the problem to be the selection criteria. For some reason the report now does not work when I use the "is equal to" option in the selection criteria. Instead I must use the "is not one of" option to get my data to display. As you can imagine this can be time...
  18. roody91

    Using Save As to create subreport: Selection causes Data to Disappear

    Hi, I've built a rather large report for an entire distrcit that I must also show broken down by Manager level. The data/formulas at the manager level is almost identical to the district level. My plan is to save a copy of the original report with the Save As command. In the new copy of the...
  19. roody91

    Lotus Notes / Report Integration - Newbie

    I built a Lotus Notes database which resides on a Domino server. I loaded CR 8.5 Pro on my PC and have written several reports. I would now like to integrate the reports into the Notes DB using RDC(with an action button). I have ordered the upgrade to Developer edition for the RDC. Crystal...
  20. roody91

    Can groupname be maipulated to show fields from a particular record?

    I am doing an org. chart from a Lotus Notes personnel database. Each employee has a record w/ name, ssn, address , supervisor name, manager name, etc. I am grouping by manager name then supervisor to show the organization. Instead of just the manger or supervisor name appearing as groupname, I...

Part and Inventory Search

Back
Top