any recent version, including the latest version2.2. they all support command line for version 2.0 and above, and maybe earlier verisons.

here's the command line syntax doc:

http://www.coreftp.com/docs/web1/Command_Line_FTP.htm

hunt (9/19/2011)

---

I hope there is a confusion with my question.

I am not asking why my insert was falied ...am asking why SQL server accepts such a conflicting range of...

text to columns? do you mean that is 'rows to columns", or also known as a pivot or unpivot query?

the pseudocode you've got so far is not really enough for...

ColdCoffee you are right of course, but at least the function would be available for the duration of the migration/parsing she was doing;

i kind of assumed she was splitting data...

be sneaky and...

i've got a couple of suggestions for you;

here's a function CHARINDEX2, which allows you to find the nth occurrance of a string within-a-string:

/*

Example:

SELECT dbo.CHARINDEX2('a', 'abbabba', 3)

returns the location of the...

did my example work for you?

here's my best guess featuring a left outer join, but it seems wierd for my inner query alaised as MYTOTALS: i'm getting the accoutn number, and the distinct count...not sure...

i didn't see any relationship between the two queries, so i could only assume a CROSS JOIN would be right.

does this do what you are looking for?

SELECT

a.accountnumber,

...

you can wrap the commands for all 15 alters in a single transaction though...so you can make sure it's all or nothing.

SET XACT_ABORT ON --bailout and rollback on any error...

however, if htey connected using a SQL login, the windows username is not available in any way, shape or form, unless you specifically code an application to get the information...

well, this is syntactically correct, and a good basisi for the way I would do it; i changed your @body variable name, i hate having a local variable the smae...

piece of cake.

add some CSS to the top of your command to put the default style on the td tags.

my example here is using font size 11 points...change it to...

kewl!...

ACinKC (9/16/2011)

---

I've done things similar to this (importing mainframe data into SQL) using SSIS (and Business Objects too, for that matter) and it was very straightforward and easy. Is...