well if you are doing the same query over and over again you should use a sp. since then its already compiled and will run quicker.. but for most querys that you do only one time its not really worth writting the sp.

__________________
iSearchNotes.com - Share College Student Notes | Blog