you must specify an ORDER BY clause with your select query with TOP...

Without specifying ORDER BY sql server will give you any random no which is not correct

thanks Chris....

got you query...

can you please explain...

Hugo Kornelis (7/22/2013)

---

kapil_kk (7/22/2013)

---

(...)

In this example after putting clustered index we will data in ascending sorted order.... while before adding clustered index data was not coming in an order...

I am...

Hugo Kornelis (7/22/2013)

---

kapil_kk (7/22/2013)

---

John Mitchell-245523 (7/22/2013)

---

kapil_kk (7/22/2013)

---

Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will...

John Mitchell-245523 (7/22/2013)

---

kapil_kk (7/22/2013)

---

Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will reorder of the...

hakan.winther (7/22/2013)

---

kapil_kk (7/22/2013)

---

PRR.DB (7/22/2013)

---

If table doesn't have clustered index , there is no guarantee for order , if table having clustered index then result will display clustered index column...

what error message you got?

PRR.DB (7/22/2013)

---

If table doesn't have clustered index , there is no guarantee for order , if table having clustered index then result will display clustered index column order.

Is my...

you can create two foreign key constraint refering table table1 and table2 in your new table table3...

Thanks Pramod for the question.....

Can you please post the table strucutre with some sample data.....

You can also refer this link posted by Gail to another forum:

http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

Can you please some more information to us?

Like, what is your data n tables and what output you want from that.......

the information that you have provided here is not that much and we cant able to give you proper solution...

please provide some more details...