This matches your description of your business rules but it doesn't match the data you said you wanted. Not sure which one is correct because you said

so if Student initial...

Please read my original post, especially the second part.

There is nowhere near enough information to offer much help. It seems you...

Not without some ddl and sample data. Take...

wafw1971 (2/12/2013)

---

I have a Site Table that has a Site Weighting Column, each Site is weighted between 1 and 4, I am currently working on the Capacity table and want...

There is nowhere near enough information to offer much help. It seems you could use the techniques described in this article to achieve what you are after. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

If that doesn't...

You have really messed up the case expressions. There is no need to check case of a value and you left off the end.

CASE --@StartDate

WHEN (SELECT SiteWeighting FROM Site WHERE...

Very interesting Dwain. I tried another idea to see how it would hold up. It seems that it is possible to use another temp table to hold the replaced values....

ahpitre (2/12/2013)

---

Great. Thanks for the prompt response. Do you think that the code could be modified to be recursive, in other words, if I send 1 delimiter, code within function...

Do you have any triggers on the customer table?

Jeff Moden (2/11/2013)

---

Andy Hyslop (2/11/2013)

---

I recently has to take a written SQL test for a client and one of the questions got me stumped (from memory was something like this):

Why...

No worries. Great minds...

Actually begin and end...

Please take the time to read the first link in my signature about best practices when posting questions. If you post ddl, sample data and desired output in a format...

This looks a lot like a catch all type of query. Take a look at Gail's blog post about this. It explores a number of methods and comes up with...

Thanks for the setup Lowell.

There is no need for a cursor here. A cte will work just fine here. The actual rules are pretty vague but I think this...