Viewing 15 posts - 9,961 through 9,975 (of 15,381 total)
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...
November 27, 2012 at 10:21 am
Krasavita (11/27/2012)
sorry this an error:it should be Can't generate SSPI Content
But what is the EXACT error message? If you google your version you will find dozens of links that explain...
November 27, 2012 at 10:12 am
Yeah I know; I wasn't the one that wrote it though.
But you COULD be the one to fix it. Your solution is still using a horribly slow way of doing...
November 27, 2012 at 8:44 am
Krasavita (11/27/2012)
I got another letter from IRS.
MY sql server regestered under not local account,how can I fix it?
Thank...
November 27, 2012 at 8:39 am
rich_a_wms (11/27/2012)
November 27, 2012 at 8:33 am
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...
November 27, 2012 at 8:27 am
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...
November 27, 2012 at 8:09 am
leesider (11/27/2012)
November 27, 2012 at 7:53 am
haagendaz (11/26/2012)
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...
November 27, 2012 at 7:35 am
amar_kaur16 (11/26/2012)
Thus I think that students who have...
November 27, 2012 at 7:29 am
SQLUserC (11/26/2012)
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...
November 26, 2012 at 2:49 pm
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...
November 26, 2012 at 2:46 pm
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...
November 26, 2012 at 2:40 pm
amar_kaur16 (11/26/2012)
Could you please explain?Thanks,
Blyzzard
What part don't you understand? I am not even really sure if this meets your criteria.
November 26, 2012 at 2:25 pm
Please don't cross post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1388809-392-1.aspx
November 26, 2012 at 1:46 pm
Viewing 15 posts - 9,961 through 9,975 (of 15,381 total)