Viewing 15 posts - 661 through 675 (of 1,838 total)
is it possible the SQL Agent job is setup to "go to the next step" on step failure? Maybe you can look at the job history a different way:
November 15, 2017 at 1:56 pm
November 14, 2017 at 12:39 pm
November 13, 2017 at 4:41 pm
OK, here's a couple of questions for you to think about:
1. Can you have an Equipment row without an Order?
2. How many Order rows can an Equipment row...
November 13, 2017 at 3:12 pm
If all you want to do is allow users to see execution plan, it's probably preferable to just do a GRANT SHOWPLAN:
https://technet.microsoft.com/en-us/library/ms189602(v=sql.105).aspx
DB_Owner would probably be overkill...
November 13, 2017 at 2:54 pm
November 13, 2017 at 11:05 am
Phil Parkin - Monday, November 13, 2017 7:33 AMSummed up by George Bernard Shaw as: "Remember: those who can, do; those who can't, teach."
I think the parallel to that...
November 13, 2017 at 10:57 am
Maybe the ROLLUP operator could help?
https://technet.microsoft.com/en-us/library/ms189305(v=sql.90).aspx
You would have to change your GROUP BY to include the additional columns that you want to aggregate at the lower...
November 13, 2017 at 10:41 am
November 13, 2017 at 10:21 am
November 10, 2017 at 1:10 pm
November 10, 2017 at 12:21 pm
hey... 60% of the...
November 9, 2017 at 11:34 am
Using datetime in the DOB column makes it a bit more confusing, but it looks like you're considering any point in the day as the whole day? If so and...
November 9, 2017 at 10:02 am
November 9, 2017 at 8:50 am
Viewing 15 posts - 661 through 675 (of 1,838 total)