MAX and NULL does not work as someone stated, run this:

DROP

TABLE #t

CREATE

TABLE #t

(

value...

I'm not familiar with Oracle, but you might want to check out the stored procedures

sp_addlinkedserver

sp_addlinkedsrvlogin

They help you run queries on another server.

/HL

You might need to use:

sp_addlinkedserver - to make the other server visible

 & sp_addlinkedsrvlogin - to authenticate your call

/HL

I can't answer your question, but I have noticed that identical queries run from QA and

from an application can take radically different time. My conclusion when I ran across this was that...

When I simplyfied the table this way I realized that the solution is rather obvious. I'll create a new table insert the distinct MyValue values and generate the group ID...

Have you upgraded to SP4? I remember hearing that there was some kind of NULL-related bug in SP3a. I do not know if this was it though.

If you use .NET (presumably ) and load a dataset from the query you should be able to get the columnnames from the table...

If you use .NET (presumably ) and load a dataset from the query you should be able to get the columnnames from the table...

I have the backup restored on another server and can therefore check the actual sizes of the files. Therefore I think I can say with great certainty that there is no...

Unlimited, unfortunately.

/HL

Ok I'm going to my customer this afternoon. I'm going to copy the actual files (MDF & LDF) and then try to attach...

Yes, then it claimed I did not have enough memory. I know this to be untrue.

/HL

Dinesh,

Thanks for your suggestion. I Tried it now. The paths was incorrect, but when I corrected them the restore gave the same result.

Any other takers?

/HL

Can't say I'm extremly sure what you want, but it seems to me that you should be able to replace this line:

  set @plseq = (Select max(plseq)+1 from iams..poline

   where PLPO...

Well, I solved my problem, but not THE problem.

Instead of a function that returns a table variable I used a SP that stored the data in a permanent table and...