Recent content by monkeylizard

Problem solved.... We'll call that an undocumented feature of the app's export/import process. I suspect they expanded the field in the export file, but forgot to change the size in the schema creation script. Thank you George. Out of curiosity, is there a switch for the BCP command that...

9.0 4 1 SQLCHAR 0 32 "\t" 2 SESSION_KEY SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 32 "\t" 3 HIT_KEY SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 512 "\t" 4 NAME...

I have an export from a 3rd party application in a tab delimited format. The exported file is flat text, tab delimited, and was designed to be fairly generic for importing into a DB (SQL, DB2, Oracle, etc). One field in the export is text. According to the app's documentation, the destination...

I could be wrong, but I thought that the BCP was executed using the login rights of whoever is logged on to the SQL Server. So you may have writes to the G: path, but if the same network path isn't mapped to G: on the server, it won't work. Monkeylizard Sometimes just a few hours of trial and...

Nevermind. The code shown in the last block works fine. It was a second variable that I dind't tell you guys about that I was stringing in that was NULL and that was clearing the whole @TEXT variable. Oops. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes...

I need to add some additional text to a text field. We'll call the field NOTES. Assume that NOTES on a record contains a value of 'This is the first note, added on 04/18/10 4:26:08 PM.' I need to make the field have a new value of: 'This is the first note, added on 04/18/10 4:26:08 PM. This...

I was wrong about the <<>> being find/replace. They are indeed "fields" in the word document. It looks like an IF on the fields may do the trick. Thanks, everyone. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

Possibly. I'll look into it on Monday. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

Thanks everyone. That gives me something to go on. At least now I know it's probably possible to do what the business owners want, it's just beyond our current internal skill-set. A consultant may be in order. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes...

Tag" may not be the right word for this. Basically the 3rd party app has a list of predefined words that I have to encase with the "<<" and the ">>". when it finds one of it's predefined words in that encapsulation, it replaces the whole "tag" with the value of the database field that it...

I have a document template that uses find/replace tags. A 3rd party application opens the template and saves a new instance of a document after doing a find/replace on the tags. For example, the address section of the letter may look like: <<CUSTOMERTITLE>> <<CUSTOMERNAME>>...

Crowley16, I must be mistaken on app roles. I thought the connecting app had to tell SQL which app role to activate for the connection. Is that incorrect? Thanks for the Program_Name() and suser_name() values. That's helpful. Is there also a way to collect the actual SQL statement being...

I had used Gavona's second idea, putting the overs in C and the unders in D. That actually works just fine. SkipVought's SUMPRODUCT formulas give me the same result and much more concisely without the need for columns C and D. Thank you everyone for your help. Monkeylizard Sometimes just...

erm...I noticed the obvious mathematical error.I know 10-8 is not 8. oops. But the questions still remain. Thanks. Monkeylizard Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

I need to total the differences between two columns into Over/Under totals. I need to know how far over Column A is than B, when value in column A is > B, and vice versa. I'm not talking about the net difference, but more of an IF logic. Example: ColumnA ColumnB 10 5 10 8...