so there is no way right?

p-nut (11/16/2011)

---

david.moule (11/16/2011)

---

Do you have a business requirement behind this request? If so, what is it!

When you...

i want the last 5 rows based on last insertion...because i don't have any date time column...so how could i get it..?

more over my requirement is to get the...

Thanks guys....

yeah....:-)....just few seconds...

the worst part is i don't have any primary column on my table...so i am not able to get any records...

Dev (11/16/2011)

---

I can't explain my pain. I am posting here in SSC...

Hi Dev...did you check out with the query recommended by sumantaroy..?

i see no records as output...

Sumanta Roy (11/16/2011)

---

Did you just copy and paste the query and ran?

You need to change based on tables available in your database. I ran it and worked fine for me...

yes....i understood now....Thanks Dev...

Random Order...!!!?

but how come it gives same records every time when we execute the query..?

it must change the order right?

this query does not work....it gives no records....

ok, i understood...could you temme how top 5 works? in which order it works..?

i changed the protection level to encrypt with password...it worked out...

thank you ...

Hi,

it was very useful...it really had more information than i expected...Thank you so much...

i am always running the package on the client side....

so my confusion is do the client need...