THANK YOU!

Just a follow up question. If I run the query like 10 times a second affect the #MyList table? I mean could I get wrong buddys?

/Tomi

Thanks Brian!

Hrmm... How do I dump the Usernames to a temp table? I've never used temp tables in my whole life

/Tomi

damn, 5 answers in a day!

Thank you all! This really helped!

/Tomi

doh!

You guru - me stupid. I really can't believe I missed that. I mean the inserted deleted thing. I think my eyes and brain had a...

Hello and thanks!

I got an answer to question #2 but not to question #1. Or I got an answer to both questions, I just didn't get it

whohoo!

I acctually tried to do the same thing! I didn't figure it out.

Good luck, you'll need it.

If this isn't the greatest SQL forum then what is!? Once again I got exellent help. Thank you!

/Tomi

Hello!

Well, I'm making a message sending system. And this specific table will hold all the new messages. The messages won't be saved anywhere so I just delete them immediately after...

quote:

---

BTW, don't bother with the book, it's just a rehash of the FAQ that is available free online. There is a lot...

heyyyyy!

Didn't even know there was such a book! Maybe I'll by it!

/Tomi

Hi!

You wouldn't know how many posts this forum would have if I didn't search for the answer first I usually try google and some SQL sites...

IT WORKED!

I didn't even install the Sql2000 server just the tools! It worked immediately.

THANKS A LOT!

/Tomi

Thank you! I'll try that!

/Tomi

Thanks again!

I got your point but there is one thing tho. I got SQL Query Analyzer with SP1 and many other things too! (but no Enterprise Manager) But still, isn't...

Thanks Brian!

But the thing is, there isn't a single .msc file in my MSSQL folder! This is a quote from http://www.microsoft.com/sql/downloads/sp1.asp:

This download provides updates...