Talis Developer Network - SQL for item count at a given classmark - Comments

count for a given classmark

Brian Crampton — Tue, 29 May 2007 12:48:06 +0100

Can you post the SQL you have written? It might only need a tweak or the reason for the lower number might be explained.

Also have you looked at using Talis Decisions?

Thanks

Brian Crampton
Developer, Talis

SQL for item count at a given classmark

CTHOMAS — Tue, 29 May 2007 11:50:08 +0100

I'm trying to find out how many items we have in stock in the classmark range 600 - 699. I have run what I think the sql should be, but I am getting far fewer results than I would expect.

As my sql leaves a lot to be desired, wondered if someone could help me work it out? Thanks