Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

convert a PLSQL to T_SQL for a function Expand / Collapse
Posted Sunday, May 5, 2013 10:52 PM



Group: General Forum Members
Last Login: Today @ 8:09 PM
Points: 5,676, Visits: 11,186
sqlfriends (5/5/2013)
the goal is to get the first record returned by those columns ordered.

Do you actually mean "the last record"?

If you're after the current address, than it must be the last modification recorded, not the first.

And how does that HouseModifier work?
When you are recording a change of address - what's actually happening?

P.S. The table sripts do not contain any indexing. Is that true - no indexing whatsoever?
Post #1449580
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse