CREATE TABLE [dbo].[HMD]( [WeekNum] [float] NULL, [MonthName] [nvarchar](255) NULL, [Response1_Num] [float] NULL, [Response2_Num] [float] NULL, [Response3_Num] [float] NULL, [Response4_Num] [float] NULL, [Customer Id] [nvarchar](255) NULL, [Email_Queue_Name] [nvarchar](255) NULL, [Session Id] [nvarchar](255) NULL, [Time_stamp] [float] NULL, [CaseID] [nvarchar](255) NULL, [Response] [nvarchar](255) NULL, [Response1] [nvarchar](255) NULL, [Response2] [nvarchar](255) NULL, [Response3] [nvarchar](255) NULL, [Response4] [nvarchar](255) NULL, [comments] [nvarchar](255) NULL, [Language] [nvarchar](255) NULL, [resolver] [nvarchar](255) NULL, [Product] [nvarchar](255) NULL, [Agent_TSCS] [nvarchar](255) NULL, [SITE] [nvarchar](255) NULL, [YYYY_MM] [nvarchar](255) NULL, [YYYY_WK] [nvarchar](255) NULL, [CS_Queue] [nvarchar](255) NULL, [EN_JP] [nvarchar](255) NULL, [No_Queue] [nvarchar](255) NULL, [Product_Other] [nvarchar](255) NULL) ON [PRIMARY]
CREATE TABLE [dbo].[Correspondences_All]( [UserLogin] [varchar](max) NULL, [comm_id] [bigint] NULL, [CaseID] [int] NULL, [Creation_Date] [datetime] NULL, [Supervisor] [varchar](max) NULL, [YearWeek] [int] NULL) ON [PRIMARY]
SELECT top 50 ca.Caseid,[weeknum],[monthName], Response1_Num , Response2_Num, Response3_Num, Response4_Num, comments,[userlogin], [supervisor]FROM HMD hmjoin Correspondences_All ca on hm.[caseid]=ca.caseidwhere [comments] not in ('null','')
Far away is close at hand in the images of elsewhere.
Anon.
drop table testdata Create table testdata ( Caseid [Varchar](30) NULL, weeknum [float] NULL, [monthName][nvarchar](255) NULL, Response1_Num [float] NULL, Response2_Num [float] NULL, Response3_Num [float] NULL, Response4_Num [float] NULL, comments [nvarchar](max) NULL, userlogin [varchar](max) NULL, supervisor [varchar](max) NULL )insert into TestDataSelect 42372993071,3,'January',5,5,5,5,'We are still experiencing a problem with our job','User1','manager1'Union ALLselect 42372993071,3,'January',5,5,5,5,'We are still experiencing a problem with our job','User1','manager1'Select 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User3','manager1' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User3','manager1' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User3','manager1' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23176661271,8,'February',3,1,1,1,'This issue required a lot of pushing from customers and executives to get any answer and was pending for many months. I would like to see better response to such a critical issue in the future.','User2','manager2' Union ALLSelect 23178234921,1,'January',3,3,1,1,'The problems cleared up on their own','User4','manager3' Union ALLSelect 12279616281,2,'January',3,2,1,1,'I just wanted more info on the issue that','User5','manager4' Union ALLSelect 45579639411,2,'January',5,5,5,5,'took some time to address the issue, but it wasnt supports fault I would guess. Thanks. Hoping to get this done faster in future','User5','manager4' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User7','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 67580187871,7,'February',5,5,5,5,'Prieur is awesome!','User6','manager5' Union ALLSelect 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALLSelect 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALLSelect 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALLSelect 45680356651,1,'January',5,5,5,5,'Excellence follow up!','User8','manager6' Union ALLSelect 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALLSelect 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALLSelect 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALLSelect 42380383401,1,'January',4,3,4,3,'lacks the functionality to have resolved the issue. Instead, we had to workaround the limited functionality and delete all our content and re-upload it to resolve the permissions issue.','User9','manager6' Union ALLSelect 12380387151,4,'January',5,5,5,5,'I could browse http://xxxxx','User10','manager7' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User12','manager9' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8' Union ALLSelect 45280540011,8,'February',5,5,5,5,'xxxxx handled this case and even though there was little he personally could do in relation to the resolution, he worked to ensure it was placed at the right level for assistance and continued to follow up and ensure a relaxed client. For this, I would','User11','manager8'
