Hmm, solved one problem but got another one instead: when I checked the entries for the year 2005 I saw there are records with datestamps for July, August etc. As...

Yes, this works a lot faster. I still don't know why DTS is so slow, but I think I'll opt for the import from Access instead of the export from...

The data have to be supplied to users who do not have Sqlserver on their own system, and have no access to our sqlserver.

We're only talking raw data here,...

Datatransfer: from sql server to Access

I have a set of 12 views, one for each month.

I created a DTS in which all the 12 views are used to pump data over...

I tried to create a view but the DTS returns 'data type mismatch in criteria expression'. The view it created is as follows:

select `A_x`.`datestmp`, `A_x`.`typeID`, `A_x`.`streamID`, `A_x`.`nr`, `A_x`.`volume`

from `A_x`

where `A_x`.`datestmp`>='1/1/2005'...

If I execute the select-statement (from Query Analyser) it takes about 2 minutes per month. Every month consists of the following statement (see example for Januari 2005):

SELECT      nr, streamID, datestmp,...

Hello Terry,

no luck yet, my last trick would be to add the account that I use for running the agent to the security list of the root folder for each...

c7,

Thank you for your time .

I can't seem to find any difference in security settings between the named and the default instance, while Agent on the named instance works, so I changed tack.

I need the agent...

There are two locations where I found SQLAGENT.OUT, one for the default instance, one for the named instance. There are no other SQLAGENT.OUT files on this machine; also the entries...

Thanks for the reply.

I checked the security settings of the folders of the default instance. The account that I use to run the agent under was not there, so I...

But only if I use 'WITH TIES'?!

The other thing is that TOP 2 could also be TOP 5, or TOP 20 (I want to fill in a number for this,...

But what if the dates are so randomly distributed that no date is the same?

Anyway, this concept worked like a charm for the statement I was looking for.

May I thank...

Yes, I will check on this.

Frank, how would the query be if I have more than 2 different names? If the number of different names is dynamic, can I...

Thank you for your answer Frank. Indeed what I ment was the top 10 of the table, but then per name.

For the following example not to take up too much...