As I understand it (doesn't mean it's right), each salesperson is assigned to one or more geographic areas, and the customers are inside them, so it should be hierarchical. ...

That's what I thought... I have no idea how else to do this besides RLS. (Thanks for the warning of how much fun it is... at least now I...

I had seen that article before, I'm now I'm walking through it. I noticed that the locations were already geocoded, so that's how the solution works. I did...

FWIW, Yuri's code, ProcessAddress() that used Yahoo's geocoding services used to return the County, but that appears to not work anymore.

If I can't get that to work, is there a...

what happened when you tried it?

looks like the only thing missing is the ORDER BY clause to force a sort in descending order (so you get the highest values)

Before doing anything like that, know what you're getting into. Read this: [/url]

Gail explains in detail why this is a bad idea, and the one or two instances when...

I would check out Gail Shaw's articles. She writes extensively on transaction log management, and knows what she's talking about.

Maybe start here: [/url]

I disagree. Maybe check in the front end or the stored procedure used to write the data to the table, but changing a NULL to N/A adds absolutely no...

lonhanner (12/18/2012)

---

I have two tables (TRIP and TRIP_DETAIL both have the same primary key called TRIP. There is no FK relationship. I have data in both tables. I need...

I probably shouldn't muddy the waters, but there are two basic options:

1. a "push" from Access where you create a linked table (to the SQL Server destination) and...

Without an error message, I'm afraid I can't help you. :w00t: Can't diagnose what I can't see! Do it again and see if you can get an...

MSKB is your friend... that and Books Online.

http://technet.microsoft.com/en-us/library/ms188730.aspx

Did you unzip the database file(s)? There should be two - one is an MDF file (database file) and the other is the LDF.

Open SSMS.

Right-click on Databases

choose Attach Database...

You...

did you ever attach the database? does it show up under the Databases folder in SSMS?

What did you try? Did you try to attach it, restore it?