Thanks again for sharing. Modern T-SQL gives us many ways to skin a cat.

I had a the best results from this query. Works really well over the huge table. Thanks 🙂

Thanks all for sharing. I'll let you know which has the highest performance. Haven't used the SIGN() function before 🙂

Best

Lee

I favour agile approaches to BI. There is no better proof than the pudding 🙂

I still think even with user stories we can still run into problems. I...

I got it working in the end. I misinterpreted the /user as username.

Neither of these things worked. When I try running as a different user I get a message : The security database on the server doesn't have a computer account...

Ooh, I like the look of SQL prompt - I'd pump for it myself if I could use across client sites.

I'll be sure to check the tools out.

Much of my work is spent at client sites on their environment. I'd be happy to suggest commercial products to my team...

Thanks for all your comments - very useful insights indeed.

This is a great community.

Best

Lee

I'm trying to create a diagram/schema using a query as an input i.e. joins will be shown as links to other tables. More to aid documentation rather than...