I'm sure others will talk about things like pay, whether you prefer just doing the DBA work or if you're good at talking with the Business about what they require...

Would definitely help to post some sample SQL re the User table and the Group table but I'd assume you'd identify the Groups the User has access to either as...

nigelg99 (4/6/2010)

It is pretty cool :-). It's a text representation of the Mandelbrot Set.

I ran it in SSMS, then right clicked the...

No, they're looking at Stored Procedures to try to figure out what Lehman does!

No worries; so long as I get my email notification about new posts I'll return to the thread (though I regretted posting in the "Are the questions on here getting...

Works perfectly...

Wow, that works astoundingly well! First run against Production Data was 3 seconds and 0 seconds for runs after that. You're going to force me to rewrite a few existing...

Of course! I promise I'd never be so laissez-faire when someone is using their valuable time to help me on here.

I found that while it would work perfectly for this...

Hi Paul. I don't think that solution works if Table 2 doesn't contain the Max Date from Table 1. Your other solution works perfectly though.

Finally managed to test all of...

Sure thing. I'd taken Paul's "Never mind then" comment as conceding it didn't work having not tested it myself. If he's in NZ, Code I'd written at that time of...

Thanks guys!

I'm glad you mentioned the performance aspect, Arjun. Unfortunately (for me!) @Table1 reflects the largest table I ever have to use. Merely doing a "Select * from" just now...

That's alright. My original question had been about determining whether there was a better way to do this and it would appear that there isn't (barring converting the While Loop...

Hi Wayne,

I'm nearly there (for some reason, it took me ages to realise the correct way to get the correct month ends I needed in "dateadd(d,-1,dateadd(m,N,(dateadd(d,1,@StartDate))))". I just wasn't thinking...

Thanks Wayne, will use that Tally Table for the Month Ends and see if it improves it tomorrow morning (just checking this before heading off to bed at the moment)!

Sorry, the Function produces Fund Manager Information, e.g. Manager Name, Portfolios, Securities, Net Asset Values etc. It's table-based as you can therefore imagine. It's probably best if I include the...