Forum Replies Created

Viewing 15 posts - 451 through 465 (of 529 total)

  • RE: Concat Null difference between two servers

    Maybe you could run Profiler to monitor the SQL statements beeing executed by your application? If everything is identical they should execute the same kinds of statements but it could...

  • RE: VBScript command-line performance question

    quote:


    It seemed to slow down as it went along.


    Could it be an issue with your...

  • RE: How much do you earn?

    I thought Italy was uspposed to be a low taxed country in the EU, but it seems now that I was quite mistaken by that information. 17% in the USA...

  • RE: How much do you earn?

    bond007:

    That sounds highly interesting. 80% is a very high figure and to me I would acquire it only in my dreams. Do you know anything more abour these umbrella companies?

    ...

  • RE: How much do you earn?

    How about Tax considerations?

    Here in Italy we have (right now) around 4 types of contracts where the tax levels are very different. With all the different laws concerning what you...

  • RE: Slow performance of update statement

    quote:


    (...)

    I altered the procedure to copy the parameters into variables and the update to use these variables. This fixed the speed...

  • RE: Return 1 column of many child rows as string

    Sorry guys :/ I was too hasty in responding, I had not tested my solution before proposing it. And you are right, it seems quite difficult trying to solve it...

  • RE: Return 1 column of many child rows as string

    Why not solving it with a nested select instead of the UDF? Preformance shouldn't be so much different though...

    Hans

  • RE: Assign a variable value based on conditions

    My two cents:

    When debugging SPs' in SS there is an extremely important new feature in QA 2000. Debug. Open up the object browser,rightclick on your SP and choose DEBUG....

  • RE: Select statement

    Even if the discussion is already concluded, here is another efficient way of solving it:

    SELECT * FROM (SELECT TOP 3 * FROM Users WHERE [ID] <= 7 ORDER BY [ID]...

  • RE: Output to file

    Here I have a couple of cents to dice out:

    Writing a file line a time seems abit to much of the programmatic approach to SQL, doesn't it still mean that...

  • RE: date problem with SQL 2000

    After some tests I happily note that I have learned something new and alot of old code can go in the trash or get some nice modifications 😉

    Thanx to 5409045121009...

  • RE: DTS to Excel Spreadsheet

    Okay. Problem solved. With the SubObject CustomTask it is possible to write to the SQLStatement property.

    Thanx everyone!

  • RE: DTS to Excel Spreadsheet

    With an SQLTask it is possible to do a CREATE TABLE on the Excel connection. Is there anyone who knows how to modify the SQLStatement property of this task? I...

  • RE: DTS to Excel Spreadsheet

    Ted Langewisch: Thanks a bunch! That seems to get me exactly where I want! Now I am only down to Creating my Table (sheet) at the destination. And if VB...

Viewing 15 posts - 451 through 465 (of 529 total)