Have you tried copy-and-pasting the value of the @cmdstr variable into the shell and running it that way? Or have you typed it in yourself? (I see that...

padmaja.mantha (4/29/2008)

---

The select statement would give me all the records from the import table. I am able to do the bulk insert, but the problem is for just one field,...

My fault. I forgot a pair of parentheses when I was converting this from the function I use.

Here you go:

abs(3959 * ATAN(SQRT(1 -

...

What does the select do if you run it without the insert? How about if you run it without the inline function?

A partitioned table might allow you to do that, but not a regular table.

The main thing is don't skimp on it. Let TempDB grow. Start out with it pretty big, so it doesn't have to stop and grow all the time.

Pick...

Tomm Carr (4/29/2008)

---

The problem with any candidate key is that someone can come in afterwards and "what if" it to death. You can take any attribute and keep expanding the...

In what way is it not working?

Doesn't give you the results you expect?

Causes an error?

Something else?

That way of getting the running total will work, but it is a slow way to do it. There's another way, using an inline variable, that was in the...

That looks like a valid select statement to me. What's your create statement for the view?

The reason changing to float worked is because 50/69, in Integer, is 0. In Float/Real, it's .72464. Makes a big difference in the calculation.

Here's a formula for distance:

declare...

The problem with having a unique key on SSN is that it only allows 1 row with null. But what happens if you have employees in other countries where...

I missed that @Radius is declared as Int. Change that to Float too, please.

In SQL 2005, running xp_cmdshell is turned off by default. Have you turned it on?

It looks to me like your pseudo code is just a few table names and such away from being actual code.

Can you be specific as to the difficulty you're having...