Nathan

Create a Windows group containing all the users that need access to the database.  Then grant that group access to the server, that is, make it a login on the...

Dean

From your sample data, an inner join will be enough:

SELECT RestName, FoodName, r.Group

FROM Restaurants r INNER JOIN Food f

ON r.Group = f.Group

However, what happens if there is a...

Yomesh

What are you referring to here?

John

Are you getting an error message?  If so, what does it say?  Chances are that the account you are logged in as when you use DOS is not the same...

How do you define "invalid"?

John

Peter

I'm not sure what it is you're trying to do.  Information_schema views are built in so you can't create them.  Please post the SQL that you are trying to run...

UPDATE t2

SET distinguishedname = t1.distinguishedname

FROM staffdetails t1 JOIN staffdetails2 t2

ON t1.displayname = t2.displayname

John

James

I think the key is to do your delete in small(er) batches so that it doesn't fill your transaction log up in one go.  Before you do that, read in...

Do you not have your own picture you can use?  That's what I did.

John

Choose My Profile from the My Account menu near the top of the page.  Then click on Avatar, where you can upload your picture.

John

Glenn

This is one of those issues where you can waste days trying lots of fixes that don't work.  Or you can spend half a day blitzing  the whole thing and...

Stephane

The scan is scanning the whole index (the whole table in the case of a clustered index) whereas a seek goes straight to where it needs to go to find...

Terry

I don't have access to a SQL Server 2005 server at the moment, so forgive me if the syntax isn't quite correct.  Use a common table expression (CTE) something like...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=209497

Stephane

OK, that clears up the IP conversion algorithm.  I still don't think that your sample data from tbl_ip2countries and from #regions tally up with each other, but let's not worry...