Search results for query: *

I know this is possible, I'm not sure how to go about it using Oracle's Scheduler. I simply want to create a special "queue" that I can submit jobs to which will run one after another. After they run, then then are gone. There many be no jobs at anyone time, and then at other times I may submit...

That is great, but the problem gets more complex. In the sample table there are samples with the sample date. Meaning a sample may have 5 samples associated with one date. There is a sample_no in the table and a sample_id. The sample_no is associated with the date and the sample_id is the...

I have a SQL problem. I need to join 3 tables. I have a tables a users, with a user_id primary key. I have a table of locations which references the user table using the user_id. I have a table of samples which references the location table with a location_id key. It looks like as...

I need to join to tables of data. I have one table of chemical sample results and another table of chemicals. I need to join the tables in such a way that for all the chemical sample results I get the chemical, but I also want all the other chemical even if there is no result for that...

I have a tricky sql question. What I am tring to do, is group some data in a table by a user_id and then grab the top 2 rows for each user_id which I grouped. Is that possible? MY_TABLE ======================== User ID Data 1 23 <-- 1 20 <-- 1 10 2 23...

I have a sql problem I have data in a table like the so... MYTABLE -------------------- USER_ID IND DATE 1 Y 10/20/2002 1 N 11/20/2001 1 Y 12/20/2003 2 Y 10/22/2002 2 N 12/20/2003 And so on... I need to grab...

Here is my situation... A Table exist with fields that accept NULL values. Views and Indexs have also been created from that same table. I now want to update the original table so that the fields do not accept NULL values (NOT NULL). Is it neccessary to re-create the views and indexs if I...

I have developed a small Visual Basic application and integrated a report using the RDC component for Visual Basic. I have install the application on another computer and wish to run the app by any user using the computer. When the user has Admin rights and I directly connect to a MS SQL...