Search results for query: *

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?

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...

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...

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...

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

Ok I was not able to get anything in the two other threads I started started. So finely I sat down to do something VERY simple. But it seems its broke. What I want to do is disable the button whuile a query runs to get the download. Well it does that just fine. Excepts it never un-disables the...

Ok, well i know this may look like I posted up something similar a dar or two ago. http://www.tek-tips.com/viewthread.cfm?qid=1372576&page=1 Well since no one can help me out on that, then I need to move on. This is yet another please wait. But I am having a problem getting the demo to work at...

The site I’m working on gets a local list, and then has to compare it to a list on a server elsewhere. So time will be taken up. So I wanted to implement a "Please Wait" thing. My current setup seems to work fine. I get the “Please Wait” but it still goes after the operation is complete. That’s...

Ok right now I have an issue I was hoping to solve. I currently have a query that pulls up 1.9 million people It pulls the following and all of these are unique by the pull. No duplicates in the bunch. Account_ID Account_Status Account_Type Account_Holder_Name_First Account_Holder_Name_Last...

Ok I have something interesting. I have 3 cat ids to look up by date and display them in a column. The one I did before had 1 id per date and there was 52 (1 per week per person) So it was 52 left joins! So now I am wondering what to do now? I don’t want to have 156 joins! Needless to say I...

--If this post several times im unsure why. It kept erroring on me. Well I am finishing a small part of a project, but ive never seen something written up this way. After researching its done really well, but this leave me clueless on how to sort it, mainly because im used to messing with...

As you may all know I am new, so forgive the dumb question. I have a column that has data that varies in length of 3-5 characters long. Well I need to select the first 5, and if not it needs to add a 0 in front till it is 5 character long. How would I go about doing that?

First let me describe what im doing, I have to create a report from a single sql query. While im learning I do need to get further help. These are the Columns and what they do, and how it should lay out. Column 1 = number Column 2 = number Column 3 = 6 digit number (id#) Column 4 = String...

Well this was something out of the book, but has been modified to do a few more things i need it to do. Right now im just trying to get the delete feature working. Its supposed to delete the closest to the mouse click, but instead what its doing is deleteing the first one in the array list. I...

Well I am in a bit of an issue, and I need help asap. Everything is figured out, even doing testing and it works. But when i throw it into a for loop it just dies on me. private void Read() { FileStream fs = File.OpenRead(FILE_NAME); BinaryReader br = new BinaryReader(fs)...

Im supposed to be doing Inheritance on the console line, and well all is semi ok. But what im confused on is how do this in a windows design. I am trying to complete something, but I dont even know where to start. I was hoping someone could help me. Here are what I need for classes. And what...