Search results for query: *

Morning/Afternoon all... Can some one tell me how i can age records, I have 4 years worth of data which needs to be flagged into 4 categories: 3-6 mths 6-12 mths >12 mths old. I then need to apply a set of rules to the above. Thought i could use something like (MONTH(traffic_month) =...

Hi Does anyone know how i can select a substr() of a timestamp field...? The data within the field is stored as 12-JUL-04 10.00.36.000000 AM and i need to pull out certain records within a particular time period. Thanks for any help provided. N

Hi could someone help me with trying to determine the duration in seconds between 2 dates...? This is what i'm trying to do : select START, RELEASE, (TO_DATE( SUBSTR(RELEASE, 1, length(RELEASE) - 4), 'YYYY-MM-DD HH24:MI:SS'))- (TO_DATE( SUBSTR(START, 1, length(START) - 4), 'YYYY-MM-DD...

Hi everyone I'm not much of an Oracle person however i would appreciate it if someone could help me out here... I have a table with various fields which are varchar's and i need to convert them to a datetime format... This is the format : 2004:05:10:15:39:43.477 Hope someone can help...

Hi Could someone tell me if there is a function within Oracle that is similar to SQL Servers DATEDIFF...? I need to establish the difference in seconds between two dates in the following format : 2004:05:10:16:04:33.12 Thanks people....

No idea how i would go about this, completly new to awk, but does anyone know how i would do the following : I need to pull from a file all lines where the line has AddressStringDigits in it and CallTypeLevel1,2 &3... and enter into a new file For example : CDR 25,( AddressStringDigits...

I'm sure this is a really basic question, but is it possible to select a whole diagram and reduce the size of it on the page...? Thanks in advance

Is it possible to show a Int value as a decimal..? I am trying to work out a variance based on a total difference/total*100, my datatypes are integers and the result returned is 0. Is this possible...? Here is my query and results... Thanks for any ideas. SELECT TMI.[Date]...

Hi all, Does anyone know if there is a simple way to select from a datetime field, something similar to that of TRUNC in Oracle... I'm fairly new to SQL Server and seem to being having an absoloute nightmare with dates....!! Any suggestions welcome.... Cheers

I have a problem converting a Varchar datatype into a numeric field.... The values in my table are to 3 deimcal places and are of datatype varchar. When i use Convert(decimal(10,3),col7) for a value of .0123 it returns the value .012. Any ideas how i can convert a varchar to numeric but...

Hi all Got a simple query, need to get the row count from a file. Can anyone provide me the correct commands...? Cheers

Hi all Got a simple query, need to get the row count from a file. Can anyone provide me the correct commands...? Cheers

People, I am trying to return the first existance of a row within a table even if there are more than one entry. For example abc exists in table X three times. abc < once i have found one entry where abc exists then quit abc abc Can anyone help please....? Cheers Nick

Does any one know if it's possible to kick off some ORACLE sql from an Access front end using VB...?

Does anyone know why i would receive the following error...? Cheers Nick ERROR at line 27: ORA-01555: snapshot too old: rollback segment number 29 with name &quot;R1_S09&quot; too small

Can anyone suggest how i can group by the two categories 'Inbound' & 'Outbound'...? The select doesn't seem to do this.... Here's an example of the results....... Grateful for any help.... Inbound 0961 .0012549 .05 Inbound 0961 .0050196 .2 Inbound 0961 .0138039 .55 Inbound 0961 .0100392 .4...

I have a 450mb file which i'm unable to FTP across to a common user area on a Windows NT platform...... The question i am asking is there anyway to slice the file up into a number of smaller files so i'd be able to FTP...? Or is there some other method.... Thanks in advance from someone who...

I'm not much of a UNIX man but if i have 31 files which i need to mould into one file i need to use which command....? Cheers in advance....

Can someone tell me how to generate a file called xxxxxx.sql using spool xxxxxx. I don't want it to create a file called xxxxxx.lst Cheers

Would someone please explain to me why i get the following errors whe running a simple query i am using to highlight duplicates.... ORA-12801 error signaled in parrallel query server P024 & ORA-01651 unable to extend temp segment by 3200 in tablespace TEMPORARY1 Grateful for any comments...