Why not split the two types out inside SSIS:

select someData, ISNUMERIC(someData) As NumTest

from test

WHERE ISNUMERIC(someData)=1;

The example is kind of overdone, but the idea is that you can test/filter for whether...

It's because they know how to use the Force, and we don't...

Silly Us!

Might do that... they have Access and VBA is easy... forgot about doing pass-through queries... Makes a nice front end, but not my favorite as a backend.

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