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

sure.

on the 7zip web site:

http://www.7-zip.org/download.html

the fifth Download link explicitly says

"7-Zip Command Line Version"

download that, the syntax is inside.

to zip a file based on your previous example, the command...

it's by design.

access to base objects is not ownership chained to views/proc/functions that access that object. so when accessing the view, permissions to the objects that view access is not...

via tsql, those custom attributes are not exposed, i think.

the application name and the host name are...if you do not provide it explicitly, the driver populates it for you automatically,...

i think if you create the CSV, it would have ALL the records...it's just earlier versions of excel would only DISPLAY 65536 rows.

open the file up in an enhanced ...

ningaraju.n (11/17/2010)

---

Hi Lowell,

When i executed the query which was mentioned by you,I got the list of files hence I hope the problem is not due to the path.

Regarding the winzip150.exe...

looks like the dates were simply converted to decimal to me:

/*--results

(No column name)(No column name)(No column name)

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 08:30:51.263

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17 00:00:00.000

2010-11-17 16:50:38.717404982010-08-17...

just a basic double check....after clearing cache, the FIRST time a proc gets run, it's slower, as a new execution plan gets created, adn that takes time...but subsequent calls after...

is winzip150.exe a GUI? that might be an issue, especially if it is raising that nag screen about registering...you know...you've been using Winzip for 483 days....

you need to use an...