Not to sound short, but,  if you cannot tell if you have a SQL server,  Are you sure you should be asking how to import a database?

you may want to...

don't forget that you can make an external datasourse in excel and just run the query.  makes the data live.

tal

hi,

you may want to try making a VARCHAR to put the string in then passing the param to the command

Just be carefull the xp_cmdshell is a dangerous proc as it...

Hi,

You could build a User defined function that is recursive.  I do not have a SQL server handy so i cannot give you the code. 

here is a link that...

Just a few more pennies worth,

If your intent is to have available a search of all of the addresses no matter what the contact type (Sponsor, vendor, etc) then your method...

That trick rates in my top 5. 

Right up there with Celko's Nested sets Hierarchy.

I cannot wait for a time to implement it.  Thanks for sharing

Tal

thats an interesting solution,

i have never seen anyone parse a string like that.  nice trick!!

tal_mcmahon

Hi,

I can show you how, but I think having the VB do it is a better solution.

all you need to do is use a While loop not a for next

declare...

Hi,

I do not have a SQL server in front of me to test this so I am only going to be able to give you a vague direction to go.

I...