Viewing 15 posts - 1,516 through 1,530 (of 8,731 total)
;WITH myCTE2 ([MaterialRowID], [MaterialID], [ParentRowID] )
AS
(
SELECT p1.[MaterialRowID], p1.[MaterialID],...
March 3, 2017 at 10:03 am
March 3, 2017 at 9:30 am
In a 2016 Developer...
March 2, 2017 at 11:21 am
March 2, 2017 at 11:15 am
But there is no limitation for the length.
So:
3 is correct and...
March 2, 2017 at 9:16 am
Just another option.
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
),
E2(n) AS(
SELECT a.n FROM E a, E b
),
E4(n) AS(
...
March 2, 2017 at 8:33 am
March 2, 2017 at 8:20 am
This link might be helpful to understand more about permissions in SQL Server.
Server Roles and Database Roles are not exchangeable. They manage different permissions and should...
March 2, 2017 at 8:07 am
The only problem is if you have triggers that affect multiple types. Here's an example for a trigger that would be count 3 times.
CREATE TABLE TriggerTest(
March 2, 2017 at 6:41 am
Out of curiosity. Is this a homework question?
I remember seeing something really similar months ago.
March 1, 2017 at 9:40 am
Here's how to do it without loops. Comment and uncomment as needed.
I didn't know what to do with the update or it was actually needed.
March 1, 2017 at 9:31 am
March 1, 2017 at 8:12 am
March 1, 2017 at 7:36 am
March 1, 2017 at 6:53 am
Viewing 15 posts - 1,516 through 1,530 (of 8,731 total)