Recent content by roody91

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.

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...

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

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

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.

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...

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...

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...

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...

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...

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...

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...

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

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...

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...