malik_nagel (11/21/2010)

---

I have a computer that is NOT a SQL server and that has only ODBC access to an external SQL server. What is the best way to execute...

gotta agree; clean fast code that takes into consideration everything wer've seen so...

depending on the data, for example if it was always N{quote}{three chars}{quote}{Comma}

you might just use STUFF and a tally table to for to the length of the variable

first, it's a creepy requirement to uppercase everything without reviewing the data.

do a backup before you run the results of this query. someone undoubtedly did not think this requirement...

that's work pretty well, except for those rare cases when a variable between quotes ends...

IMHO, it depends on the syntax you are more familiar with to soften the learning curve.

.

learning a "new" language is really more about two things: learning the basic syntax, and...

wow, that was my best guess, As I'm on a listserv for Watin(Web Application Testing in .NET...IE/firefox browser automation)

i don't have IE8 at work, but this website has a ton of screenshots that might help;

:

http://blogs.msdn.com/b/ie/archive/2008/08/27/introducing-compatibility-view.aspx

there was no installation to do...i downloaded the command line utility i pointed at fromt he previous posts, then unzipped the contents of 7za465.zip into the C:\Utils folder; no msi...

what specific error do you get?

if you print your command before executing it, you could paste it in a command line window....does it work from there? mine does.(from teh cmd...

this may be related: when testing an automation tool, someone encountered IE8 being very slow.

there seems to be a Client setting in IE8 that you change to speed it up:

IE8...

ok here's a working example, parsed out and tested; i don't see any difference between what i posted from memory:

--Application.StartupPath & "\7za.exe", "e HDS_9.0.4.7.zip -o" & Application.StartupPath & "*.* -y")

CREATE...

the EXCEPT operator is awesome for this, but you can do this with left outer joins as well.

SELECT chartnumber, Dataofservices,CPT,Amount FROM TABLE1

EXCEPT

SELECT chartnumber, Dataofservices,CPT,Amount FROM TABLE2

that will give you lists...

i believe it has to do with collations.

on my SQL 2008, i get all rows back unless i compare with a binary collation:

declare @tab table(foo nvarchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS)

insert into @tab...

duplicate post.

follow this link for the more robust question, as well as code examples using 7zip:

http://www.sqlservercentral.com/Forums/Topic1022139-5-1.aspx