Forum Replies Created

Viewing 15 posts - 8,401 through 8,415 (of 13,460 total)

  • RE: Zip Files

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 8:04 am

    #1252534

  • RE: Zip Files

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 6:33 am

    #1252463

  • RE: Extremely slow rendering in Internet Explorer 8

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 6:05 am

    #1252439

  • RE: Zip Files

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 5:43 am

    #1252423

  • RE: compate two table

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 4:37 am

    #1252391

  • RE: wrong select result using like on nvarchar column

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 4:32 am

    #1252387

  • RE: Zip File

    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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 4:07 am

    #1252373

  • RE: Zip Files

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 3:13 am

    #1252362

  • RE: Views and base table permissions

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 2:58 am

    #1252355

  • RE: Connection string custom attributes

    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,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 2:48 am

    #1252350

  • RE: Export SQL Table(only one table) data to multiple csv worksheets using SSIS

    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 ...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 2:42 am

    #1252348

  • RE: Zip Files

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 18, 2010 at 2:34 am

    #1252346

  • RE: Datetimme Stamp

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 17, 2010 at 2:51 pm

    #1252171

  • RE: Weird differences in duration after clearing caches

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 17, 2010 at 2:43 pm

    #1252168

  • RE: Zip Files

    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...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 17, 2010 at 12:50 pm

    #1252114

Viewing 15 posts - 8,401 through 8,415 (of 13,460 total)