Viewing 15 posts - 841 through 855 (of 7,191 total)
Yes, or just grant db_owner membership in the database in question.
John
March 12, 2018 at 3:25 am
You're not going to learn anything if you get other people to do your homework for you, especially if they give you the wrong answer. The solution provided is incorrect...
March 12, 2018 at 3:11 am
The DESC in the ORDER BY clause only applies to the column it immediately follows. Try this:ORDER BY year DESC, month, date
John
March 9, 2018 at 9:16 am
March 9, 2018 at 8:28 am
March 9, 2018 at 2:56 am
There are circumstances under which the server will need to be rebooted. As part of the installation wizard, you are invited to close any processes that would otherwise cause the...
March 9, 2018 at 2:11 am
March 8, 2018 at 7:37 am
This may work, although I don't understand why the date for AB22 shouldn't be 2017-02-09?
WITH MaxDates AS (
SELECT
STAT_CODE
, DATE
, PART_NO
March 8, 2018 at 5:03 am
Ditch the attitude when you're asking for help, please. (I've never referred to myself as a "guru" - it's just a forum classification.)
No, I haven't faced this situation. ...
March 8, 2018 at 4:46 am
There have been studies that show the change doesn't help with power, and it's certainly disruptive to everyone.
I'm not so...
March 8, 2018 at 4:31 am
March 8, 2018 at 4:13 am
. I tried Generate Scripts method but it is unable to script...
March 8, 2018 at 4:02 am
Is there a sql query that I can run that will give the same detail...
March 8, 2018 at 3:28 am
You need to do a left join so that you get all of the rows from StartPoints. You'll get a NULL on the right hand side, but you can handle...
March 6, 2018 at 8:53 am
Viewing 15 posts - 841 through 855 (of 7,191 total)