Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Sunday, May 5, 2013 10:52 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, October 13, 2014 8:08 PM
Points: 4,573, Visits: 8,353
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