Viewing 15 posts - 1,006 through 1,020 (of 8,731 total)
August 30, 2017 at 10:10 am
August 28, 2017 at 10:12 am
August 28, 2017 at 9:59 am
Here's the simplest option if the table is already like this:
SELECT ID,
CASE WHEN [2017_07] > 0 THEN 0
WHEN [2017_06] > 0 THEN 1
August 28, 2017 at 9:11 am
August 28, 2017 at 8:49 am
August 25, 2017 at 11:59 am
Thank you for the good ideas. Sure, exceptions can be made and this will be used by DBAs (or selected developers), the problem is that we're development DBAs and the...
August 25, 2017 at 11:56 am
Brandie Tarvin - Friday, August 25, 2017 10:50 AMIt depends. Do you have access to xp_cmdshell?
I don't, they claim is...
August 25, 2017 at 11:03 am
I know it's Friday, but can someone give me a hint here?
https://www.sqlservercentral.com/Forums/1893830/Delete-Extended-Events-file
August 25, 2017 at 10:43 am
August 25, 2017 at 10:17 am
Chris Harshman - Monday, August 21, 2017 1:01 PMEDIT: second time today someone beat me to it 😛
I just got...
August 21, 2017 at 1:14 pm
Maybe something like this? It considers that the only values for the char(1) columns are Y or N.
WITH CTE AS(
SELECT m.ID, d.Group_Num, ROW_NUMBER() OVER(...
August 21, 2017 at 12:59 pm
August 18, 2017 at 7:36 am
ilay.siva - Thursday, August 17, 2017 12:27 PMStuck with 2 things here.
9. ______.b.c.d - Across
8. a.b.______.d - Down.Any clues ?
a.b.c.d...
August 17, 2017 at 1:18 pm
Viewing 15 posts - 1,006 through 1,020 (of 8,731 total)