Well your first case condition is wrapped with double quotes. If that doesn't fix it you need to provide ddl and sample data that is readily consumable (meaning I can...

I think you just figured how to get them back yourself. 😉

You're welcome. Glad that worked for you.

If a users enters @Degree data, that mean that they want all the candidates with a specific degree.

The problem is that since people may have up to three degrees, i...

That is better but...nobody can run that. We are all volunteers around here and nobody wants to...

isuckatsql (7/5/2012)

---

I got the syntax to work, but the results are incorrect.

if (@Degree <> 0)

Begin

if (' p.Degree1id ' > ' p.Degree2id ' and ' p.Degree1id ' > ' p.Degree3id ')...

And FWIW from the description and the cursor you posted I don't think there is any need at all for a cursor. Cursors are notoriously slow and should be avoided...

It isn't just the links but making them a bit more clear helps. From what you posted nobody can run anything. It is impossible to test sql when there are...

Bobby Glover (7/5/2012)

---

Probably an easy one but I have a table (TABLE A) which is nserting data into another table (TABLE B).

The data types on the tables are not in...

Rich Weissler (7/5/2012)

---

It's worse than that. The author said...

pnpsql (7/5/2012)

---

i am begginer and knowlede of cross apply , if it can be done by cte it is more helpfuly for me to understand and modify as...

No worries at all. It just helps when you put...

SQLRNNR (7/5/2012)

---

You can detach and attach. I would not proceed down that path without having a good backup though. I like to proceed cautiously and make sure I...

Wow this is truly is the worst type of question. You have to answer it correct according to BOL AND read the authors mind at the same time. Then come...

Hi and welcome to SSC. It seems that you still have an unanswered question or two? It will greatly increase your chances of getting help from people if you post...