text:
WELCOME AT HEUSSEN
info@heussen-law.nl
Register of legal area's
Prof. Dr. Benno Heussen
Phone: +49 89 290 97 0
E-Mail: benno.heussen@heussen-law.de
Statement of experience
Prof. Dr. Benno Heussen is a co-founder of our Munich Office. He has worked mainly in the IT industry for more than 15 years and has built up this specialist practice area nationwide. He is a co-editor of one of the standard textbooks in this field ("Computerrechtshandbuch", "Handbook on Computer Law"), but advises on a wide spectrum of matters within the IT industry, as is demonstrated by his numerous publications ("Unternehmerhandbuch", "Handbook for Entrepreneurs"). As an honorary professor at the University of Hanover he teaches young attorneys and other lawyers in the art of contract drafting and contract negotiation ("Handbuch Vertragsverhandlung und Vertragsmanagement", "Handbook on Contract Negotiation and Contract Management").
Universities: Ludwig Maximilians University of Munich
Honorary membership in the Munich Bar Association.
Medal of Honour of the German Bar for serving on the board and founding the Information Technology and Lawyer Management working groups.
Academic and journalistic activities
Benno Heussen Award of the Working Group Law Firm Management in the German Bar Association.
Advising managing partners and partners on decisions and conflicts
Of-Counsel at HEUSSEN Rechtsanwaltsgesellschaft mbH, specialising in national and international arbitration proceedings and conflict management advice
Honorary professor at the Leibniz University of Hannover
Managing Attorney of the Berlin office
Partner at PricewaterhouseCoopers Deutsche Revision AG
Founder of the Information Technology and Lawyer Management working groups in the German Bar Association
Member of the Board of the German Bar Association
Foundation and management of the Berlin office of HEUSSEN BRAUN von KESSEL with a focus on information technology law
Member of the German Institution of Arbitration. Since then, active as lawyer and judge in arbitration proceedings, mainly in the field of information technology.
Admitted to the Munich Bar, co-founder of the law firm HEUSSEN BRAUN von KESSEL
Doctorate (Dr. jur.) from the Ludwig Maximilians University of Munich (m.c.l.)
Advising publicly and semi-publicly owned organisations on international negotiations
Legal questions concerning information technology (contracts, outsourcing, internet etc.)
Arbitration proceedings, mediation, preferably in the technical field
M&A transactions in the IT industry
HEUSSEN Rechtsanwaltsgesellschaft mbH
Brienner Straße 9 / Amiraplatz
Foreign languages: German, English
Practice groups:
IT, IP & Media Law
© 2022 HEUSSEN All rights reserved.


Allows buyers of a Charles Church new build home the chance to obtain a Government backed 95% mortgage.
Houses and apartments with a reputation for design and quality.
Whatever your style, from urban chic to traditional elegance, we have the ability to personalise your new Charles Church Home to suit you and your family perfectly making your home as individual as you are!
Charles Church has grown to establish itself as one of the country's foremost housebuilding brands; whilst maintaining its unrivalled reputation for the design and quality of the country homes, landmark city and waterside schemes it builds.
Our part exchange schemes enables you to buy the house of your dreams – worry-free!


Halloween: that time of year when horror movies are prevalent both in the movie theater and on Netflix. This year, you can find many new horror movies on Netflix such as Hush, It Follows, Creep, and Cult of Chucky. There are also many new movies in the theater, including Happy Death Day, Jigsaw, and It. Read more about them below.
Summary: Happy Death Day is based on a college student Tree Gelbman, who wakes up in the dorm room of a young man named Carter after a night of too much drinking. As her day progresses, Tree ends up being murdered and wakes up once again in Carter's bed. Tree has to relive her murder over and over again until she finally figures out who killed her.
Student Opinion: Freshman Briana McMillin says that she personally liked the movie, especially because it let a female character have a chance to figure out her own killer. She thinks that overall, it is a good movie and it is not too scary. Her favorite part of the movie was the first time that she died because "I didn't expect the murderer to pop out the way it did every time." She would recommend the movie to others because it is both crime-based and creatively murders Tree Gelbman every single time.
Summary: Jigsaw is based on the life of Jonathan "John" Kramer, who was originally an ordinary toy factory worker. His wife broke up with him due to his fright of commitment. After this, he was diagnosed with cancer and tried to commit suicide twice but survived both times. Then, he understood that he wanted to test the survival instinct of human beings. He made deadly-looking devices to test each victim's love of life. Over the course of the film, his traps evolve from simple but deadly-looking devices to more complicated devices. Watch the movie to find out more.
Summary: It is based on the novel by Stephen King. It begins with a scene involving Bill Denbrough and his younger brother Georgie, who wants a paper boat to play with in the rain. Georgie takes his boat outside in the rainstorm and chases it down the street and into a storm drain. When he looks for it, Penny wise the dancing clown suddenly appears and abducts Georgie. Bill and his friends from the Loser's Club resolve to find Georgie and the other missing children in this horror classic.
"Safe2Say Something": Safer or Slower?


Happy Wednesday everyone!! I hope that you are having a fabulous week. I am enjoying the sunshine that we have had recently.....who knew how refreshing it can be when there is a blue sky all day?!? I was in such a great mood, I decided to make this happy card for the Tuesday Trigger - Rainbow Bright on Moxie Fab World. I was inspired by the beautiful color display and so I tried to duplicate it in my card.
Here is something funny that happened when we were driving home from town yesterday that I want to share with you. As we were coming to a traffic light my 2 year old says "Hurry mommy, it is gonna turn PURPLE!" I replied with "I hope not, I wouldn't know what to do if it turned purple." Without missing a beat, my 5 year old yells "YOU FLY!!" After I collected myself, I said "I don't know how to fly a 4-Runner." My 5 year old then explained "You just honk the horn 100 times and then it flies!" I just love my kids!!
What funny things have you heard a kid say recently??
I love this card! Love those colors.
Cute story about your son. My nephew isn't old enough to talk yet but he will pant like a dog and point(to the dog), every time he sees a dog. It's hysterical.
Gorgeous card, Amy! Love how you show off the colors!
That's just stunning, and so elegantly simple!
Your rainbow card is so cheerful and pretty! Love the texture.


The coming of the bright and haunting Harvest Moon speaks of the coming change. The veil between the world of the living and the realm of the dead thins. For some it is All Hallows Eve. For others it is the anniversary of their death or the nearness of those that the spirits feel compelled to visit. But, one thing remains true no matter the identity of the spirit or the reason for their returning: it isn't always precisely safe. Between the poltergeists and the ghouls, you know that someone is going to act up and that means someone is going to make that call. Ugh, that annoying siren and those ridiculous costumes. One little moan and suddenly there are proton packs and laser beams being fired everywhere!
So, when you return to the land of the living, be sure that you do so with some finesse. Show some elegance and the kind of spiritually aware maturity that will keep those people from hollering out their worries of "Who You Gonna Call?" Of course, it can be difficult. Hopefully you weren't murdered and your call back is from vengeance. But, even if that's the case, a little care in how you appear can make everything go so much more smoothly!
That is where we come in. In order to keep your spiritual visit seeming as innocent as possible, we have this Ghostly Spirit Women's costume that will make you seem as if lying into the realm of the living is an almost welcoming experience. The full length white pullover robe has an interior base that makes it form fitting while the flowing fabric gives you that haunting look of the hereafter, especially with its jagged hemline. Long fringed strips of cheesecloth hang from your collar and sleeve, giving an ethereal look that perfectly matches the silver-white of your haunted wig. Rejoin our realm but, remember, keep the peace!
Fit perfect. Impressed with the material.


text:
Acanthocarpus Lehm., 1848 è un genere di piante angiosperme monocotiledoni della famiglia Asparagaceae (sottofamiglia Lomandroideae).

Distribuzione e habitat
L'intero genere è endemico nello stato dell'Australia Occidentale.

Tassonomia
Il genere Acanthocarpus comprende le seguenti specie:
 Acanthocarpus canaliculatus A.S.George
 Acanthocarpus humilis A.S.George
 Acanthocarpus parviflorus A.S.George
 Acanthocarpus preissii Lehm.
 Acanthocarpus robustus A.S.George
 Acanthocarpus rupestris A.S.George
 Acanthocarpus verticillatus A.S.George

Note

Altri progetti

Collegamenti esterni

Lomandroideae
Flora endemica dell'Australia

redpajama_set_name: RedPajamaWikipedia


I took these pictures really quick. So I warn you they are not at their best.
I have been really wanting to sew a bag for myself. I had a few different bags bookmarked online and in my books.
I finally decided on the Folk Bag from One-Yard Wonders.
I am very happy with how it turned out! It is some of my better sewing. The owls make me very happy and I love the colors. I find myself being drawn to turquoise more and more.
Sadly there have been a couple of casualties in my knitted socks so I must get back to knitting my mystery sock so I have a finished pair soon!
I also have a trip coming up soon and I should be able to finish another pair of socks during that trip and hopefully that will make up for what I lost. Poor, Poor socks but they were very loved and kept my feet cozy in the cooler months. I may try some darning but I have never done it before so i am a bit unsure about it. if you have any tips let me know!
« Where Have You Been????
I know nothing about darning but I have seen darning eggs and I know those are somehow involved.
Your bag is lovely. I love the owls and the lime green lining:) You really have an eye for color.


text:
Q: specify time interval in ssrs Please help with performance and also making the report take the time interval into consideration
I am working on a SSRS report with filters, but it seems like my time interval filter isn't working at all and the report performance is dead crazy (over 5 minutes). It got crazier with the addition of the time interval filter.
In order to get the 24 possible hour interval, which feeds the Interval menu, I created this stored procedure, which I call from the report just for the Interval drop down filter menu:
ALTER PROCEDURE [dbo].[SP_Calls_Time_Interval]
-- Add the parameters for the stored procedure here
@TZ INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT Distinct

--CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) AS Time,

Case
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '00:00:00.0000000' and '00:59:59.0000000' Then '00:00-01:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '01:00:00.0000000' and '01:59:59.0000000' Then '01:00-02:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '02:00:00.0000000' and '02:59:59.0000000' Then '02:00-03:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '03:00:00.0000000' and '03:59:59.0000000' Then '03:00-04:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '04:00:00.0000000' and '04:59:59.0000000' Then '04:00-05:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '05:00:00.0000000' and '05:59:59.0000000' Then '05:00-06:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '06:00:00.0000000' and '06:59:59.0000000' Then '06:00-07:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '07:00:00.0000000' and '07:59:59.0000000' Then '07:00-08:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '08:00:00.0000000' and '08:59:59.0000000' Then '08:00-09:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '09:00:00.0000000' and '09:59:59.0000000' Then '09:00-10:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '10:00:00.0000000' and '10:59:59.0000000' Then '10:00-11:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '11:00:00.0000000' and '11:59:59.0000000' Then '11:00-12:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '12:00:00.0000000' and '12:59:59.0000000' Then '12:00-13:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '13:00:00.0000000' and '13:59:59.0000000' Then '13:00-14:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '14:00:00.0000000' and '14:59:59.0000000' Then '14:00-15:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '15:00:00.0000000' and '15:59:59.0000000' Then '15:00-16:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '16:00:00.0000000' and '16:59:59.0000000' Then '16:00-17:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '17:00:00.0000000' and '17:59:59.0000000' Then '17:00-18:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '18:00:00.0000000' and '18:59:59.0000000' Then '18:00-19:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '19:00:00.0000000' and '19:59:59.0000000' Then '19:00-20:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '20:00:00.0000000' and '20:59:59.0000000' Then '20:00-21:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '21:00:00.0000000' and '21:59:59.0000000' Then '21:00-22:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '22:00:00.0000000' and '22:59:59.0000000' Then '22:00-23:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '23:00:00.0000000' and '23:59:59.0000000' Then '23:00-00:00'
              Else 'To be Determined' End As Interval

FROM            CA_Details_Sync
WHERE        (disposition = 2 OR (disposition = 3 and callpriority <> 0)) AND ((dispskill = 702 AND dispvector = 1022)
OR(dispskill = 701 AND dispvector = 1021)
OR(dispskill = 924 AND dispvector = 1007) OR(dispskill = 923 AND dispvector = 1006) OR(dispskill = 611 AND dispvector = 1001) OR (dispskill = 613 AND dispvector = 1003)
OR (dispskill = 614 AND dispvector = 1004)
    OR (dispskill IN (631) AND dispvector = 1009) OR (dispskill IN (616, 900) AND dispvector = 1006) OR (dispskill = 631 AND dispvector = 202)
    OR (dispskill IN (617, 618, 901) AND dispvector = 1007)) AND (enddate < convert(date, getutcdate()))

GROUP BY CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime))
END

GO

The main report Dataset calls another stored procedure which I created as such:
USE [SPReports]
GO

  /****** Object:  StoredProcedure [dbo].[sp_GSC_Calls_Skills]    Script Date: 9/29/2015 1:01:33 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_GSC_Calls_Skills]

-- Add the parameters for the stored procedure here
@YEAR NVARCHAR(255),
@MONTH NVARCHAR(255),

@SKILL NVARCHAR(255),

@TZ INT,
@Interval NVARCHAR(255)

AS
BEGIN

(SELECT     YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) AS Year,
                MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) AS Month,
                COUNT(cads_id) AS Calls,
                SUM(CASE [disposition] WHEN 2 THEN CAST(ringtime+queuetime AS float) / 86400 ELSE 0 END) AS answertimetf,
                SUM(CASE [disposition] WHEN 2 THEN CAST(talktime AS float) / 86400 ELSE 0 END) AS durationtf,
                CASE

                    WHEN dispskill  IN ('611', '614') THEN 'GTK-English'
                    WHEN dispskill = '613' THEN 'GTK-Spanish'
                    WHEN dispskill IN ('616', '900', '631') THEN 'GTK-HSIA/GNOC'
                    WHEN dispskill IN ('617') THEN 'GTK-FTG'
                    WHEN dispskill IN ('618', '901') THEN 'GTK-VOD/ETVI'
                    WHEN dispskill  IN ('923') THEN 'SNS-HSIA'
                    WHEN dispskill  IN ('924') THEN 'SNS-VOC'
                    WHEN dispskill  IN ('701') THEN 'T2-HSIA'
                    WHEN dispskill  IN ('702') THEN 'T2-VOC'
                    ELSE cast(dispskill as nvarchar(3)) + '-' + dispskillname END AS SkillSet,
                CASE
                    WHEN dispskill  IN ('611', '614') THEN 3
                    WHEN dispskill = '613' THEN 4
                    WHEN dispskill IN ('616', '900', '631') THEN 5
                    WHEN dispskill IN ('617') THEN 6
                    WHEN dispskill IN ('618', '901') THEN 7
                    WHEN dispskill IN ('923') THEN 8
                    WHEN dispskill IN ('924') THEN 9
                    WHEN dispskill IN ('701') THEN 10
                    WHEN dispskill IN ('702') THEN 11
                    ELSE 0 END AS SkillSetPos,
                DAY(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) AS Day,
                SUM(CASE disposition WHEN 2 THEN 1 ELSE 0 END) AS Answered,
                SUM(CASE disposition WHEN 3 THEN 1 ELSE 0 END) AS Abandoned, Case
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '00:00:00.0000000' and '00:59:59.0000000' Then '00:00-01:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '01:00:00.0000000' and '01:59:59.0000000' Then '01:00-02:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '02:00:00.0000000' and '02:59:59.0000000' Then '02:00-03:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '03:00:00.0000000' and '03:59:59.0000000' Then '03:00-04:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '04:00:00.0000000' and '04:59:59.0000000' Then '04:00-05:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '05:00:00.0000000' and '05:59:59.0000000' Then '05:00-06:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '06:00:00.0000000' and '06:59:59.0000000' Then '06:00-07:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '07:00:00.0000000' and '07:59:59.0000000' Then '07:00-08:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '08:00:00.0000000' and '08:59:59.0000000' Then '08:00-09:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '09:00:00.0000000' and '09:59:59.0000000' Then '09:00-10:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '10:00:00.0000000' and '10:59:59.0000000' Then '10:00-11:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '11:00:00.0000000' and '11:59:59.0000000' Then '11:00-12:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '12:00:00.0000000' and '12:59:59.0000000' Then '12:00-13:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '13:00:00.0000000' and '13:59:59.0000000' Then '13:00-14:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '14:00:00.0000000' and '14:59:59.0000000' Then '14:00-15:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '15:00:00.0000000' and '15:59:59.0000000' Then '15:00-16:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '16:00:00.0000000' and '16:59:59.0000000' Then '16:00-17:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '17:00:00.0000000' and '17:59:59.0000000' Then '17:00-18:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '18:00:00.0000000' and '18:59:59.0000000' Then '18:00-19:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '19:00:00.0000000' and '19:59:59.0000000' Then '19:00-20:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '20:00:00.0000000' and '20:59:59.0000000' Then '20:00-21:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '21:00:00.0000000' and '21:59:59.0000000' Then '21:00-22:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '22:00:00.0000000' and '22:59:59.0000000' Then '22:00-23:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '23:00:00.0000000' and '23:59:59.0000000' Then '23:00-00:00'
                  Else 'To be Determined' End As Interval
FROM            CA_Details_Sync
WHERE        (disposition = 2 OR (disposition = 3 and callpriority <> 0)) AND ((dispskill = 702 AND dispvector = 1022)
OR(dispskill = 701 AND dispvector = 1021)
OR(dispskill = 924 AND dispvector = 1007) OR(dispskill = 923 AND dispvector = 1006) OR(dispskill = 611 AND dispvector = 1001) OR (dispskill = 613 AND dispvector = 1003)
OR (dispskill = 614 AND dispvector = 1004)
    OR (dispskill IN (631) AND dispvector = 1009) OR (dispskill IN (616, 900) AND dispvector = 1006) OR (dispskill = 631 AND dispvector = 202)
    OR (dispskill IN (617, 618, 901) AND dispvector = 1007)) AND (enddate < convert(date, getutcdate()))

GROUP BY YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)),
        MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)),
        CASE
            WHEN dispskill  IN ('611', '614') THEN 'GTK-English'
            WHEN dispskill = '613' THEN 'GTK-Spanish'
            WHEN dispskill IN ('616', '900', '631') THEN 'GTK-HSIA/GNOC'
            WHEN dispskill IN ('617') THEN 'GTK-FTG'
            WHEN dispskill IN ('618', '901') THEN 'GTK-VOD/ETVI'
            WHEN dispskill= '923' THEN 'SNS-HSIA'
            WHEN dispskill='924' THEN 'SNS-VOC'
            WHEN dispskill='701' THEN 'T2-HSIA'
            WHEN dispskill  IN ('702') THEN 'T2-VOC'
            ELSE cast(dispskill as nvarchar(3)) + '-' + dispskillname END,
            DAY(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)),
            CASE
            WHEN dispskill  IN ('611', '614') THEN 3
            WHEN dispskill = '613' THEN 4
            WHEN dispskill IN ('616', '900', '631') THEN 5
            WHEN dispskill IN ('617') THEN 6
            WHEN dispskill IN ('618', '901') THEN 7
            WHEN dispskill IN ('923') THEN 8
            WHEN dispskill IN ('924') THEN 9
            WHEN dispskill IN ('701') THEN 10
            WHEN dispskill IN ('702') THEN 11
            ELSE 0 END,
            CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime))

HAVING        (YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) IN
                             (SELECT        Value
                               FROM            dbo.FnSplit(@Year, ',') AS FnSplit_2)) AND
            (MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) IN
                             (SELECT        Value
                               FROM            dbo.FnSplit(@Month, ',') AS FnSplit_1))
                               AND
            (CASE WHEN dispskill  IN ('611', '614') THEN 'GTK-English'
            WHEN dispskill = '613' THEN 'GTK-Spanish'
            WHEN dispskill IN ('616', '900', '631') THEN 'GTK-HSIA/GNOC'
            WHEN dispskill IN ('617') THEN 'GTK-FTG'
            WHEN dispskill IN ('618', '901') THEN 'GTK-VOD/ETVI'
            WHEN dispskill= '923' THEN 'SNS-HSIA'
            WHEN dispskill='924' THEN 'SNS-VOC'
            WHEN dispskill='701' THEN 'T2-HSIA'
            WHEN dispskill  IN ('702') THEN 'T2-VOC'
            ELSE cast(dispskill as nvarchar(3)) + '-' + dispskillname END IN
                             (SELECT        Value
                               FROM            dbo.FnSplit(@Skill, ',') AS FnSplit_3)))
UNION
(SELECT       YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])) AS Year,
              MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])) AS Month,
              COUNT(id) AS Calls,
             Sum(CASE WHEN Status IN ('COMPLETE', 'TRANSFER') THEN CAST(DATEPART(MINUTE, [Queue Wait])*60+DATEPART(SECOND, [Queue Wait]) AS float) / 86400 ELSE 0 END) AS ringtimetf,
              Sum(CASE WHEN status IN ('COMPLETE', 'TRANSFER') THEN CAST(duration1 AS float) / 86400 ELSE 0 END) AS durationtf,
              CASE WHEN [Application] IN ('GTK - English','GTK - English Extended Stay','GTK - English Four Seasons','GTK - English GPNS','GTK - English Hilton','GTK - English Marriot',
                                         'GTK - English WCH', 'GTK - LaQuinta', 'gtkEN', 'gtkENfourSeasons', 'gtkENgpns', 'gtkENLaQuinta', 'gtkENMarriot') THEN 'Conectys English'
                   WHEN [Application] IN ('gtkFR', 'gtkFRgpns', 'gtkFRMarriot') THEN 'Conectys French' END AS SkillSet,
              CASE WHEN [Application] IN ('GTK - English', 'GTK - English Extended Stay', 'GTK - English Four Seasons', 'GTK - English GPNS', 'GTK - English Hilton', 'GTK - English Marriot',
                                          'GTK - English WCH', 'GTK - LaQuinta', 'gtkEN', 'gtkENfourSeasons', 'gtkENgpns', 'gtkENLaQuinta', 'gtkENMarriot') THEN 1
                WHEN [Application] IN ('gtkFR', 'gtkFRgpns', 'gtkFRMarriot') THEN 2 END AS SkillSetPos,
              DAY(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])) AS Day,
              SUM(CASE WHEN status IN ('COMPLETE', 'TRANSFER') THEN 1 ELSE 0 END) AS Answered,
              SUM(CASE WHEN status IN ('LOST', 'TIME OUT') THEN 1 ELSE 0 END) AS Abandoned, Case
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '00:00:00.0000000' and '00:59:59.0000000' Then '00:00-01:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '01:00:00.0000000' and '01:59:59.0000000' Then '01:00-02:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '02:00:00.0000000' and '02:59:59.0000000' Then '02:00-03:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '03:00:00.0000000' and '03:59:59.0000000' Then '03:00-04:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '04:00:00.0000000' and '04:59:59.0000000' Then '04:00-05:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '05:00:00.0000000' and '05:59:59.0000000' Then '05:00-06:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '06:00:00.0000000' and '06:59:59.0000000' Then '06:00-07:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '07:00:00.0000000' and '07:59:59.0000000' Then '07:00-08:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '08:00:00.0000000' and '08:59:59.0000000' Then '08:00-09:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '09:00:00.0000000' and '09:59:59.0000000' Then '09:00-10:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '10:00:00.0000000' and '10:59:59.0000000' Then '10:00-11:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '11:00:00.0000000' and '11:59:59.0000000' Then '11:00-12:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '12:00:00.0000000' and '12:59:59.0000000' Then '12:00-13:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '13:00:00.0000000' and '13:59:59.0000000' Then '13:00-14:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '14:00:00.0000000' and '14:59:59.0000000' Then '14:00-15:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '15:00:00.0000000' and '15:59:59.0000000' Then '15:00-16:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '16:00:00.0000000' and '16:59:59.0000000' Then '16:00-17:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '17:00:00.0000000' and '17:59:59.0000000' Then '17:00-18:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '18:00:00.0000000' and '18:59:59.0000000' Then '18:00-19:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '19:00:00.0000000' and '19:59:59.0000000' Then '19:00-20:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '20:00:00.0000000' and '20:59:59.0000000' Then '20:00-21:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '21:00:00.0000000' and '21:59:59.0000000' Then '21:00-22:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '22:00:00.0000000' and '22:59:59.0000000' Then '22:00-23:00'
                  When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) between '23:00:00.0000000' and '23:59:59.0000000' Then '23:00-00:00'
                  Else 'To be Determined' End As Interval
FROM            Connectys_Calls
WHERE        (CONVERT(date, [Enter Queue]) < CONVERT(DATE, GETUTCDATE())) AND Status <> 'CUSTOMER EXIT' AND [Application] LIKE 'G%'
AND
        (YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])) IN
                             (SELECT        Value
                               FROM            dbo.FnSplit(@Year, ',') AS FnSplit_2)) AND
            (MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])) IN
                             (SELECT        Value
                               FROM            dbo.FnSplit(@Month, ',') AS FnSplit_1))

GROUP BY YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])),
        MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])),
        DAY(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, CONVERT(date, [Enter Queue]))) + CONVERT(time, [Enter Queue])),
        CASE WHEN [Application] IN ('GTK - English', 'GTK - English Extended Stay', 'GTK - English Four Seasons', 'GTK - English GPNS', 'GTK - English Hilton', 'GTK - English Marriot',
'GTK - English WCH', 'GTK - LaQuinta', 'gtkEN', 'gtkENfourSeasons', 'gtkENgpns', 'gtkENLaQuinta', 'gtkENMarriot') THEN 'Conectys English'               WHEN [Application] IN ('gtkFR',
'gtkFRgpns', 'gtkFRMarriot') THEN 'Conectys French' END,
              CASE WHEN [Application] IN ('GTK - English', 'GTK - English Extended Stay','GTK - English Four Seasons','GTK - English GPNS','GTK - English Hilton','GTK - English Marriot',
'GTK - English WCH','GTK - LaQuinta','gtkEN','gtkENfourSeasons','gtkENgpns','gtkENLaQuinta','gtkENMarriot') THEN 1
                WHEN [Application] IN ('gtkFR','gtkFRgpns',
'gtkFRMarriot') THEN 2 END ,CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue])))
HAVING
            (CASE WHEN [Application] IN ('GTK - English', 'GTK - English Extended Stay','GTK - English Four Seasons','GTK - English GPNS','GTK - English Hilton','GTK - English Marriot',
'GTK - English WCH','GTK - LaQuinta','gtkEN','gtkENfourSeasons', 'gtkENgpns','gtkENLaQuinta','gtkENMarriot') THEN 'Conectys English'

WHEN [Application] IN ('gtkFR','gtkFRgpns','gtkFRMarriot') THEN 'Conectys French' END IN
                             (SELECT        Value
                               FROM            dbo.FnSplit(@Skill, ',') AS FnSplit_3)))

END

GO

A: In your query, your doing a lot of calculations over and over again - especially with your time interval.
I would make a subquery that adds a column with your time interval calculation:
....
SUM(CASE WHEN status IN ('COMPLETE', 'TRANSFER') THEN 1 ELSE 0 END) AS Answered,
SUM(CASE WHEN status IN ('LOST', 'TIME OUT') THEN 1 ELSE 0 END) AS Abandoned,
RIGHT('00' + CAST(Hour_Interval AS VARCHAR(10)), 2) + ':00-' + RIGHT('00' + CAST(@HOURS + 1 AS VARCHAR(10)), 2) + ':00' AS INTERVAL
Else 'To be Determined' End As Interval
FROM (  SELECT * , DATEPART(HOUR, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, [Enter Queue]))) End As Hour_Interval
        FROM Connectys_Calls ) AS CC
....

For your time interval filter drop-down, is it really necessary to call the actual dataset? If you're going to have all values most of the time, just give all hour ranges:
DECLARE @HOURS AS INTEGER = 0

SELECT @HOURS AS HOURS, RIGHT('00' + CAST(@HOURS AS VARCHAR(10)), 2) + ':00-' + RIGHT('00' + CAST(@HOURS + 1 AS VARCHAR(10)), 2) + ':00' AS RANGES
INTO #TEMP_HOURS

SET @HOURS = @HOURS + 1

WHILE @HOURS <24

BEGIN

INSERT INTO #TEMP_HOURS
SELECT @HOURS AS HOURS, RIGHT('00' + CAST(@HOURS AS VARCHAR(10)), 2) + ':00-' + RIGHT('00' + CAST(@HOURS + 1 AS VARCHAR(10)), 2) + ':00' AS RANGES

SET @HOURS = @HOURS + 1

END

SELECT * FROM #TEMP_HOURS

A: It takes a little less than 5 minutes to run this:
      Declare @YEAR NVARCHAR(255)
             Set @Year='2015'

       Declare @MONTH NVARCHAR(255)
       Set @Month='9'
       Declare @SKILL NVARCHAR(255)
       Set @Skill= 'GTK-English,Conectys English,Conectys French'
 --@SOURCE NVARCHAR(255),
Declare @TZ INT
Set @TZ=0
Declare @Interval NVARCHAR(255)
Set @Interval='06:00-07:00,07:00-08:00'
(SELECT     YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) AS Year,
            MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) AS Month,
            COUNT(cads_id) AS Calls,
            SUM(CASE [disposition] WHEN 2 THEN CAST(ringtime+queuetime AS float) / 86400 ELSE 0 END) AS answertimetf,
            SUM(CASE [disposition] WHEN 2 THEN CAST(talktime AS float) / 86400 ELSE 0 END) AS durationtf,
            CASE

                WHEN dispskill  IN ('611', '614') THEN 'GTK-English'
                WHEN dispskill = '613' THEN 'GTK-Spanish'
                WHEN dispskill IN ('616', '900', '631') THEN 'GTK-HSIA/GNOC'
                WHEN dispskill IN ('617') THEN 'GTK-FTG'
                WHEN dispskill IN ('618', '901') THEN 'GTK-VOD/ETVI'
                WHEN dispskill  IN ('923') THEN 'SNS-HSIA'
                WHEN dispskill  IN ('924') THEN 'SNS-VOC'
                WHEN dispskill  IN ('701') THEN 'T2-HSIA'
                WHEN dispskill  IN ('702') THEN 'T2-VOC'
                ELSE cast(dispskill as nvarchar(3)) + '-' + dispskillname END AS SkillSet,
            CASE
                WHEN dispskill  IN ('611', '614') THEN 3
                WHEN dispskill = '613' THEN 4
                WHEN dispskill IN ('616', '900', '631') THEN 5
                WHEN dispskill IN ('617') THEN 6
                WHEN dispskill IN ('618', '901') THEN 7
                WHEN dispskill IN ('923') THEN 8
                WHEN dispskill IN ('924') THEN 9
                WHEN dispskill IN ('701') THEN 10
                WHEN dispskill IN ('702') THEN 11
                ELSE 0 END AS SkillSetPos,
            DAY(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) AS Day,
            SUM(CASE disposition WHEN 2 THEN 1 ELSE 0 END) AS Answered,
            SUM(CASE disposition WHEN 3 THEN 1 ELSE 0 END) AS Abandoned, Case
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '00:00:00.0000000' and '00:59:59.0000000' Then '00:00-01:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '01:00:00.0000000' and '01:59:59.0000000' Then '01:00-02:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '02:00:00.0000000' and '02:59:59.0000000' Then '02:00-03:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '03:00:00.0000000' and '03:59:59.0000000' Then '03:00-04:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '04:00:00.0000000' and '04:59:59.0000000' Then '04:00-05:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '05:00:00.0000000' and '05:59:59.0000000' Then '05:00-06:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '06:00:00.0000000' and '06:59:59.0000000' Then '06:00-07:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '07:00:00.0000000' and '07:59:59.0000000' Then '07:00-08:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '08:00:00.0000000' and '08:59:59.0000000' Then '08:00-09:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '09:00:00.0000000' and '09:59:59.0000000' Then '09:00-10:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '10:00:00.0000000' and '10:59:59.0000000' Then '10:00-11:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '11:00:00.0000000' and '11:59:59.0000000' Then '11:00-12:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '12:00:00.0000000' and '12:59:59.0000000' Then '12:00-13:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '13:00:00.0000000' and '13:59:59.0000000' Then '13:00-14:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '14:00:00.0000000' and '14:59:59.0000000' Then '14:00-15:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '15:00:00.0000000' and '15:59:59.0000000' Then '15:00-16:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '16:00:00.0000000' and '16:59:59.0000000' Then '16:00-17:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '17:00:00.0000000' and '17:59:59.0000000' Then '17:00-18:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '18:00:00.0000000' and '18:59:59.0000000' Then '18:00-19:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '19:00:00.0000000' and '19:59:59.0000000' Then '19:00-20:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '20:00:00.0000000' and '20:59:59.0000000' Then '20:00-21:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '21:00:00.0000000' and '21:59:59.0000000' Then '21:00-22:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '22:00:00.0000000' and '22:59:59.0000000' Then '22:00-23:00'
              When CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) between '23:00:00.0000000' and '23:59:59.0000000' Then '23:00-00:00'
              Else 'To be Determined' End As Interval
 FROM            CA_Details_Sync
WHERE        (disposition = 2 OR (disposition = 3 and callpriority <> 0))       AND ((dispskill = 702 AND dispvector = 1022)
 OR(dispskill = 701 AND dispvector = 1021)
 OR(dispskill = 924 AND dispvector = 1007) OR(dispskill = 923 AND dispvector   = 1006) OR(dispskill = 611 AND dispvector = 1001) OR (dispskill = 613 AND     dispvector = 1003)
    OR (dispskill = 614 AND dispvector = 1004)
    OR (dispskill IN (631) AND dispvector = 1009) OR (dispskill IN (616,   900)    AND dispvector = 1006) OR (dispskill = 631 AND dispvector = 202)
    OR (dispskill IN (617, 618, 901) AND dispvector = 1007)) AND (enddate <    convert(date, getutcdate()))

    GROUP BY YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)),
    MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ),      CONVERT(datetime, enddate)) + CONVERT(time, endtime)),
           CASE
            WHEN dispskill  IN ('611', '614') THEN 'GTK-English'
          WHEN dispskill = '613' THEN 'GTK-Spanish'
           WHEN dispskill IN ('616', '900', '631') THEN 'GTK-HSIA/GNOC'
           WHEN dispskill IN ('617') THEN 'GTK-FTG'
           WHEN dispskill IN ('618', '901') THEN 'GTK-VOD/ETVI'
           WHEN dispskill= '923' THEN 'SNS-HSIA'
           WHEN dispskill='924' THEN 'SNS-VOC'
          WHEN dispskill='701' THEN 'T2-HSIA'
          WHEN dispskill  IN ('702') THEN 'T2-VOC'
          ELSE cast(dispskill as nvarchar(3)) + '-' + dispskillname END,
          DAY(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) *   @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)),
            CASE
            WHEN dispskill  IN ('611', '614') THEN 3
            WHEN dispskill = '613' THEN 4
            WHEN dispskill IN ('616', '900', '631') THEN 5
            WHEN dispskill IN ('617') THEN 6
            WHEN dispskill IN ('618', '901') THEN 7
            WHEN dispskill IN ('923') THEN 8
            WHEN dispskill IN ('924') THEN 9
            WHEN dispskill IN ('701') THEN 10
            WHEN dispskill IN ('702') THEN 11
            ELSE 0 END,
            CONVERT(TIME, DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime))

HAVING        (YEAR(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) IN
                         (SELECT        Value
                           FROM            dbo.FnSplit(@Year, ',') AS FnSplit_2))    AND
        (MONTH(DATEADD(HH, - (1 * DATEPART(HH, getutcdate() - GETDATE()) * @TZ), CONVERT(datetime, enddate)) + CONVERT(time, endtime)) IN
                          (SELECT        Value
                           FROM            dbo.FnSplit(@Month, ',') AS FnSplit_1))
                           AND
          (CASE WHEN dispskill  IN ('611', '614') THEN 'GTK-English'
        WHEN dispskill = '613' THEN 'GTK-Spanish'
        WHEN dispskill IN ('616', '900', '631') THEN 'GTK-HSIA/GNOC'
        WHEN dispskill IN ('617') THEN 'GTK-FTG'
        WHEN dispskill IN ('618', '901') THEN 'GTK-VOD/ETVI'
        WHEN dispskill= '923' THEN 'SNS-HSIA'
        WHEN dispskill='924' THEN 'SNS-VOC'
        WHEN dispskill='701' THEN 'T2-HSIA'
        WHEN dispskill  IN ('702') THEN 'T2-VOC'
        ELSE cast(dispskill as nvarchar(3)) + '-' + dispskillname END IN
                         (SELECT        Value
                           FROM            dbo.FnSplit(@Skill, ',') AS FnSplit_3)))

redpajama_set_name: RedPajamaStackExchange


Discussion in 'C' started by heidik, Nov 1, 2010.
I am trying to find duplicates for part of a string, not the whole string. The strings are stored in a file. Each line of file contains a string and many of which looks something like this (not all of the lines).
where the '0' at the very beginning is common throughout a block of lines. The other block will have a '1' common through out the block and so on. The string starting from CCD untill the end can be duplicated and I have to find how many such duplicate lines are there against each '0' and '1' and so on. The file can contain any combination of any strings, not just the one mentioned in the above example but if at all it contains duplicates then the string starting from position of 'C' of the 'CCD' till the end would be repeated.
Can anyone please help. Would be grateful.
What part of this problem do you find troublesome? I assume it's string comparison, so I'll explain accordingly.
2. Use strtok to tokenize the string, with ',' as delimiter.
3. Compare each line 4th token onwards.
Below are some more line from the file. The actual file contains almost 70000 lines.
I have just been able to extract duplicates from the actual file based on some condition and finally stored all unique strings in a different file. Now I want to compare the two files: the original file (having duplicates) and the new file (with unique strings) to make sure that each line of the original file has been read and checked for duplicates. If any of the lines that is found in the original file (with duplicates) is missing from the unique file then the program should output an error message. Like wise if any of the lines from the original file appears more than once against one ID in the unique file then again the program should output an error message. There are blocks of lines and each block contains a unique ID. A line should not appear more than once against one ID. If same line appears twice in the unique file but against different IDs then it would not be considered an error.
the Zero (0) at the beginning of the above string is the string (line) ID and it can go up to 70000 and there are around 10 strings (lines) against one ID e-g there can be 10 lines against ZERO (0), 10 against ONE (1) etc and so one.
I hope I have made my point clear.


can't wait to see more about the workshop in Sweden! I love her blog, thanks for the link!
good news in the world! you're hiking, your good care has your son running, your daughter back happily in 'the city', bunnies saved, house high and dry, and ..... teaching again next weekend.
What a summer Fran - glad you have all come out the other side stronger and wiser. Looking forward to seeing posts about your trip to Sweden. Did you do a travel journal while there? If so I hope you will post some pictures over on the Travel & Art site.


text:
THE EAGLE IS WATCHING
Not Affiliated to any political party: We strive to hold politicians to their sacred pledges to the people: Obey campaign promises and oaths of office...
Visit American Universe on Facebook
IF VIDEOS DO NOT PLAY, USE FIREFOX. CHROME HAS A BUG
Are There Any Braves Left In Congress?
Rubio a Trojan Horse?
Exposing The Crime of Abortion
Holding Politicians Accountable
Margaret Thatcher - A Tribute
Why Are We Called American Universe?
What Are Opportunities?
An Open Letter From Our President
What is American Universe?
What does Membership mean?
IMMENSA
The United States was born with a fatal disease that eventually will overcome her. This book correctly diagnose the disease and in Part 2 the cure is defined that does not require politicians involvement and without a Constitutional Amendment.
Buy the book today!
Four Words That Have Destroyed Many Careers
U.S. Military vs. The American People
Another Black President?
How Will We Engage The Youth?
Why Are We Not Waking Up?
Free Course at Hillsdale College:
Introduction to the Constitution
This Week's Show Sponsored By:
Gordon & Gordon, A Professional Law Corporation
Anthony B. Gordon - (818) 887-5155
www.anthonybgordon.com
When I first pitched the idea of holding politicians responsible for their campaign promises, their oaths of office and their general conduct in life, I mostly received scoffs and smirks followed by "How are you going to do that?" type questions.
Our Campaign With Donald Trump
Those are good questions because the youth, at least, know so little of what's important in life and government, that it would be almost impossible to engage them in anything serious, let alone politics. Especially when a large percentage of their general want in life never reaches their skin.
Previous generations felt the need and want immediately upon leaving their parents' care and some experienced that even before leaving the house. They had to have skin in the game to make it out there: a paying job; an education that will result in a paying job; discipline to stay in the job, and so on.
Later generations have not acquired skills to protect them against such needs and wants and their attention span disappears rapidly when it's not about them, their luxuries, social media, and in most cases, their weed. So, as soon as a politician speaks about any agenda that has found a home under the no-work, loose-life, and weed-smoking umbrella, the youth assimilates and participates. Talking about working for a living is as foreign to them as running to the Post Office to send a telegram.
So, that's not going to go anywhere. There is, however, an open door to their attention sphere and that is instant gratification, remote engagement and social media. Why don't we let them play a videogame with their celebrities, which includes politicians, without having to ask the celebrities whether they want to play? We will stream data into the game about the celebrities' actions, utterances, and conduct and the players play against their real actions, not make-believe. Celebrities can only participate in the game by adapting their behavior in real life.
There is one thing that the youth despise as much as we all do, and that is to be deceived. That happens to be politicians' core modus operandi, to get elected and remain in power. If the videogame allows the players to see the characters within their videogames acting deceitfully, there will be no hesitation to drag their game-characters off into a dungeon somewhere. It's just a game, after all. But it's the players' real response to real behavior. By the time the players have made a decision about a character, they will be fully informed on the particulars as they experienced it in the game. That's exactly where we want to be.
On what shall we base our measurement of veracity or deceit? We honed it down until only three elements that are both apolitical and universally true remained. They almost perculated to the top of the brew in which we stirred the pot to find the answer. I already mentioned these three three things at the top of this article: Keep your campaign promises, do not violate your oath of office, and do not embarrass your constituents in public with your conduct.
In a recent survey we found that almost 100% of the people polled despised being deceived and these three parameters address that one underlying theme: deception.
To put this outreach on a wider platform, I created a campaign on Donald Trump's crowdfunding portal and he promised to have his team evaluate every campaign that has attracted contributions. So, please visit our campaign and contribute. You will be able to watch the video from the campaign portal, too if you prefer. There are some very interesting and valuable rewards for contributors.
The video is only about seven minutes but it explains how the game would work. We will use the donations to hire the best producers, animators, and directors to produce this game. Once we engage real live people by using public information, this should go viral all over the world as people would start playing with their celebrities and politicians.
It is evident that the efforts of only a few wouldn't be able to finish this monumental task; it can only succeed if a wider participation rate can occur. We all are at risk of losing our liberties and although not all of us could (or should) be in the trenches, supporting the effort with other means is as crucial as the warrior on the battlefield.
We need your feedback, too, so that we can adapt and stay true to the course. Please leave your feedback; it would be very much appreciated.
Nico van Niekerk
American Universe provides its members with the instruments through which they can hold politicians accountable for their oaths, promises and actions, regardless of political persuasion.
It is an a-political portal that exposes all points of view to the scrutiny of our members. Once elected to office, representatives will be held to their campaign promises, oaths of office and general conduct.
Contact / Connect
Send us an email at info@americanuniverse.net .

redpajama_set_name: RedPajamaCommonCrawl


text:
Hintonburg resident walks 24 hours for women's mental health
by editorkitchissippicom
Marc Gagnon arriving home as he finished his 24 hour walk raising awareness on women's mental health on July 28, 2020. Photo by Maureen McEwan.
By Maureen McEwan
Marc Gagnon decided to start his summer vacation in a different way.
On July 27-28, the Hintonburg local walked 24 hours consecutively around Ottawa to raise awareness on women's mental wellness and to encourage participation in this year's Virtual Run for Women.
The national Run for Women event supports women's mental health and is organized through the LOVE YOU by Shoppers Drug Mart™ program. For 2020, the 5K run/walk and 10K run events will take place in 18 Canadian cities virtually on Sept. 27.
This is Gagnon's first year participating.
"I'm a co-captain for a team in the Run for Women," he said. "So I was looking for a way to encourage the team, to set an example for the team, and then really to have people join."
After developing the idea with a friend, Gagnon settled on the idea to walk for 24 hours because of the symbolism.
"The struggle with mental health, it's not just 24 hours," he said. "My pain that I feel, this is temporary. The struggle with mental health, and mental illness, it goes beyond 24/7."
In the city, he said the Royal Ottawa Mental Health Centre ('The Royal') provides vital services to those with mental health issues 24 hours a day, seven days a week.
"So this just seemed to [have] that symmetry there, or that synergy, with 24."
Gagnon set off from his home in Hintonburg around 7 a.m. on July 27. He first headed west to Stittsville, reaching Quitters Coffee. After that, he turned back to head east, taking West Hunt Club Road through the evening towards Orleans. In the morning, he looped back through the Byward Market/Hull and then towards home in Kitchissippi.
Gagnon completed the 78 km loop around 7 a.m. on July 28, taking approximately 103,000 steps, and finishing on time.
A map of Marc Gagnon's 78 km journey through Ottawa July 27-28. Photo courtesy of Marc Gagnon's Twitter.
One of the biggest challenges was the weather — Gagnon said the 30 degree heat "zapped" his energy at points. The "loneliest part" was from 10 p.m. to 4 a.m. when he was heading east. Gagnon said he was walking slowly and taking more mini-breaks during that stretch.
But there were lots of positive moments. Gagnon said there was plenty of virtual encouragement and, along the route, he was visited by his mom, friends and staff from both The Royal and The Royal Ottawa Foundation for Mental Health.
"It was nice to feel that support," he said. "And they were very grateful for what was done." he said.
During the pandemic, he said women have had the added challenge of balancing different roles — being a mother, partner, teacher, employee or employer, etc. For him, the best part of the 24-hour journey was just being a part of the conversation supporting women's mental health.
"I think part of it was just the conversation and the encouragement that I saw," he said. And, certainly, the opportunity to ask people — like my teammates [who] are part of Team 'It Matters' — why are you getting involved? And for people to share their [stories] and their passion."
"Women's mental health, it matters," he added.
Gagnon's 24-hour journey marked two months until the 8th annual Run for Women. This year, 100 per cent of the local registration fees will be donated to the Women's Mental Health program at The Royal.
To learn more, visit runforwomen.ca or theroyal.ca.
Posted in Featured stories, The latest scoopTagged 24 hours, feature, featured, Run for Women, Shopper's LOVE YOU, The Royal, women's mental health
Prev Test the waters: Learning about the Westboro Beach bacteria levels
Next CoBrie Family Restaurant and Catering now offering more delicious options
Pingback: Hintonburg resident walks 24 hours for women's mental health – Kitchissippi times - RIGHTLIVING HEALTH BLOG
Pingback: Hintonburg resident walks 24 hours for women's mental health – Kitchissippi times – Super Health Post
Collectable Treasures
Humans of Kitchissippi
Kitchissippi Q & A
The latest scoop
SHOP LOCAL AND SUPPORT OUR ADVERTISERS
Local Ottawa Area Sh… on West End Kids celebrates 25 ye…
Hintonburg resident… on Hintonburg resident walks 24 h…
The President of the… on First-time home buyers: Where…
Reflecting on the 19… on Quick to act: How Ottawa quell…


This course is an introduction to our facilities and to refresh your knowledge of film processing or darkroom printing. Please bring in your own film to process or black and white negatives to print and photo paper.
*Darkroom drop in rates apply after 1pm.
During this workshop we will be photographing together using Ilford Super XP2 film (borrow a camera or bring your own). We will then process our shot film and learn to make black and white silver gelatin prints using our darkroom facilities.


I use this anchor chart in my classroom whenever I am working with my students on point of view. This is something that I copy and have them glue in their interactive notebooks. I also blow this up on the poster making machine and use this on my anchor wall.


(Harrisburg) – State Senator Daylin Leach recently introduced the "Pay It Forward, Pay It Back" bill, which would dramatically change how college students pay tuition at public colleges and universities.
Under the bill, qualified students would be able to borrow from a public pool of money; however, the students will not be charged interest on the loan. Leach is also proposing that the students repay the only after graduating, but the monthly payments would vary depending on the graduate's salary. According to Leach, the payment should be about four percent of the annual salary. The money from the repayments would be put back in the pool for future students.
In a press release, Leach explains that the money for the initial pool would come from natural gas extraction taxing. For more information on the proposal, click here.


text:
The Little Art Window: CONRAD SHAWCROSS: The Patterns of Absence
The Patterns of Absence , 2021
painted steel, mechanical system
150 x 150 x 12 cm.
(View a larger image of thumbnail 10 )
With The Patterns of Absence, Conrad Shawcross has created a work that is akin to stained glass windows, which are activated by the light of the sun behind them shining...
With The Patterns of Absence, Conrad Shawcross has created a work that is akin to stained glass windows, which are activated by the light of the sun behind them shining through. Composed of two counter-rotating discs, each is peppered with a series of complex layers of perforations. Their incremental counter rotation allows light to permeate through the voids within their surfaces, producing an effect that triggers associations reminiscent of those experienced in nature, such as the shifting light upon the sea, the twisting motion of a vortex, or a murmuration of starlings.
The Patterns of Absence series coincides with the launch in 2021 of the public commission Beacons, which continues Shawcross's exploration of optics and visual perception. Beacons comprises four monumental discs that stand atop the Ramsgate cliffs in East Kent, U.K., casting a colourful semaphoric message of hope far out to sea. The optic potency of the works is further enhanced by the cranking of a handle that turns each pairs of perforated disks. The movement of these against each other and the sky creates optic interference and so further activates receptors in the eye, which enhances the ability to send the cryptic message – the word 'home' written in semaphore, chosen by local school children – even further out to sea.
From the artists' studio


Beautiful. And it pairs nicely with my post, too.
Well Merisi, I am a bit alarmed to see this photo. How is it possible that Starbucks could dare enter the city of Demel's?
Why would someone, even a night hawk, favor that experience?
Please do tell me that Viennese civilization still holds.
I would love some starbucks right now!!
Believe it or not, I've never had a cup of Starbucks coffee. However if I ever get to Vienna, well maybe then.
Do I know that fellow? Strikingly good looking, don't you think?
A very atmospheric picture. So much nice than MacDonalds.
What a cute picture. I love it.
How relaxed and peaceful looking.
I like the red bricked cafe - looks fun.
What are you doing in Starbucks Merisi??
It looks just like the one in downtown Walnut Creek, CA.
The enemy we can't live without had invaded Vienna.
Oh NO -- et tu, Vienna?
don't you agree? This is an underground location, at a big subway transfer station, not the place where one expects quiet contemplation. I am all for free enterprise and when Starbucks came to Vienna, it become a refuge for those coffee devotees who'd rather breath smoke-free air, giving the local establishments a run for their money. In the meantime, at least two of the big traditional coffee houses have declared their houses smoke-free, Cafe Schwarzenberg and Griensteidl, and smaller places like Cafe der Provinz and Phil.
I think Vienna has the power of turning even Starbucks into something very... Viennese :)!
Remember, the enemy is within!
Viennese coffeehouses will not go down because of Starbucks. To quote that ancient Roman sage, Cicero, "The enemy is within the gates; it is with our own luxury, our own folly ... " - I'd add to that complacency and smugness, to which a half dozen Starbucks weigh nothing.
McDonald's is now throwing its very own McCafés into the ring, They may take a bigger bite out of the coffee business than Starbucks. Their prices are very competitive, and the coffee's good! Plus, they offer a smoke-free environment, and more and more people who don't smoke are tired of being considered second-class customers.
And if they help to show the light to those managers who think that the all important customer is the one who smokes, they better for them!
when Starbucks opened its first store on the East Coast right there in my then hometown DC, I had quite a few good cups of coffee there (before that, the only place I knew that served a decent Italian style espresso was Luigi's Pizzeria on L Street!).
Edward Hopper would be fascinated by this! And so am I.
Isn't it fascinating how a single artist has forever captured our imagination when we see scenes like this one?
Ahh-- the smoke free thing makes sense!


What is the Black Maternal Health Conference and Training Institute?
The Inaugural Black Maternal Health Conference and Training Institute, founded and led by the Black Mamas Matter Alliance, will be the premiere assembly for Black women, clinicians, professionals, advocates, and other stakeholders working to improve maternal health using the birth justice, reproductive justice, and human rights frameworks. It will offer a national space for learning, rich discussions, and mobilization to transform Black Maternal Health, Rights, and Justice. Click here for additional information.
Who are the Black Mamas Matter Alliance?
BMMA is a black women-led, cross-sectional national alliance. We center Black mamas to advocate, drive research, build power, and shift culture for Black maternal health, rights, and justice. Visit our website for more information.
Where is the Opening Soirée taking place?
The Opening Soirée is a ticketed event only. Participants must purchase tickets in advance to attend. Additional information will be e-mailed to participants after successful registration for the event.
Will I be able to register for the BMHC18 Conference on site?
All events (Conference and Opening Soirée) are RSVP Only. Registration is now closed due to reaching the full capacity of the conference venue. NO ONSITE REGISTRATION!
To cancel your Conference registration or participation to the Opening Soirée, please send an email to conference@blackmamasmatter.org. No refunds will be issued for cancellation of the Conference registration or Opening Soirée – NO EXCEPTIONS.
Can I transfer my registration to another individual?
Yes. To do so, please send an email to conference@blackmamasmatter.org by Friday, November 16, 2018. Your email must include your name, registration confirmation number, and the name and email address of the individual who will be taking your place.
Can I make a payment by check?
Yes, registration payments can be made by check. Please email conference@blackmamasmatters.org for detailed instructions on how to register by check payment.
Is there a room block or discounted hotel rate available?
Registration for the conference does not include hotel, travel, activities, or meals other than those specified in the event details. Registrants are required to make their own hotel and lodging accommodations.
Who do I contact for any questions?
For any questions about the conference, registration, payments, refunds, etc., please email conference@blackmamasmatter.org. Please allow up to 48 hours for a response.
Where can I park during the BMHC18 Conference?
If you are driving to the conference, parking will be provided as part of your registration. Please park in United Way parking deck and bring your parking ticket inside for validation. The United Way parking deck is the building that is connected to the Loudermilk building.
Will meals be provided at the BMHC18 Conference?
Dinner will be provided during the Opening Soirée on Friday, December 7. Breakfast, lunch and snacks will be provided on Saturday, December 8 and a light breakfast and brunch will be provided on Sunday, December 9.
Attendees can expect an exciting, innovative, and much-needed discussion around Black Maternal Health. We are bringing together researchers, health professionals, advocates, mamas, and students with a passion for health equity and reproductive justice for Black mamas. Please see our schedule and speakers' pages for more information.
Black Mamas Matter Alliance supports the whole family and we know that comes with kids. Children ages 5 years and younger can attend the conference on December 8-9, 2018, and childcare will be provided during conference hours for a discounted fee of $100 per child. This fee includes the cost of food and beverage, venue, and hiring of childcare professional during the conference. To register your child, please select the Childcare Registration ticket. Unfortunately, we are unable to accommodate children over the age of 5 years. Please make other childcare arrangements for children 5 years of age and older.
Nursing children or children under the age of 2 can attend the Conference free of charge if they stay with their accompanying parent/guardian throughout the entire conference. Please note that all minors must be accompanied by an adult at all times. Children ages 2-5 will be required to register for childcare and will not be permitted in conference sessions.
No childcare will be provided during the Opening Soirée on December 7, 2018. Parents/guardian should make other childcare arrangements during this time.
Will childcare be provided for children?
We will provide childcare for children ages 5 and younger. Please be sure to bring any special food (including milk) or medicine that your child requires.
Is there a lactation/pumping room at the conference venue?
Loudermilk has one wellness room on the 2nd floor. Please feel free to visit the front desk at any time during the conference and request to be escorted to the wellness room. There is a refrigerator at the front desk that can be used to store milk during the conference.


text:
Who Is Gerald Santos (aka Thuy In UK's "Miss Saigon")?
Angelica Montoro
Success, according to Gerald Santos, requires three things: perseverance, constant drive for learning, and staying true to one's self.
Gerald is known in the Philippines as the "The Prince of Ballad." He started his singing career at seven years old. With his parents' full support, he joined and won in various amateur singing competitions, wherein he even had the chance to compete with Charice Pempengco (now known as Jake Zyrus).
Sharing his powerful yet soulful voice with a larger audience, he decided to join a singing competition on television and eventually became its youngest grand champion. This achievement jumpstarted his professional singing career with a five-year contract and a record deal with the TV network.
He debuted with a studio album called A Day on the Rainbow back in November 2006. Two years later, he released another album called Pinakahihintay; the repackaged version of which, released in 2010, even earned him the Male Pop Artist of the Year award from the 3rd PMPC Star Awards the following year. In 2012, his album, Gerald Santos The Prince of Ballad, won the Revival Album of the Year award from the 5th Star Awards for Music; he also received three other nominations from the same award-giving body in 2013, including Male Recording Artist of the Year, Male Concert Performer of the Year, and Male Pop Artist of the Year. In 2015, the Gerald Santos Kahit Anong Mangyari album was released, earning him a nomination at the 7th Star Awards for Music as Male Pop Artist of the Year. Now, he has signed up with Star Music Philippines, with his sixth studio album in the works.
Gerald also established a career in the theater scene, with stints like being the lead actor for "Sino Ka Ba, Jose Rizal?" where he also got nominated for Best Actor in the Aliw Awards, followed by a role in "San Pedro Calungsod The Musical."
As he strived to achieve a certain awakening in his career, another door opened for him when "Miss Saigon UK" held an audition in the Philippines last 2016. "Miss Saigon," a multi award-winning production of Cameron Mackintosh, tells the story of a tragic love that happened in the Vietnam War. The original cast of the first-ever production of "Miss Saigon" included our very own Lea Salonga as the lead actress named Kim.
The event was highly-publicized in the theater world, making it almost impossible to be a part of the renowned Broadway musical because of the intense competition within the auditions. "At first, I wasn't so familiar with 'Miss Saigon.' All I knew was that Miss Lea Salonga was Kim. Then my friends from the press, they kept telling me na kapag magkaroon ng 'Miss Saigon' auditions, mag-audition daw ako for Thuy kasi bagay sa'kin 'yung role," he shares.
Though hesitant at first, Gerald eventually made up his mind and mustered the courage to audition for the part of Thuy. One of the main characters, Thuy is Kim's cousin, to whom she was betrothed at thirteen. The audition coincided then with his ongoing rehearsals and tours for the "San Pedro Calungsod The Musical," but he remained unfazed despite the pressure. "We were doing our songs for 'San Pedro Calungsod' while I was starting the songs for 'Miss Saigon.' So right after the shows in Davao and Bicol, diretso kami sa audition for 'Miss Saigon' in Makati."
Being in the presence of great artists from different parts of the world was the highlight of the experience for him. He recalls, "Tandang-tanda ko nu'n, you only have 12 bars to sing. Sobrang dami ng nag-audition kaya talagang kailangan swift lang, and you have to prove yourself du'n sa 12 bars, which was like 45 seconds." Fortunately, he was able to pass the three stages and moved on to the last audition, where he had to perform in front of the maestro and producer of the musical himself, Claude-Michel Schönberg.
Gerald tells Metro.Style, "Dumating 'yung araw na 'yun. Konti na lang kami, mga nasa 10-12 so, talagang salang-sala na. Nun'g pumasok na ako sa room, buong company na 'yung nandu'n. Tapos Sir Claude asked, 'Are you ready?' So nag-start ako." He continued to share the details of that memorable moment when he nervously sang, sharing, "Pinahinto agad ako ni Sir Claude because I was a millisecond late. He told me, 'You go to the pianist and read the note.' I was floating at the time."
After analyzing and reviewing the missed notes, he was asked again to sing the part. He shares, "Hindi ako aware sa paligid ko kasi sobra 'yung pressure, 'yung nerbyos. Tapos nu'ng naaral ko na, nagulat ako sa sinabi ni Sir Claude nu'ng tinanong na siya ng director na, 'Are you good with him'? Sabi niya, 'This guy is phenomenal.'"
Out of hundreds of people who auditioned for the role of Thuy, he was the one chosen for the "Miss Saigon UK" production. He was joined by other Filipino Artists such as Leo Tavarro Valdez as "The Engineer," Aicelle Santos as "Gigi," Joreen Bautista as the alternate "Kim," and a whole lot more Filipinos in the ensemble. His contract as Thuy lasted for two years, accumulating 553 performances all over Europe. The priceless joy of performing on center stage lives in Gerald's heart as he returned back to the Philippines. As his eyes sparkle with gratitude for being a part of such an amazing cast and a distinguished musical, he shared to Metro.Style the best thing about his entire journey.
According to Gerald, more than the opportunity to perform in front of large crowds and travel around the world, what he's most thankful for is the chance of being a part of a family whose members he can truly consider as genuine friends. He shares, "There's no amount of money that can pay for it. It's priceless, lahat ng mga natutunan ko. I grew so much not just as a performer but as a person as well. Pinaka-memorable sa'kin 'yung mga bonding with the cast. Up until now, we're still in contact, and the bloopers of course! Hindi ko makalilimutan."
Now that he's back in his hometown, he will be having a Homecoming Concert on May 4, 2019 at Solaire Resort & Casino, together with some of the "Miss Sagon" cast members Aicelle Santos, Joreen Bautista, Leo Tavarro Valdez, and former competitor in his earlier singing career, Jake Zyrus. In line with this big event is the release of his new single from Star Music titled "I Am Yours," composed by Kiko Salazar; it's now available on itunes and Spotify.
Tickets to his homecoming concert are available at Ticket World, contact 891-9999, or visit their website at ticketworld.com.ph.
Photos from @thegeraldsantos
gerald santos
ms. saigon
Bittersweet Symphony: A Review Of "Ang Huling El Bimbo"
From Puck To Bottom: Ballet Philippines' 'A Midsummer Night's Dream' Preview


text:
Title II of the ADA: State and Local Government
Home Title II of the ADA: State and Local Government
Title II of the Americans with Disabilities Act (ADA) protects people with disabilities from discrimination by state and local governments. It applies to all kinds of state or local governments and the services they provide. These include services from police departments, county councils, courts, and voting. The ADA covers state agencies like SC Department of Social Services (DSS) or SC Department of Disabilities and Special Needs (DDSN). Title II does not apply to private businesses. They are covered by another part of the ADA called Title III1
Your Rights under ADA Title II
There should not be different rules about when and where the government provides its services to someone with a disability. Special programs can be offered for people with disabilities, but they should be able to participate in programs open to the general public. The US Department of Justice has said that the integration of people with disabilities into the mainstream of American life is a fundamental purpose of the ADA.
The ADA requires public entities to make "reasonable modifications" in their usual ways of doing things when necessary so someone with a disability can take part in the program. Examples of modifications could include:
A man who uses crutches may have difficulty waiting in a long line to vote or register for college classes. The ADA does not require that the man be moved to the front of the line but staff must provide some alternative. They could bring out a chair and note where he is in line, so he doesn't lose his place.
A public agency that does not allow people to bring food into its facility may need to make an exception for a person who has diabetes and needs to eat frequently to control his glucose level.
A city or county ordinance that prohibits animals in public places must be modified to allow people with disabilities who use service animals to access public places. A city or county ordinance that prohibits motorized devices on public sidewalks must be modified for people with disabilities who use motorized mobility devices that can be used safely on sidewalks.
Only "reasonable" modifications are required. The ADA does not required changes the government can show would:
Threaten the safety of others, or result in a "fundamental alteration" of the essential nature of the entity's programs or services
A government office has a duty to communicate in a way that a person with a disability can understand. This includes someone who is deaf or blind. The government is to provide equipment or services that are needed for communication. Examples:
Sign language interpreter (if writing notes is not effective)
Large print documents or Braille printing
Readers or note takers (for a student at a state college)
Governments are to provide the aid or service requested by the person with the disability. However, they can turn down that request if the government can show that it would (1) fundamentally alter the nature of their program, service, or activity or (2) would result in undue financial and administrative burdens. Even then, the government must provide the most effective communication that is feasible. They cannot charge extra for communication services.
Accessibility of government buildings
The ADA's basic requirement is that government programs be available to people with disabilities. One way for a program to be available is making the building or place physically accessible to people with disabilities. Under the ADA, government buildings built or altered since 1991 must be accessible. This includes the building's parking areas, doors, and restrooms. In an older building that is not accessible, the government should offer its service in some other way. For example, if a social service agency is located in an inaccessible office, it could meet an applicant with a mobility disability at some other place that is accessible.
Enforcement of Your Rights
If you believe your ADA rights are being violated, you can:
Complain to the state or government agency where the problem is. Every government with at least 50 employees must have an "ADA Coordinator" and a way for you to file a grievance (complaint). For a smaller government, write to the head of the government, such as the mayor.
File a complaint with the federal government. A federal complaint can be sent to the US Department of Justice. A complaint can be sent directly to other federal departments, depending the kind of complaint you have. For example complaints about state or local colleges would go to the US Department of Education; complaints about city or county
parks would go the US Department of the Interior. A full listing where to send federal complaint is included in this fact sheet.
File a lawsuit in federal court. You are not required to file a complaint before filing a lawsuit. For more information about filing a lawsuit you may wish to contact a private attorney. If you do not know of one, you may contact the Lawyer Referral Service at 1-800-868-2284.
Title II—Where to File Your Discrimination Complaint
State/Local Government Agencies
State or local government agencies with 50 or more employees are required to designate an ADA Coordinator and to adopt grievance procedures to resolve complaints of ADA violations. If the agency that you believe discriminated against you has 50 or more employees, ask to speak to the ADA Coordinator (ADA Coordinators are sometimes called Disability Coordinators or 504 Coordinators). You may also file a grievance. For smaller government agencies, contact the office of the person in charge of the agency and ask how you can file a complaint. This could be the mayor's office or a commissioner's office.
Federal Government Agencies
If you are not satisfied with action on your grievance by your local/state government agency, or if you do not wish to file a grievance, you may file a complaint of discrimination with the federal government. Complaints of discrimination under Title II are investigated by several different federal agencies. See designated agencies list below. You may always file your complaint with the Department of Justice; however, it may take some time for them to forward your complaint to the appropriate agency. If you can file with the appropriate agency, it may result in quicker action on your complaint.
Designated Federal Agencies For Filing Complaints
Department of Agriculture: All programs, services, and regulatory activities relating to farming and the raising of livestock, including extension services. Complaints should be sent to: U.S. Department of Agriculture; Director, Office of Adjudication; 1400 Independence Avenue, SW; Washington, DC 20250.
Department of Education: All programs, services, and regulatory activities relating to the operation of elementary and secondary education systems and institutions, institutions of higher education and vocational education (other than schools of medicine, dentistry, nursing and other health-related schools), and libraries. Complaints should be sent to: Office for Civil Rights; U.S. Department of Education; 400 Maryland Avenue, SW; Washington, D.C. 20202-1475.
Department of Health and Human Services: All programs, services and regulatory activities relating to the provision of health care and social services, including schools of medicine, dentistry, nursing and other health-related schools, the operation of health care and social service providers and institutions, including grass-roots and community services organizations and programs, and preschool and day care programs. Complaints should be sent to: Centralized Case Management Operations; U.S. Department of Health and Human Services; 200 Independence Avenue, SW; Room 509F HHH Bldg.; Washington, D.C. 20201.
Department of Housing and Urban Development: All programs and services and regulatory activities relating to state and local public housing, and housing assistance and referral. Complaints should be sent to: Assistant Secretary for Fair Housing and Equal Opportunity, Department of Housing and Urban Development, 451 7th Street, SW, Washington, D.C. 20410 or Atlanta Regional Office, U.S. Department of Housing and Urban Development Southeast Office 40 Marietta Street Atlanta, GA 30303
Department of the Interior: All programs and services and regulatory activities relating to lands and natural resources, including parks and recreation, water and waste management, environmental protection, energy, historic and cultural preservation, and museums. Complaints should be sent to: Director, Office of Civil Rights, Department of the Interior, 1849 C Street, NW, Washington, D.C. 20547
Department of Justice: All programs, services and regulatory activities relating to law enforcement, public safety and the administration of justice, including courts and correctional institutions; commerce and industry, including general economic development, banking and finance, consumer protection, insurance, and small business; planning, development and regulation (unless assigned to other designated agencies); state and local government support services (e.g., audit, personnel, comptroller, administrative services); all other government functions not assigned to other designated agencies. Complaints should be sent to: US Department of Justice 950 Pennsylvania Avenue, NW, Civil Rights Division Disability Rights Section – 1425 NYAV Washington, D.C. 20530
Department of Labor: All programs, services and regulatory activities relating to labor and the work force. Complaints should be sent to: Director, Civil Rights Center, ATTN Office of External Enforcement, Department of Labor, 200 Constitution Avenue, NW, Room N-4123, Washington, D.C. 20210
Department of Transportation: All programs about local public transportation services, such as city buses and public rail transit (e.g. subways, commuter rails, Amtrak). Public transportation authorities may not discriminate against people with disabilities. They must comply with requirements for accessibility in newly purchased vehicles, make good faith efforts to purchase or lease accessible used buses, remanufacture buses in an accessible manner, and, unless it would result in an undue burden, provide paratransit where they operate fixed-route bus or rail systems. Paratransit is a service where individuals who are unable to use the regular transit system independently (because of a physical or mental impairment) are picked up and dropped off at their destinations. Questions and complaints about public transportation should be directed to: Office of Civil Rights, Federal Transit Administration, U.S. Department of Transportation, 1200 New Jersey Avenue SE, Washington, D.C. 20590
The Department of Justice Complaint Form is available online. You can also contact Disability Rights SC for a copy of the form. You can also file online here.
Contact List For More Information
Southeast ADA Center
1419 Mayson Street NE
1-800-949-4232 (V/TTY)
404-541-9001(Voice)
US Department of Justice ADA Information Hotline
1-800-514-0301 (voice) or 1-800-514-0383 (TTY)
US Department of Justice
File a complaint online in English here.
File a complaint online in Spanish here.
File a complaint by Mail: US Department of Justice
Civil Rights Division
Disability Rights Section – 1425 NYAV
File a complaint by fax: (202) 307-1197
Disability Rights Education & Defense Fund (DREDF)
510.644.2555 (Voice) 510-841-8645 (Fax/TTY)
Architectural and Transportation Barriers Compliance Board (Access Board)
1331 F Street NW, Suite 1000
Washington, DC 2004-1111
1 See Disability Rights South Carolina's fact sheet, Americans with Disabilities Act (Title III)
This publication provides legal information, but is not intended to be legal advice. As the law may change, please contact Disability Rights SC for updates. Please let us know if you would like this information in an alternative format.
View a PDF of this document