d'oh...

Reading another thread I think I found my answer, I believe I can use the rownumber function to accomplish what I am looking to do.