Try this :

Select A.Key1, A.Key2, A.Key3, B.Key1, B.Key2, B.Key3 FROM BaseTable A INNER JOIN OtherTable B ON A.Key1 = B.Key1, A.Key2 = B.Key2, A.Key3 = B.Key3

Forgot to mention that it's gonna be an excellent refference for nulls from now on .

You either have an error in the Column or in the script.  A not null column will NEVER allow a null to be inserted.

Want to See Something Weird?

Now that...

I'll soon be available for a new contract.  Do you offer relocation (from Canada)?

PS I'll be in texas in a few weeks for a conference... maybe we can talk face...

"Thanks also to those people who post questions and replies. What I like about this place is that people are prepared to share their real world experience in order to...

I'm not sure I'm following you.  I'm gonna tell you to check out the datediff function in the books online.  That should help you with what you want.

I don't think you can separate those.  I'd agree with the 2nd newsletter being more usefull to power users and it might be a usefull new feature.  

But it would...

2 - Back the way it was.

You can format the html all you want but I want all threads .

Ok, if you can figure out what didn't work, could you please post it in the forum so it may help someone else in the future?

Sounds about right... What command did you use on the first reindex?

Again if we could know the reasons behind the shrinkage of the newsletter, maybe we could provide an alternative so we could get all the content out like it should be.

I rarely use the active thread page because the next / previous buttons don't work most of the time.  So again my only bullet proof option was to use the...

Do you have any text, ntext or image column in that table?

Not everyone has time or opportunity to share their knowledge... some answers can take 1 hour to figure out and write up.  So I guess that would make me the...

One thing to do would be to run dbcc updateusage. Maybe you're alright but some stat is not up to date.

Also might I suggest that you create a job that...