Recent content by DarkWorlds

Well I need to re-arrange my output in a way that works without doing 52 lef joins. basicly the output is as follows. store|week|profit 5|1|25000 5|2|15000 5|3|9850 Well I need the following _____|week1 |week2 | store|profit|profit| How can I do this with a select and not do 52 left joins?

You found my error. I just wraped my head around this project for so long I wasnt fully breaking down the issue. Thanks. Works flawlessly now.

Both tables refenced are using the same primary key, which is s_number + cust_number... Noticed I have in values e.cus_number instead of cust_number. This error is not present in the code and is correct. So for the code written here is should be e.cust_number. Sorry about that. *wishs there was...

The following code errors with: ORA-30926: unable to get a stable set of rows in the source tables Cause: A stable set of rows could not be got because of large dml activity or a non-deterministic where clause. Action: Remove any non-deterministic where clauses and reissue the dml. What am I...

Thanks this worked as I needed it. Now time to post a new thread for help. Thanks all.

Well I guess im having a brain fart of epic magnatude today, but i guess finding the one with the most current active date would be fine. How would I do this? Like i said, big brain fart today (i need vaca, lol)

My first questions involves union I am joining months of tables together all with the same fields. I am assuming union would be the best shot? But I need something that is quick. Secondly when this is all said and done (all 12 tables into one) I need to get the max inactive date, and max...

Everything runs fine. The select without the left join works and the select in the join its self works. Everything as far as i can tell is there. All the table names exsist and all the colomns called are there with info.

PO.CURRENT_STORE = ORG.ORGANIZATION_NAME should be CAP.CURRENT_STORE = ORG.ORGANIZATION_NAME Sorry I am trying to come up with a demo and everything. But I have to do it on the side, I guess in the mean time I will just work with 5 other tables and one of those being a recursive table (every...

ORA-00904: "ORG"."ORGANIZATION_NAME": invalid identifier Its there, because if I comment out the lines I said above it works like a charm. Is there no way to compair it to a second table?

Ok this is something very similar to what I am facing, but dumbed down. None of these columns or tables names exist in real life (Very paranoid company I work for, understandable though) but the fundamental problem I am having is like below. Basically I know I could have done something similar...

N/M got it :)

That worked well for me, but how would I also do it from the right, found something new I have to eleminate

Ok I had a question on something. I have a field with names in it, and sometimes it has two. AKA Bob and Jill Well I just want to select the name before the "and". How would I go about doing this? Also the "and" could also be "&". I look forward to your reply

As I found out, but I didnt want to call the person out on it. Im just looking for a way to fix this. Because if I find a way on this, maybe ill fix my other issues. I look forward to the replies. Wish I has asp.net 2.0 and the other goodies that comes with it. My problems would have been...