Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 System History

Author  Topic 

malmeida_colo
Starting Member

1 Post

Posted - 2005-11-09 : 14:26:26
I have a table with video information
(
Name varchar(30) null,
Serial_no int(12) null,
Agency_no int(8) null,
Agency varchar(30) null
)
When items are damaged they are sent to our agency #5. I would like view not only the items that are assigned to our Agency but also what Agency owned this equipment BEFORE us.

M. Almeida

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-11-09 : 14:36:16
Not sure what you need. How does "last record minus 1" fit in?

check out this link for how to get your question answered fast:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -