Sounds like you either have too much text (6 characters into a 5 character field) OR you have characters that won't work in a varchar field (Meaning characters from the...

Well the last day of September is always the...

challapal (7/6/2012)

---

string starts with 3 digit same number Example 111Y,333Y, 555 H etc

string starts with NULL

string that starts with sequential digits Example 123g, 567jku

string that...

mtassin (7/6/2012)

---

Nah that gets you a point post... if you look at your correctness...

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...