This has been on the backburner for a couple of weeks, and, guess what, I've been asked to amend the fifo logic once again....test code below:
--===== If the...

Hi Chris,

Finally able to get back on with this!
Much appreciate your earlier input but unfortunately there's been a request to change the fifo logic somewhat and is probably best shown...

Hi Chris,
Many thanks for the reply. Not as yet had chance to test your code as I've been dealing with another client. Hopefully get back on with this in...

Hopefully, this is more useful test data:
--===== If the test table already exists, drop it
     IF OBJECT_ID('TempDB..#myStockTake','U') IS NOT NULL
         DROP TABLE #myStockTake

--===== Create the...

SELECT 'A01' as bin,'1' as seq,'180022' as product,'11' as qty,'21' as expectedqty,'-10' as stockdiff,-10*42.11 as GainLoss UNION ALL
SELECT 'A01A','2','180022','0','3','-3',-1*42.11+-2*42.11 UNION ALL
SELECT 'A01','1','180023','5','6','-1',-1*42.11 UNION ALL
SELECT 'A01','1','180026','15','13','2',2*42.11...

Solved.
Went down the route of using SQL table to hold intermediate results. Then queried that to get xls output.

version 2000,

thanks

Thanks Gail for the info.

Much appreciated.

Hi,

I thought that may put people off!

Unfortunately I do not have permission to save execution plans on this db (its a third party one..we only have read access).

With regards to...

Of course. I'm unfamiliar with spt_values having used numbers tables in the past).

Many thanks,

Dom

Hi Ken,

Many thanks for the reply however I'm not getting the results as expected. Is there a potential error with the date generation bit of the code?

The below creates...

Hi Ron,

Thanks for the reply but Crystal Reports XI doesn't support table variables.

For info/closure I've rejigged the code supplied by Chris to work with my clients SQL Server 2k db.

SELECT...

That's great Chris...very useful (and can be adapted for various uses)

Unfortunately I'm not allowed to create sprocs! Just writing 'sql commands' is rocket science to those who require the reports!

Once...

Thanks for the reply Chris,

I'm actually trying to write a 'Sql command' in Crystal Reports. I've a report that lists application usage over time....I'm trying to find usage or lack...

Hi,

does this get you started:

To get a list of the top-level folders and associated user permissions:

SELECT Catalog.Name, Catalog.Path, Users.UserName

FROM Catalog INNER JOIN

Policies ON Catalog.PolicyID = Policies.PolicyID INNER JOIN

PolicyUserRole ON PolicyUserRole.PolicyID...