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...
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"...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.