Viewing 15 posts - 271 through 285 (of 627 total)
J Livingston SQL (6/1/2016)
oh, how I love these lateral thinking problems 😛
if only the OP would post back with a sample data set that covers all possibilites then I could...
June 1, 2016 at 12:34 pm
Ok so after a few voodoo spells and a couple chickens later I came up with this. If it looks weird, that's because it is. I'm pretty sure...
June 1, 2016 at 12:12 pm
hmmm...yeah that throws a wrench in things. I just wished we knew more.
June 1, 2016 at 9:12 am
drew.allen (6/1/2016)
I would use DENSE_RANK() rather than RANK().
Drew
Good Point, no way of knowing of if the data has duplicate alert/product code pairs. I'll edit the code.
June 1, 2016 at 9:03 am
This MIGHT work but I'm not sure since I'm having a hard time understanding your requirement and I have a feeling your example data set isn't reflective of what it...
June 1, 2016 at 8:48 am
Steve Jones - SSC Editor (6/1/2016)
yb751 (6/1/2016)
The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been begging forever. I'm...
June 1, 2016 at 8:04 am
Brandie Tarvin (6/1/2016)
Anyway, has anyone heard about the latest data breach? I...
June 1, 2016 at 7:45 am
Hugo Kornelis (5/30/2016)
yb751 (5/30/2016)
This is great Hugo!On a side note it might have been worth mentioning that you'll need an enterprise edition of SQL to try it out.
You...
June 1, 2016 at 7:33 am
Christmas in June!!!
The purchase of some Red Gate tools finally got approved by my boss. 😀
Feels like I've been begging forever. I'm not trying to promote those tools...
June 1, 2016 at 7:24 am
Ed Wagner (6/1/2016)
Grumpy DBA (6/1/2016)
Ed Wagner (6/1/2016)
djj (6/1/2016)
FantasyMordor
Sauron
Ring
Diamond
June 1, 2016 at 7:07 am
Sergiy (5/30/2016)
yb751 (5/30/2016)
I've been using this report technique for years. Mind you, I have heavily modified it for my own purposes but it's a fantastic place to start.http://www.wisesoft.co.uk/articles/dba_daily_checks_email_report.aspx
In the...
June 1, 2016 at 7:06 am
I've been using this report technique for years. Mind you, I have heavily modified it for my own purposes but it's a fantastic place to start.
http://www.wisesoft.co.uk/articles/dba_daily_checks_email_report.aspx
May 30, 2016 at 12:52 pm
This is great Hugo!
On a side note it might have been worth mentioning that you'll need an enterprise edition of SQL to try it out.
May 30, 2016 at 12:06 pm
j-1064772 (5/30/2016)
Jeff Moden (5/29/2016)
There's no need to join back to the table to do the DELETE. You can delete from the table by deleting from the CTE.[/code]
Bringing this point...
May 30, 2016 at 11:48 am
Viewing 15 posts - 271 through 285 (of 627 total)