Viewing 8 posts - 1 through 8 (of 8 total)
January 10, 2019 at 12:20 pm
Fond the solution here
https://www.sqlservercentral.com/Forums/Topic1260952-338-1.aspx
January 10, 2019 at 10:40 am
USE [tempdb]
GO
CREATE TABLE [Source]
(
ID...
January 10, 2019 at 9:06 am
September 20, 2018 at 10:07 am
September 20, 2018 at 7:13 am
yes, that's the problem I am getting. admin or admin privileged users can assign the ticket to anybody even its already been assigned to someone. In this case, though it...
September 19, 2018 at 12:41 pm
('CAS-22596-Y1Q7G2', '2018-03-26 00:00:00', 'KM', 'KM'),
('CAS-22596-Y1Q7G2', '2018-03-26 00:00:00', 'KM', 'IP'),
('CAS-22596-Y1Q7G2', '2018-03-26 00:00:00', 'IP', 'JB'),
('CAS-22596-Y1Q7G2', '2018-05-30 00:00:00', 'JB', 'JB'),
('CAS-22596-Y1Q7G2', '2018-08-07 00:00:00', 'IP', 'SG'),
('CAS-22596-Y1Q7G2', '2018-08-07 00:00:00', 'ADMIN', 'SG'),
September 19, 2018 at 9:56 am
Thank you Drew. I have provided the code now.
September 19, 2018 at 8:54 am
Viewing 8 posts - 1 through 8 (of 8 total)