Great that looks v good.

Still trying to understand it all 🙂

Is the CTE Required_tiles wrong?

Should

CROSS APPLY topn(Groupid, diff)

be

CROSS APPLY topn(diff, Groupid)

The only way I've thought about doing is to work out the number of difference between the groups and use a cursor to allocate to these groups before using ntile...

Hi, The jobs are added in bulk so we may have 10 or 101 added at once.

They don't need to be perfectly allocated across all the groups tbh its probably...

Arr, I havnt explained this very well.

By peramiters I mean report peramiters not sp peramiters.

We have a web app that asks the users what date range they want to see,...

Can set dateformat be used within reportingservices?

How do you use it ?I currently use = Parameters!startdate.Value

Or can you set it to be report level?

thanks

dan

Hi, Changing the language of the report doent make a diffrence.

I've tryed setting it to english uk which doesnt make a diffrence, setting to english us it still wants a...