Well your constraints do prevent bad data. It certainly makes updates more of a pain to deal with. I guess the issue really is denormalization. There are certainly times when...

But what is the EXACT error message? If you google your version you will find dozens of links that explain...

But you COULD be the one to fix it. Your solution is still using a horribly slow way of doing...

Krasavita (11/27/2012)

---

When I am trying to login from my pc get in error message:

I got another letter from IRS.

MY sql server regestered under not local account,how can I fix it?

Thank...

rich_a_wms (11/27/2012)

---

I found an extra space after the , and before the state in the city_state column. Problem solved and all is well. Thanks Jeff for taking the time and...

I would highly recommend NOT doing that. It will cause you untold pain in the future. You are proposing to violate normal form which will cause you far more pain...

The reason that so many people have viewed your issue and not responded is because it is not clear what problems you are facing from what you posted. In order...

leesider (11/27/2012)

---

OK, as I said in my last post I need to extend it a little further to include a running total. Cadavre is correct, I don't need a cursor....

haagendaz (11/26/2012)

---

Thanks for the quick reply Sean!

The last catch to my problem is that I then have to join this created table to other table(s) (actual tables).

Do you know how...

amar_kaur16 (11/26/2012)

---

Your query is selecting all the students who have selected Math only but the Marker field is empty for all the returned students.

Thus I think that students who have...

SQLUserC (11/26/2012)

---

Hey all,

I am running into an issue where rows are appearing in a table where the primary key is not present in a base table. A foreign key constraint...

That is what the query I posted will show you.

Here is another way to get the same results, but it has a bit more complicated execution plan.

select StudentID, Case when...

I think the important concept here is that you want to view it, that means it is in the front end. It relatively trivial to do this in .NET or...

What part don't you understand? I am not even really sure if this meets your criteria.

Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1388809-392-1.aspx