All passwords are encrypted, I would never store them as plain text.

My Mistake I meant a nonclustered Index to those columns.

In regards to your other response i.e Maybe, maybe not....

Thanks for the responce, that's very similar to the query I have. I'll add the non clustered indexes to those columns.

Another question regarding indexes, I have other columns like...

ha ha, Ok you have lost me now.......

Kristen-173977 (9/17/2015)

---

If your User Base is less...

Kristen-173977 (9/17/2015)

---

How do you feel about 65K users? Chopping the UserID down to...

Ed Wagner (9/17/2015)

---

I think your basic design is good, although (as others have suggested) I would take a serious look at how many users you're going to have on your...

I've just managed to get resolve this, I changed my where statement to look like the following:

where

(p.id = @userid or p.id = @SenderId)

and...

I've managed to get this to work by doing the following :

Select p.Username, count(mr.RecipientId) [TotalMessages],

(SELECT COUNT(*) FROM [MailBox].MessageRecipient where RecipientId = @userid and ReadDate is null)...

Hi thanks for the sql script, I was looking at outlook actually trying to figure out how it works etc, I won't be interested in read receipts, flags, or anything...

Hi thanks for coming back to me, would you be able to provide me with a code sample as I'm trying to grasp your concept , also would your solution...

Hi All,

Thanks for the responses, I would like to touch base on that you mentioned regarding a parent table.

How would this parent table look? i.e what columns would it have?

When...

I understand where your coming from I assumed we were still on the same page in regards to what I posted after the first code sample was provided i.e regarding...

Apologies on the late reply was pulled on to another project, that sadly didn't work, can any suggest anything else?

Hey, can anyone shed any light on this please I've been battling it all day I tried checking the count of TVP and then saying in my where clause @Count...

Correct, I was informed this would be a required field but the spec has now changed whereby this is optional so if they pass is null for @TVP I want...