Hi,

It seams to be not that easy/possible to catch this at server-side.

I'm going to dig into the code and seach for those temp tables (and centralize it :-)).

Thanks for the...

Thanks for the replies.

Does any one else have an idea how to solve this?

grtz

Jo

Hi Chris,

Your query works fine.

This is for a paid project. But before I wrote it all in (scripting-)code and I wanted to go more to a multi-level development with...

Hi,

No, it's denormalisez because of me. (one of my mistakes).

But it's to much work to modify it in the current project.

A lesson for the future projects. 🙂

Now testing your...

Hi Chris,

I'll make it easy for you. We have no development policy for SQL yet. I'm working on it.:P

Hi Chris,

I'm using a view on two tables:

ALTER VIEW [dbo].[vw_VBR]

AS

SELECT dbo.VBR.ID AS VBR_ID, dbo.VDR.ID AS VDR_ID, dbo.VBR.ret1, dbo.VBR.ret2, dbo.VBR.ret3, dbo.VBR.ret4, dbo.VBR.ret5, dbo.VBR.ret6, dbo.VBR.ret7,

...

Hi Wilfred,

This is application is not for firefighters :).

It's used to measure the toxic level of gasses in a factory who creates microchips and semiconductors.

My program needs to export the...

Hi,

I tried indexing all the other columns with a non-cluster index. But the max is 16. Now I only use a clusterd index on FLTIME in each table.

My program works...

The clustered indexes on FLTIME does my program run a lot faster with almost no time outs.

I'm going to try again with non-clustered indexes on all other columns.

Thanks for the...

First of all, thanks for the response.

I will try adding clustered indexes on FLTIME in the three tables. And run my program again.

The execution plan can I give you, but...