Search results for query: *

Hi I have a bit of a problem. Below I have pasted the row_number function i am using in my code. However i want to select where RowNumber=1 in my where clause but it doesn't recognise it. could anyone help here. ROW_NUMBER() OVER (PARTITION BY item_key ORDER BY execution_time desc)as...

Hi Another question. I have a value in my table employees for eg. sender=15...... so this value is referenced by employees.sender...... for another column in my sql i want to add in 00 before the 15. How do i do this. i want the last column to have for eg 0015 0031 0051 instead of 15 31...

Hi Just wanted some help concerning flexfields.. how do i declare and call flexfields within my SQL code. whatever help you have would be very grateful kindest regards Lasd

Hi, I am currently trying to multiply out two numbers but i am getting some error. There is probably a simple solution to this but my head isn't working properly at all today i'm afraid. I would really appreciate someones help. select poll.quantity_received *to_char(nvl(poh.rate,1)...

Hi I am having a problem with character returns in SQL. I am extracting data from a database and one of the address colunns that i am extracting the data from contains character returns within the text. this is throwing my results out of sync and I cannot see the end of some of the address...

Hi I really hope someone can help. I am copying over files. I want to change the name of the file being copied over. I want the first one to start at 100,000 and increment from there. for eg. copy 1232.tif(source file) as 100000.tif and the second one to be 100001.tif and so on. here is the...

was wondering if it is possible to do the following. i am still copying the files but instead of naming them with the creation_date and component.path name i was wondering could i number them, say from 100000.tif up to the last file, which could be 120000.tif. for eg. copy file...

Hi I hope someone can help again. I am attaching the piece of code i am using to copy files from the components.path field over to another file in a different location. I am using a .bat file to copy over the documents. But where i am stuck is that i want to add in the creation date to be part...

Hi I was hoping someone could help me. I have written some SQL code to extract data from some tables. The data has been extracted but then i want to copy this data to a different file. The problem is that one of the fields(path field) contains some characters that i do not want. for eg...

Hi I was hoping someone could help me. I have written some SQL code to extract data from some tables. The data has been extracted but then i want to copy this data to a different file. The problem is that one of the fields(path field) contains some characters that i do not want. for eg...

Hi I am trying to get the receipt num and the quantity_received value to appear once and not to multiply all the way down when it is connected to the other table. Is my order by statement correct or should i be doing something else? thanks very much in advance for the help kindest regards lasd...

Hi I have pasted below part of the SQL statement i am using in my programme. I was just wondering if this is possible. I am selecting the supplier name and address. In the database for some of the suppliers there is no info for C_ADDRESS_LINE2 and C_ADDRESS_LINE3. Would it be possible within...

Hi I have pasted below part of the SQL statement i am using in my programme. I was just wondering if this is possible. I am selecting the supplier name and address. In the database for some of the suppliers there is no info for C_ADDRESS_LINE2 and C_ADDRESS_LINE3. Would it be possible within...

Hi, I am working on some SQL code for a report and from the code that i am copying in below i am getting back four lines. i know i am only supposed to be getting back two lines but can't see where the missing link it. Hopefully someone can help me. thanks in advance for help. greatly...

Hi Hope someone can help me here. I am currently working on a report. I am trying to add a parameter for flr.last_used to my report. Below is my sql code and i was going to do it like this but it isn't working. no errors come up but it doesn't give back any information. it blocks all the info...

Hi Hopefully someone can help me. I need to count the total number of items in a list of numbers ... I am just going to post the select statement i am using. in the code below i am selecting segment 1, amount, segment2 and amount. I want to put a total at the end of my report of the number of...

Hi again, hope again that someone can help me. In my database my date and time intervals are stored in a column with the format as Date/Time. eg. 12/04/2004 00:15:00. The information I want to copy into this table and field comes to me in the format of 12042004 0015. Is it possible to change...

Hi I hope someone can help me. I currently have two tables ImportTable and TestTable. TestTable contains two columns of data with approximately 3000 rows. I need to copy the information here into my ImportTable. My ImportTable currently has 15 rows and when I go to copy the data in i can only...

hi am trying to use the IIF function in my database. i have a column called interval(just wondering if my way of writing this is wrong. as this column contains a date and a time. If i write the time only will it pick it up in the query). what i want to do is say that if the value in this...

Hi all, I have built my tables and all of my relationships are set up now. I now have a problem with calculations. i will give you an example of what i am trying to do. Table1 lets say it has three colums. AE = 2.000 RAE= 2.000 APPE= this column is equal to the square root of AE to be...