Thanks!

I think I sort of figured it out now

Thanks!

One question tho. If I copy the .mdf file and put it on another computer, it copies all the records, right? I have done this a few times. But does...

Hello!

So what your saying is that I should use a cursor Or am I mistaken?

/Tomi

Thanks Steve!

But I can't get it to work with three DELETE stamements. Because when I use

Sender = @Sender AND Receiver = @memID

the rows in msgPopup have already been deleted....

Thanks Andy!

Ok, then... I'll do it in another way

/Tomi

Hello Steve!

Sorry, but I don't know what that means. Could you please give me an example.

/Tomi

Thanks, guys!

Once again this forum turned out to be the best place for SQL help! And it's all free

Thanks again!

/Tomi

Ok, thanks!

I think I what I'll do. Thanks

/tOmi

Hello!

Would a timestamp do? Can it be used as a datetime? Or am I totally wrong?

/tomI

Doh!!!

So, that's the way it's done! Thank you!

That is propably the fastest way of doing that

Thank you!

/Tomi

Ok, here's what I meant...

I have two SPs. And I don't think either one of them is as fast as they can get. This is the first one: