Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 2,894 total)

  • RE: Vbscript to check if there is any file in a folder

    If it's to hard...

    Dim fso, f, f1, fc, s

    Set fso = CreateObject("Scripting.FileSystemObject")

    Set f = fso.GetFolder("C:\Work")

    Set fc = f.Files

    ...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 24, 2010 at 11:16 am

    #1211185

  • RE: Vbscript to check if there is any file in a folder

    QQ-485619 (8/24/2010)

    Hi,

    I am looking for a vbscript to check if there is any file in a folder, C:\test

    If there is a file there, then reture failure, and if there...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 24, 2010 at 11:09 am

    #1211182

  • RE: Populate table as per validation

    Do you want to learn SQL or just looking for a quick answer?

    If the first, you can have a look two methods:

    1. Do insert and then delete in two separate...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 24, 2010 at 11:05 am

    #1211179

  • RE: Populate table as per validation

    thisisdeepthy (8/24/2010)

    I have little to no SQL experience so bear with me on this.

    I have a table say table1 with columns Title,surname,forename,address1,telephone,mobile,country and so on say 40 columns populated...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 24, 2010 at 8:37 am

    #1211058

  • RE: TALLY TABLE REPLACING LOOPS

    Could you please specify what is required output of your loop?

    And why your input table contains full duplicates?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 24, 2010 at 5:58 am

    #1210944

  • RE: add one column...condition other column

    If you want it to be faster (less scans and less reads) do:

    select ac

    , SUM(CASE WHEN my_order = 1 THEN bal ELSE...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 10:21 am

    #1208608

  • RE: Query Execution Performance

    Use Microsoft Time and you will get 2 sec or whatever you like without much of hassle 😀

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 9:18 am

    #1208562

  • RE: Foreign Key ...CHECK constraint

    SQL_DBA_3 (8/18/2010)

    Thanks ..

    I was looking for an reason why its behaving differently...Is there data mismatch which is foricng it for NOCHECK and then enabling the CHECK....

    I wanted the foreign key...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 7:43 am

    #1208485

  • RE: Foreign Key ...CHECK constraint

    SQL_DBA_3 (8/18/2010)

    Please advice ...

    Hornestly, there is no much to advise here...

    You believe functionality is the same on both the servers while FK are scripting differently in terms of CHECK vs...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 7:03 am

    #1208452

  • RE: Get spans from a table

    Here it is, to help you:

    -- you will need table with two extra columns for DateFrom and CodeFrom

    -- "select into" is quite fast even for large tables

    select *, CAST(null as...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 6:49 am

    #1208442

  • RE: Get spans from a table

    Use "quirky update"!

    Also, you may speed up my query by adding indices on Date and Code columns...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 6:17 am

    #1208420

  • RE: Get spans from a table

    Please test if performance is acceptable in you case:

    ;with termrec

    as

    (

    select t1.UserId, t1.Date, t1.Code

    from #temp t1

    left join #temp t2

    on t2.UserId = t1.UserId

    and t2.Code = t1.Code + 1

    where...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 5:16 am

    #1208398

  • RE: OPENROWSET not working from client machine..

    You may want to read through these couple of blogs:

    http://blogs.msdn.com/b/spike/archive/2008/07/23/ole-db-provider-microsoft-jet-oledb-4-0-for-linked-server-null-returned-message-unspecified-error.aspx

    and

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d92a73c0-9c87-4adf-a6a3-061a48b8dac5

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 4:45 am

    #1208387

  • RE: OPENROWSET not working from client machine..

    SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'Excel 8.0;Database=D:\CampaignInfo_MPM\MPM Questionnaire.xls',[Campaign$]) camp

    Where do you think this statement is executed? Connecting to SQLServer from Client PC and then executing the SQL statement - does not mean...

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 18, 2010 at 4:04 am

    #1208378

  • RE: copying 1 table with indexes to another same server

    Ok.

    Then I would advise to use SMO:

    http://msdn.microsoft.com/en-us/library/ms162169.aspx

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

    August 17, 2010 at 9:30 am

    #1207969

Viewing 15 posts - 2,371 through 2,385 (of 2,894 total)