A self join should allow you to do this... I've shoved it into a CTE, but you might be better with a temp table or something so you can index...

Hi Adil,

There's nothing out of the box with SQL or Management Studio that I'm aware of.

I've always used Red Gate Source Control for this in the...

Hi Torrid,

Sorry, I think I'm probably missing something, as I'm not too sure what you're saying with regard to the billing cycles, but can't you just aggregate...

Hi mate,

Yeah, I don't think you're going to find a perfect solution to this. You're just going to have to try to find the solution that fits your scenario best....

Hi there,

Sorry, this isn't going to be a direct answer to your question. I'm not an Azure guru, and I try to avoid triggers where I can, but I thought...

Nice one Lowell, that's much more elegant than my solution!

Surely the only way you'd achieve this is with dynamic sql, which would be an absolute pig to maintain. Could you combine the various table you want to query into...

You're after something like this I guess? - Obviously this is rbar, you'd be better trying to adopt a set based approach using a pivot or something if you can,...

Paul,

It's isn't it the convert that throwing it off? When I've done this sort of thing before I've always had by hash as a computed column (obviously persisted and indexed...

As a quick win, could you not just set the On Failure Action of the job step to be "Quit the Job Reporting Success"?

Sounds to me like you have a an operation in your sp which can affect the way the optimizer calculates the plan. This could be something like a parameter in...

You just need to replace the .noc out on the join. ie..

from t1

join t2

on t1.cola = replace(t2.cola,'.noc','')

Regardless of Login, your SqlServer Service Account will require NTFS and share permissions to the UNC path. Have these been set up?

Something like this I guess?

Just as an FYI loads of people have looked at this q but nobody has posted. I'd have thought you're a lot more likely to get...