Not sure if I understand you problem, but a good starting point as ever is Books Online. for more advanced examples try any SQL book or have a look at the scripts on this site.