You can check out Aspose - They offer a solution that gives full Justify - Test is thoroughly though before you buy - It doesn't seem to like Sub reports...

Thanks for your reply but that only allows me to select whether the data uses the primary or secondary axis - not the position of the axis 🙁

Regards

Andy

Hi John,

Thanks for that. I realise I can do this I just wondered if there was a way of getting the text out of SQL without hard coding a...

What I need to do is to display the time left in years and months. So knowing tghe number of months left is not a problem what I need...

Cheers Steve,

That's what I thought, just wondered if there was any smart way to do it though 🙁

Andy

Sorry added this to 2005 by mistake - it's a 2008 query

Full backup is exactly that - Everything

Differential backup is all of the changed pages since the last full backup

Transaction log backup is all of the transactions since last transaction log...

Sorry guys / girls,

I was going to post execution plans etc - But there's something odd going on with our dev server at the mo - so not sure they'll...

There are a number of tables / indexes in use here - What I don't get is if I've just updated stats how it can be so massively wrong

Hi Gianluca,

Silly question but how do I identify bad parameter sniffing? I am running the sp with identical parameters on each run and get massively different performance.

Regards

Andy

The problem turned out to be one of statistics. Some of the stats were quite a way out of date. Updating the stats didn't make any difference until...

That would make a lot of sense - I'm going to get the stats updated and see what the effect is

Cheers

The new Index is called idx_LiveCertificateSummary_OwnerID_EndDate_StatusID

If I leave the index - it obviously uses this index and it's quick

If I then drop the index it uses a slightly different index with an index seek...

So if I run the query without doing anything = SLOW

create and drop index = FAST

Recompile = SLOW

So what does creating and dropping the index do - Even without...