Thanks Kenneth and Scott. I will reexamine my queries with this in mind.

-arjun

Thanks a lot for the response Steve. I am sorry I took some time to post. Weekend Fever!! 🙂

sjimmo (8/13/2010)

---

I would definitely create my indexes/PK's after the data is loaded....

Gentlemen, thanks for the answers. I have more questions. I will post them a little later. I am currently using my phone to browse. I would like to add that...

Travis, you should be more careful when you comment about things you are not sure of. I donno where you have got all these info from. Anyway as i said...

I agree Steve. Tax deductions and any such benefits for this purpose is not reasonable.

@travis - i did not mean trade. I used the wrong word; my mistake. Trade...

Exactly!! If the administrators look within, they can find the solution to these problems. There was definitely a time when all 'stuff' was not made in China or some other...

OK, I guess I will stop now. I do think all people should be employed. The unemployment problem that prevails now should be arrested. And I do agree that the...

I didn't answer you buddy. I live in India and your guess is correct. I don't put much of what I earn back to US, except for the stuff i...

Well, Travis I assume your question is addressed to me. Firstly, I was not talking about Indians within US. An average Indian is very stingy. I do agree to that....

OK folks, I read what you think about the whole outsourcing issue and its implications. I agree to the general opinion here that if you are smart enough, you can...

Well, the article is in good taste and I agree with you that if an employee adds value, he will not be laid off or his work will not be...

lol, no it is not the employees table. As i said the scenario is similar but not the same. And i don't have to show values from all the rows;...

Arjun Sivadasan (7/22/2010)

---

Brian, Thanks for the article. I have a question here. I am not gonna post the DDL scripts as I have used your sample tables.

Consider the following statement...

Hmm learned a few things here. Thanks folks.

- arjun

bayudw, i think the row_number() solution will be faster than the query you currently use. check it out and share the execution time/plan.

- arjun