Viewing 15 posts - 451 through 465 (of 529 total)
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...
June 27, 2003 at 3:37 am
quote:
It seemed to slow down as it went along.
Could it be an issue with your...
June 23, 2003 at 2:43 am
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...
June 19, 2003 at 6:14 am
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?
...
June 19, 2003 at 5:53 am
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...
June 19, 2003 at 5:33 am
quote:
(...)I altered the procedure to copy the parameters into variables and the update to use these variables. This fixed the speed...
June 18, 2003 at 9:40 am
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...
June 9, 2003 at 6:08 am
Why not solving it with a nested select instead of the UDF? Preformance shouldn't be so much different though...
Hans
June 9, 2003 at 3:55 am
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....
June 6, 2003 at 2:44 am
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]...
May 29, 2003 at 7:59 am
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...
May 29, 2003 at 6:18 am
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...
May 29, 2003 at 1:50 am
Okay. Problem solved. With the SubObject CustomTask it is possible to write to the SQLStatement property.
Thanx everyone!
May 28, 2003 at 10:08 am
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...
May 28, 2003 at 9:38 am
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...
May 28, 2003 at 8:02 am
Viewing 15 posts - 451 through 465 (of 529 total)