Assuming they are all production I would let windows and sql manage memory.

Allen

Hi Ramesh,

Thanks - I'm completely sorted on this.

Completely understand about painting the full picture but sometimes I want to precis the info to make it digestible (or no one will...

Hi Both,

I probably did not give you the full story. I'm only matching credits & debits where the absolute values are the same so I think I can include the...

Doh. Thank you Ramesh. I had'nt thought of that. It works a treat plus I even understand it !

Allen

I can do this

SELECT c.AccountNumber, MIN(d.debitID) AS debitID, c.CreditID

FROM #Credit c JOIN #Debit d

ON ABS(c.CreditAmount) = d.DebitAmount

WHERE d.debitID < c.CreditID

GROUP BY c.AccountNumber, c.CreditID

and get this but the second row...

Hi Jeff,

I'm not sure if 'Packing Join' is the correct name but it's all I have right now. Being as I got your interest I'll be cheeky and post some...

Thanks David, that too is news to me.

Are there any *Nice* gotchas?

Thanks Jez & Steve,

Of course I _KNEW_ my data was the same....but it wasn't.

I was using a SELECT INTO and the IDENTITY function with an ORDER BY which I was...

...or

Have a look at Cross-tab reports in BOL.Go to the search tab and search for

Pivot and you should see an entry.

I think it might not like the () brackets.

EXECUTE master..xp_cmdshell ('dir *.exe')

EXECUTE master..xp_cmdshell 'dir *.exe'

A big thanks David & Jeff.

I _do_ now understand the code, I was focusing (obsessing) on the join and not considering the SUBSTRING

Another good day at school!

Hi David,

That is very cool, I have not used a numbers table before. I see by running it that the Number points to the start of each delimited string.

I guess...

Hi David,

Thankls for this, data does indeed come from a table. I'll give it a try, I _think_ I understand what you are doing.

Allen

Hi Jeff, Thanks for your interest.

The function takes a comma delimited string and splits it up. It takes three parameters 1. an account number 'clacc_no' 2. a date and 3....

Hi Peter, Thanks for the reply.

My 2005 function was trying to build a TABLE variable taht I could join to using CROSS APPLY.

Because I can't CROSS APPLY in sql2k I...