text:
UzumakiWarlord
UzumakiWarlord last won the day on March 23
UzumakiWarlord had the most liked content!
About UzumakiWarlord
Otaku In Training
Hollywood, MD
Anime/Manga, Video Games, Movies, and TV.
razisgosu
otoxo
Kirarakim
Bsus1412
djmaestro777
The Otakon 2019 Guest Request Thread
UzumakiWarlord replied to a topic in Otakon Guests
I maybe a little late in saying so, but I would like to say that I'm quite happy to see Erika Harlcher, Jason Liebrecht, and Kari Walgren coming. Elizabeth Maxwell is a solid choice, too, even if I don't have much interest in meeting her for the time being. I hope a past guest who hasn't been there in a long time can be invited. I have said it many times already, but if there's one past guest who truly deserves to be brought back, it's Monica Rial. And while I am pleased with the choices in guests so far (on the dub actors side of things, anyway), depending what other dub actors will be announced and invited, I may just give up on making guest requests ever again. I'm sorry, but as time has gone by, I've been gradually losing faith that certain guests that me, and other folks as well have often requested for will ever be brought back. Admittedly, half the time I say to myself "they'll never bring *insert past guest's name* back", no matter how many requests we make. I can't even feel all that optimistic to believe the old "there's always next year". While patience is a virtue, there's also a fact about patience people take for granted too often: IT'S NEVER LIMITLESS. But of course, that's solely my own fault for getting my hopes up every time I make requests on here. Despite what I've just said though, I do hope the staff will consider bringing Monica back for this year. I'll try and keep my fingers crossed and hope that this year can make it possible for her to be invited, but should it end up having her be put off for another year, I'll tip my hat in defeat, and peacefully walk away from future guest request threads.
Guys, let's drop the topic entirely. You're all getting toxic with one another. And nobody likes to get toxic with anyone. I know I certainly don't.
No offense, but asking for Vic to be invited is in pretty bad and pour taste right now. Given the controversy surrounding him. It's gotten so big that various different cons have canceling his appearances left and right, and he's also lost a couple of his own voice roles. He's been fired from being in the cast of RWBY, and the folks at Rooster Teeth have terminated their relationship with him. There's been so much piling up against him, that honestly, this will likely force him into early retirement. Especially since many have also said that there are also times where he can behave like a total diva. While I am somebody that has met Vic a couple of times, and had a positive experience each time I had, with all the many things that have piled up against him, I honestly support the man anymore.
What if we had some other former Power Ranger actors as guests? Like Austin St. John, David Yost, Walter Emanuel Jones, and Amy Jo Johnson? (Original red, blue, black, and pink rangers respectively) Because if Otakon has hosted former ranger actors like Johnny Yong Bosch and Jason David Frank, then why not? And while on this topic, what if we had some guests from Japan who are heavily involved in Tokusatsu works? For those that don't know, Tokusatsu are live action tv and movies that have a heavy use in practical effects. Super Sentai (The source material for Power Rangers) is a primary example. Other than former ranger actors from our own country in the US, maybe the staff could at some point in time get in touch with an actor who worked on any previous Super Sentai series. Although given that tokusatsu is live action, getting someone who has worked on any kind of show of that medium would have to be more difficult to get in touch with than a popular seiyuu. And does anyone remember the show VR Troopers? One of the actors on that show, Brad Hawkins was one of the troopers, and later in his life and career would do some voice acting. Like recently, he's been playing the titular Goblin Slayer. Also, I wonder if acting in a tokusatsu show, and then moving on to voice acting is a thing over in Japan, too. Since it was the case here in America with JYB, Walter, and Brad.
Since one of Otakon's missions is to spread knowledge about east Asian culture beyond anime, what if we had a guest or two that was involved with a different style of animation? Like stop-motion. It's kind of to come mind recently that stop-motion animation isn't really an animation style you hear about coming from Japan. Like what if there could be a guest who was involved with stop-motion? Like anyone who's worked on the holiday specials released by Rankin/Bass? Not too many people know about this but the animation for practically every stop-motion tv holiday special released by Rankin/Bass (Rudolph the Red-Nosed Reindeer, The Little Drummer Boy, Santa Claus is comin' to Town, etc.) WERE ALL ANIMATED IN JAPAN. That's just an example, of course, and I was just thinking that having someone who was involved with stop-motion would be a nice guest to have, and we could all learn how in any sort of stop-motion production, how the many figures and puppets are made, and setting the frames to the flow naturally in every little shot. Unless if it's already been done before, what if we could have a guest whose works involve stop-motion animation?
Indeed, regarding Steve Blum. Especially since he's one of those guests that the staff haven't had for years (the last time he was a guest at Otakon was 2007). It's the same case with some other guests like Monica Rial, Jamie Marchi, Chuck Huber, and at least a dozen others. I know I've spoken about this many times, but isn't there anyone on the staff who actually would like to see folks like Steve, Monica, and Jamie come back? Are they even aware of how long it's been since they've been guests at Otakon? I'm sorry, but it's just very annoying and frustrating how it tends to take the staff forever to come around to have certain past guests to come back. Even if there are some good, and justifiable reasons, it still doesn't change the fact that they've put off bringing certain guests back for too long. Despite my complaints, though, I do hope that at least someday the staff will come around to having Steve, Monica, and Jamie come back. And just about any other previous guest that they haven't had for so long. Where's the love for those people?
UzumakiWarlord started following Autographs 2016, Otakon 2018: The Good, The Bad, and The Ugly, The Otakon 2019 Guest Request Thread and and 7 others August 14, 2018
With 2018's Otakon in the books, I too shall start making my wishlist for some of the guests I'd like to see be invited for 2019's Otakon. These are the following people I would strongly consider inviting: Dub Voice Actors 1. Jamie Marchi 2. Monica Rial 3. Eric Vale 4. Steve Blum 5. Mary Elizabeth McGlynn 6. Wendee Lee 7. Ben Diskin 8. Sean Chiplock 9. Amber Lee Connors 10. Morgan Berry 11. Justin Briner 12. Cliff Chaplin 13. Karen Strassman 14. Kira Buckland 15. Xander Mobus 16. Matt Mercer 17. Marisha Ray 18. Erika Harlacher 19. Ian Sinclair 20. Chris Sabat 21. Luci Christian 22. Erica Lindbeck 23. Patrick Seitz 24. Yuri Lowenthal 25. Tara Platt 26. Sarah Weidenheft 27. Matt Shipman 28. Felecia Angelle 29. Tia Ballard 30. Veronica Taylor Seiyuu 1. Yoko Hikasa 2. Hitomi Hirada 3. Yoshisugu Matsuoka Cosplayers 1. Yaya Han 2. Jessica Nigri 3. Giada Robin Musical Acts 1. Fripside 2. Linked Horizon
Guest Request: 2015
UzumakiWarlord replied to UzumakiWarlord's topic in Otakon Guests
Now that the schedule has been released, I have a pretty good idea of what I would like to do as far as both autograph sessions, premieres, and panels go. Though I do have one little query that I wanted to ask- Will there be any autograph sessions for Chris and Sean? I am aware that all things in the schedule are indeed subject to change between now, and even during the actual event, but Sean and Chris will still autograph sessions like every guests, right? Any answer that any staff member can give will be much appreciated!
I'm VERY happy to see Bryce Papenbrook is coming! And let me to all one reason why: I am one of the co-creators and co-admins of his Facebook fan club the Aincrad Cadet Corp.! And yes, it was created with both the permission, and blessing of Bryce himself! Here are the links to the group, and page: https://www.facebook.com/groups/539772002799763/ https://www.facebook.com/aincradcadetcorp I really hope I'll get to meet him next month, along with many others, so Jim- You and your team have done good this year!
I would like to make the same suggestion that SteveUzumaki, and Dostovei said about using the Hyatt Ballroom again, like last year. I went to that area last year for Wendee Lee's Friday session, and it worked out REALLY well. And seeing that Romi Park is a very popular Seiyuu, it does make sense to have one of her sessions take place in that area, if not all of them. And also, assuming that you guys are going to use the Hyatt area again, I would strongly recommend having at least one of Travis and Laura's session take place there, given how big name of guests they are. And considering how popular Mr. Tatum is, maybe have one of his sessions take place there, too. Perhaps even Sean Schemmel and Chris Sabat, too.
Lauren Landa is a very solid choice to have for a guest. She's great as Kasumi on the Dead or Alive games, Leia on Tales of Xillia, Annie Lockhart on Attack on Titan, and Kyouko on Madoka Magica. As for the other 2 dub actors, I'm hoping one of them is Bryce Papenbrook! But whoever it is, is okay with me, depending on who they might be.
A voice actor known more for his/her video game work until recently? I'm going to make a guess, and say that it's Bryce Papenbrook. He has done a lot of work on video games, but has been doing a lot more anime in recent years. Particularly with series like Sword Art Online, Attack on Titan, and Blue Exorcist.
If Chris and Sean are coming on behalf of Funimation, then there's gotta be some promotion going on. And it's more than likely that new DBZ movie coming out.
Jim, I want to freaking hug you right now, for bringing in Sean, and Chris Sabat this year!
Since we've gotten quite a few Aldnoah.Zero folks, I wonder it will be possible to bring back Gen Urobuchi for this year. I think it's very unlikely, but it would be real cool if he got invited to join the Aldnoah folks that got invited, too.


Warwick England: The town of Warwick is situated near the center of England, 8 miles from Stratford-upon-Avon. This Castle is the finest medieval castle in England and is one of the most popular tourist destinations in the United Kingdom. Many forms of medieval entertainment are staged at the castle throughout the year. Some people pronounce it as Warrick castle.
There is a beautifully proportioned conservatory, which acts as a focal point in the landscape, was built in 1786 by a local mason, William Eborall.
Peacock Garden is a large number of peacocks. If you are lucky, you will be rewarded with a view of a male peacock with fully opened feathers.
It's set in the center of the ancient town of Warwick. People have worshipped on this site for over 1,000 years, and have left evidence of their faith in the architecture and decoration of the building – one of the largest and most interesting Churches in England. Its famous for its Beauchamp Chapel, Medieval/ Tudor tombs, and tower.
The Guildhall, now the Lord Leycester Hospital, is a set of timber-framed buildings dating from the 14th century. The unique chantry chapel, galleried courtyard, superb Great Hall, and Guildhall form what Robert Dudley, Earl of Leicester, established as an old soldier's home in 1571. The location of the building, built into the ancient walls and West Gate of the town, is unique. Today, ex-servicemen and their wives live in modernized flats and in return give their services towards the running of the Hospital.
As per the county's website, Warwick offers to visitors today the opportunity of exploring not only the architectural gems of our medieval history but also those of our more recent past and the modern vibrant life of the county town of Warwickshire. Warwick is located in the rural Heart of England. It is close to Stratford-upon-Avon, Royal Leamington Spa, and Kenilworth. The closest cities are Coventry and Birmingham.
By Car: M40 Motorway, junction 15 then A429 to Warwick.
By Coach: Regular services of National Express. Tel: 08705 808080.
By Train: Warwick train station is 10 minutes walk from the town center and Castle. Trains are available to Birmingham, Stratford-upon-Avon, London (Paddington and Marylebone) and intermediate stations. Use Leamington Spa for connections to Banbury, Coventry, Oxford and intermediate stations. Tel 08457 484950.
Castle is walking distance from the train station.


As a dad, I say "I'm sorry" a lot. Probably every day. Multiple times a day.
This shouldn't have surprised me, but this is one of the things about being a dad that caught me off guard. I thought good dads just never messed up, or at least, only occasionally messed up towards their kids. Needless to say, I was pretty discouraged when I learned the truth about fatherhood—the truth that it is hard and filled with mistakes, riddled with 20/20 hindsight, and constantly suffering under the brokenness of sin.
As James talks about what it means to be a follower of Christ, he doesn't tell people, "Don't mess up!" James tells us that when we falter, confess and seek forgiveness. As I allowed this truth to inform the way I grew into fatherhood, I realized that there is something powerful in confessing and apologizing to my children. Here are three powerful reasons to make saying you're sorry a regular part of your parenting strategy.
It's God's prescription for a broken world.
When I'm wronged, there is a longing in me for the person who wronged me to apologize. This is not a selfish impulse, but rather a God-given desire for relationships to be mended. Our kids feel that same desire. When they have been wronged, there is something in them (whether they know how to vocalize it or not) that longs for that wrong to be made right. They know when you've treated them unfairly. They know when you've made a mistake toward them.
As a Dad, I get the opportunity to take the initiative in mending the pain I caused in my children. I get to meet that longing of reconciliation. If my kids had a fever, I wouldn't withhold medicine. When I've done something wrong to my kids, withholding an apology is no different than not giving them Tylenol when their temperature is rising. Confession, repentance, and forgiveness are the prescription God gives for broken relationships, and as a Dad I get the privilege of caring for my kids in that way.
It's a natural way to teach them an unnatural response.
It is not natural to own our mistakes. I know for me, my gut is always to defend and justify my actions, which usually only serves to blame the offended for the offense. I'm really good at doing this with my kids. I have to practice the discipline of apologizing. I have to stop my natural inclinations and do something that is consistently unnatural.
Because it's the only honest way forward.
One of the greatest weights I carry is the fact that my kids see the worst of me on a regular basis. Since we're most comfortable at home, often times we let down our guard and can be, candidly, pretty nasty. This is a weight I feel because I know that my kids will learn more about faith at home, watching how my wife and I act, than they will at church or any other religious context. If I could be perfect, I would. But that's not really a possibility.
Because of that, the regular practice of confessing my sin to my kids and seeking their forgiveness is the only honest way to model a practical faith at home. Mistakes aren't necessarily the enemy of faith, but hypocrisy is. My hope is that my kids will grow to walk through their own faith with honesty, which means walking through it as James writes, confessing and forgiving one another.
Postmodern Parent. I am a husband, father, pastor, songster, writer, and most importantly, believer in the one true Messiah, Jesus Christ..


text:
Q: Translating my stored procedure query into valid T-SQL I have a stored procedure as follows:
    ALTER PROCEDURE [dbo].[getReconciliationMarketMessageInCRM] --'02 jun 2014'

    @readDate datetime
AS

declare @newDate date

select a.New_MessageTypeCode as 'messageType', count(a.New_MessageTypeCode) as 'Received'
into #temp1
from New_marketmessagein as a
--where CreatedOn between '2016-7-18 04:00' and '2016-7-19 04:00'
where CreatedOn between @readDate + ' 04:00' and dateadd(day,1,@readDate) + ' 04:00'
group by a.New_MessageTypeCode

select
sum(CASE WHEN #temp1.messageType = '014R' then #temp1.Received else 0 end) as '014R',
sum(CASE WHEN #temp1.messageType = '101' then #temp1.Received else 0 end) as '101',
sum(CASE WHEN #temp1.messageType = '101P' then #temp1.Received else 0 end) as '101P',
sum(CASE WHEN #temp1.messageType = '101R' then #temp1.Received else 0 end) as '101R',
sum(CASE WHEN #temp1.messageType = '102' then #temp1.Received else 0 end) as '102',
SUM(CASE WHEN #temp1.messageType = '102P' then #temp1.Received else 0 end) as '102P',
SUM(CASE WHEN #temp1.messageType = '102R' then #temp1.Received else 0 end) as '102R',
SUM(CASE WHEN #temp1.messageType = '105' then #temp1.Received else 0 end) as '105',
SUM(CASE WHEN #temp1.messageType = '105L' then #temp1.Received else 0 end) as '105L',
SUM(CASE WHEN #temp1.messageType = '106D' then #temp1.Received else 0 end) as '106D',
SUM(CASE WHEN #temp1.messageType = '106E' then #temp1.Received else 0 end) as '106E',
SUM(CASE WHEN #temp1.messageType = '110' then #temp1.Received else 0 end) as '110',
SUM(CASE WHEN #temp1.messageType = '111' then #temp1.Received else 0 end) as '111',
SUM(CASE WHEN #temp1.messageType = '111A' then #temp1.Received else 0 end) as '111A',
SUM(CASE WHEN #temp1.messageType = '111L' then #temp1.Received else 0 end) as '111L',
SUM(CASE WHEN #temp1.messageType = '111R' then #temp1.Received else 0 end) as '111R',
SUM(CASE WHEN #temp1.messageType = '112' then #temp1.Received else 0 end) as '112',
SUM(CASE WHEN #temp1.messageType = '112R' then #temp1.Received else 0 end) as '112R',
SUM(CASE WHEN #temp1.messageType = '112W' then #temp1.Received else 0 end) as '112W',
SUM(CASE WHEN #temp1.messageType = '114' then #temp1.Received else 0 end) as '114',
SUM(CASE WHEN #temp1.messageType = '115' then #temp1.Received else 0 end) as '115',
SUM(CASE WHEN #temp1.messageType = '115R' then #temp1.Received else 0 end) as '115R',
SUM(CASE WHEN #temp1.messageType = '116' then #temp1.Received else 0 end) as '116',
SUM(CASE WHEN #temp1.messageType = '116A' then #temp1.Received else 0 end) as '116A',
SUM(CASE WHEN #temp1.messageType = '116N' then #temp1.Received else 0 end) as '116N',
SUM(CASE WHEN #temp1.messageType = '116R' then #temp1.Received else 0 end) as '116R',
SUM(CASE WHEN #temp1.messageType = '117D' then #temp1.Received else 0 end) as '117D',
SUM(CASE WHEN #temp1.messageType = '117R' then #temp1.Received else 0 end) as '117R',
SUM(CASE WHEN #temp1.messageType = '122' then #temp1.Received else 0 end) as '122',
SUM(CASE WHEN #temp1.messageType = '122R' then #temp1.Received else 0 end) as '122R',
SUM(CASE WHEN #temp1.messageType = '130D' then #temp1.Received else 0 end) as '130D',
SUM(CASE WHEN #temp1.messageType = '130R' then #temp1.Received else 0 end) as '130R',
SUM(CASE WHEN #temp1.messageType = '131' then #temp1.Received else 0 end) as '131',
SUM(CASE WHEN #temp1.messageType = '137R' then #temp1.Received else 0 end) as '137R',
SUM(CASE WHEN #temp1.messageType = '261' then #temp1.Received else 0 end) as '261',
SUM(CASE WHEN #temp1.messageType = '300' then #temp1.Received else 0 end) as '300',
SUM(CASE WHEN #temp1.messageType = '300S' then #temp1.Received else 0 end) as '300S',
SUM(CASE WHEN #temp1.messageType = '300W' then #temp1.Received else 0 end) as '300W',
SUM(CASE WHEN #temp1.messageType = '301' then #temp1.Received else 0 end) as '301',
SUM(CASE WHEN #temp1.messageType = '301N' then #temp1.Received else 0 end) as '301N',
SUM(CASE WHEN #temp1.messageType = '303R' then #temp1.Received else 0 end) as '303R',
SUM(CASE WHEN #temp1.messageType = '305' then #temp1.Received else 0 end) as '305',
SUM(CASE WHEN #temp1.messageType = '306' then #temp1.Received else 0 end) as '306',
SUM(CASE WHEN #temp1.messageType = '306W' then #temp1.Received else 0 end) as '306W',
SUM(CASE WHEN #temp1.messageType = '307' then #temp1.Received else 0 end) as '307',
SUM(CASE WHEN #temp1.messageType = '307W' then #temp1.Received else 0 end) as '307W',
SUM(CASE WHEN #temp1.messageType = '308' then #temp1.Received else 0 end) as '308',
SUM(CASE WHEN #temp1.messageType = '310' then #temp1.Received else 0 end) as '310',
SUM(CASE WHEN #temp1.messageType = '310W' then #temp1.Received else 0 end) as '310W',
SUM(CASE WHEN #temp1.messageType = '311' then #temp1.Received else 0 end) as '311',
SUM(CASE WHEN #temp1.messageType = '320' then #temp1.Received else 0 end) as '320',
SUM(CASE WHEN #temp1.messageType = '320W' then #temp1.Received else 0 end) as '320W',
SUM(CASE WHEN #temp1.messageType = '321' then #temp1.Received else 0 end) as '321',
SUM(CASE WHEN #temp1.messageType = '330' then #temp1.Received else 0 end) as '330',
SUM(CASE WHEN #temp1.messageType = '331' then #temp1.Received else 0 end) as '331',
SUM(CASE WHEN #temp1.messageType = '332' then #temp1.Received else 0 end) as '332',
SUM(CASE WHEN #temp1.messageType = '332W' then #temp1.Received else 0 end) as '332W',
SUM(CASE WHEN #temp1.messageType = '341' then #temp1.Received else 0 end) as '341',
SUM(CASE WHEN #temp1.messageType = '342' then #temp1.Received else 0 end) as '342',
SUM(CASE WHEN #temp1.messageType = '352R' then #temp1.Received else 0 end) as '352R',
SUM(CASE WHEN #temp1.messageType = '591' then #temp1.Received else 0 end) as '591',
SUM(CASE WHEN #temp1.messageType = '594' then #temp1.Received else 0 end) as '594',
SUM(CASE WHEN #temp1.messageType = '595' then #temp1.Received else 0 end) as '595',
SUM(CASE WHEN #temp1.messageType = '596' then #temp1.Received else 0 end) as '596',
SUM(CASE WHEN #temp1.messageType = '597' then #temp1.Received else 0 end) as '597',
SUM(CASE WHEN #temp1.messageType = '598' then #temp1.Received else 0 end) as '598',
SUM(CASE WHEN #temp1.messageType = '601' then #temp1.Received else 0 end) as '601',
SUM(CASE WHEN #temp1.messageType = '602' then #temp1.Received else 0 end) as '602',
SUM(CASE WHEN #temp1.messageType = '700' then #temp1.Received else 0 end) as '700',
SUM(CASE WHEN #temp1.messageType = '700W' then #temp1.Received else 0 end) as '700W',
SUM(CASE WHEN #temp1.messageType = '701' then #temp1.Received else 0 end) as '701',
SUM(CASE WHEN #temp1.messageType = '701W' then #temp1.Received else 0 end) as '701W'
from #temp1

With the help of an answer I was able to shorten this as follows:
SELECT *
FROM (
select a.New_MessageTypeCode
from New_marketmessagein as a
WHERE CreatedOn between '2016-7-20 04:00' and '2016-7-21 04:00'
) AS SRC
PIVOT (COUNT(New_MessageTypeCode ) FOR New_MessageTypeCode IN ([014R], [101], [101P], [101R], [102], [102P], [102R], [105],
[105L], [106D], [106E], [110], [111], [111A], [111L], [111R], [112], [112R], [112W], [114], [115], [115R], [116], [116A],
[116N], [116R],[117D],[117R], [122], [122R], [130D], [130R], [131], [137R], [261], [300], [300S], [300W], [301], [301N],
[303R], [305], [306], [306W], [307], [307W], [308], [310], [310W], [311], [320], [320W], [321], [330], [331], [332], [332W],
[341],[342], [352R], [591], [594], [595], [596], [597], [598], [601], [602], [700], [700W], [701], [701W])) As test

I am now trying to set up a SQL server job using transact SQL that will email this everyday in an attached csv file as follows:
DECLARE @query_attachment_filename VARCHAR(100) = 'Reconciliation-Count-Ending-' + CONVERT(VARCHAR(10), GETDATE(), 112) + '.csv';

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'support',
@recipients = 'johnpaul@energy.co.uk;martin@energy.co.uk',
@subject = 'Reconciliation Count',
@query = N'SET ANSI_WARNINGS OFF;SET NOCOUNT ON;SELECT *
FROM (
    select a.New_MessageTypeCode
    from New_marketmessagein as a
    WHERE CreatedOn between DATEADD(DAY, –1, GETDATE()) and GETDATE()
) AS SRC
PIVOT (COUNT(New_MessageTypeCode ) FOR New_MessageTypeCode IN ([014R], [101], [101P], [101R], [102], [102P], [102R], [105],
[105L], [106D], [106E], [110], [111], [111A], [111L], [111R], [112], [112R], [112W], [114], [115], [115R], [116], [116A],
[116N], [116R],[117D],[117R], [122], [122R], [130D], [130R], [131], [137R], [261], [300], [300S], [300W], [301], [301N],
[303R], [305], [306], [306W], [307], [307W], [308], [310], [310W], [311], [320], [320W], [321], [330], [331], [332], [332W],
[341],[342], [352R], [591], [594], [595], [596], [597], [598], [601], [602], [700], [700W], [701], [701W])) As test ;',
@attach_query_result_as_file = 1,
@query_attachment_filename = @query_attachment_filename,
@query_result_header =0,
@query_result_separator = ' '

Although I have replaced the query section of a previously working job this is erroring due to an error formatting query, am I missing something here?

A: Your query can be simplified by using pivot and avoiding temp table all together. Try something like this:
SELECT *
FROM (
    select a.New_MessageTypeCode
    from New_marketmessagein as a
    WHERE CreatedOn between @readDate + ' 04:00' and dateadd(day,1,@readDate) + ' 04:00'
) AS SRC
PIVOT (COUNT(New_MessageTypeCode ) FOR New_MessageTypeCode IN (
    [014R], [101], [101P] -- etc...
) AS PVT

EDIT: To awnser your updated question: the query you provide is not executed in your current context, you probable need add to the databasename when referencing your table. To further troubleshoot send yourself a mail to see the context it is using.
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'support',
@recipients = '...',
@subject = 'TEST',
@query = N'SELECT SYSTEM_USER, DB_NAME()'

redpajama_set_name: RedPajamaStackExchange


Chuck Hughes' cookies recipe to make a special homemade treat for your dog and for yourself!
Preheat the oven to 350 degree F.
For the bananas: Mix the bananas in a bowl. Squeeze the lemon juice on them to ensure they don't brown. On a parchment paper-lined baking tray, brush 1 tablespoon melted butter. Sprinkle 1 tablespoon sugar and lay out the banana slices. Brush the slices with remaining butter and sprinkle with remaining sugar. Bake for about 1/2 hour until the bananas are golden brown. Set aside.
For the cookies: In a medium bowl, stir together the peanut butter and honey. Mix in the flour, then the caramelized bananas and chocolate. Line a baking sheet with parchment paper. Drop tablespoon-size clusters on the baking sheet. Bake for 20 minutes, or until golden brown.
For dog cookies, omit the banana chips and chocolate.


text:
Rebecca Chase Williams was a journalist and mayor of Brookhaven, Georgia.  Previously a District 1 City Councilwoman, Williams became mayor after the city's inaugural mayor, J. Max Davis, resigned in May 2015.  Prior to her public service, Williams was a distinguished ABC News journalist for more than twenty years.

Mayor Williams is the wife of Dick Williams, editor and publisher of The Dunwoody Crier, a weekly newspaper covering Dunwoody, Brookhaven, and Sandy Springs. Williams hosted the weekly Atlanta television program, The Georgia Gang for decades.
She died of cancer March 11, 2020.

References

External links
Mayor Williams' page on Brookhaven city website
The Dunwoody Crier
Dick Williams's webpage on The Georgia Gang

People from Brookhaven, Georgia
Georgia (U.S. state) city council members
Women mayors of places in Georgia (U.S. state)
American women journalists
ABC News personalities
Living people
Year of birth missing (living people)
21st-century American women

redpajama_set_name: RedPajamaWikipedia


The coupon code is available for sitewide merchandise. Limited time only.
Offer cannot be used in conjunction with other offers.
Can not be used on past orders.
Some exclusions may apply. The minimum purchase is required.
Some additional restrictions may apply.
Coupon valid for one time use only.
Spend over $100 and get Free Shipping. Offer is valid for limited time only.
It is very simple to get a code. Click on "Show coupon code". Copy it and apply it in the required field on the website.
2. Select a category for the item you want. You can simply type in your item as a search word.
3. On the next page are results related to your search. Click on one, another page with related items opens.
4. Select an item by clicking on it. On the new page is an image of your item and its description. Decide a color, size and quantity if it is needed. Click on "Add to shopping bag".
Click on the image of the bag at the top right corner of the page, when the pop up window appears, click on "Proceed to checkout". On the next page, fill in the necessary information to finalize the purchase of your item. Scroll down the page, when you notice the words "Discounts" stop and paste the code into the field. Press "Apply code".
Luna Bazaar is a store that sells items that you can decorate your home with. These items are beautiful, fun, and exciting. Luna Bazaar offers hanging decorations, lighting options, items for tabletops, and gifts and favors. This website offers the biggest selection of paper lanterns available that are made from a variety of colors, designs, and shapes. Luna Bazaar is a great store to browse through if you want to liven up a room or home. Luna Bazaar is more than just a store—It's a lifestyle.


text:
Kingston Chapel
Napanee Chapel
Green Burial Options
Aquamation
Planning a Burial Service
Online Funeral Planning Services
Memorial Keepsakes
Simple Cremation or Aquamation Service
1 Day Affordable Cremation Service
1 Day Burial Service
2 Day Cremation Service
Jack Bennett
Wednesday, December 7th, 1932 - Monday, July 27th, 2020
To share your memory on the wall of Jack Bennett, sign in using one of the following options:
Provide comfort for the family by sending flowers or planting a tree in memory of Jack Bennett
Jack's Tribute Fund
Bennett; Reverend Jack - Peacefully passed away on Monday July 27th, 2020 at KGH. Jack, beloved husband of Marion for 58 years, loving father to Andrew (Barbara), Dartmouth, N.S.; Jacqueline Arthur (Gordon), Stittsville; Late Paul (Darlene), Surrey,... Read More
Bennett; Reverend Jack - Peacefully passed away on Monday July 27th, 2020 at KGH. Jack, beloved husband of Marion for 58 years, loving father to Andrew (Barbara), Dartmouth, N.S.; Jacqueline Arthur (Gordon), Stittsville; Late Paul (Darlene), Surrey, B.C. and Mark (Amber), Kingston. Amazingly devoted grandfather to William, Grace (Brady), Riley, Leah Owen and Adam. Dear brother-in-law to Peter Milnes and Jean Bennett both of England and uncle to many nieces and nephews in England. Predeceased by his siblings Ronnie, Stanley, Joyce, and Gordon Bennett. Jack spent over 50 years in active ministry and was an avid volunteer for many years with Providence Care Palliative Care Unit, Marine Museum of the Great Lakes, and the Kingston Hard of Hearing Club. Some of his favourite pastimes included swimming, writing, reading, and sharing stories with his grandchildren. Memorial donations can be made to St Paul's Anglican Church (Queen/Montreal St), Marine Museum of the Great Lakes, Providence Care Palliative Care unit, or to a charity of your choice. A Celebration of Life will be held at a later date. Arrangements in the care of Wartman Funeral Home, 980 Collins Bay Rd, Kingston. On-line condolences at www.wartmanfuneralhomes.com
To plant a memorial tree in honor of Jack Bennett, please visit our Heartfelt Sympathies Store.
Receive notifications about information and event scheduling for Jack
Receive text or email updates for Jack
There are no events scheduled. You can still show your support by sending flowers directly to the family, or planting a memorial tree in memory of Jack Bennett.
Donations are being accepted for:
ST. PAUL'S CHURCH MARINE MUSEUM OF THE GREAT LAKES AT KINGSTON
We encourage you to share your most beloved memories of Jack here, so that the family and other loved ones can always see it. You can upload cherished photographs, or share your favorite stories, and can even comment on those shared by others.
Plant a Tree in Memory of Jack
6 trees have been planted in memory of Jack Bennett
Rob Helliwell. Pierre Joyal, Eric Broderick and Brad Clark
Our condolences to Andrew and the rest of the Bennett family during these difficult times. Sincere Condolences Rob, Pierre, Eric and Brad
3 trees were planted in the memory of Jack Bennett
Melodie Aubrey
Jack and his wife Marion were tireless volunteers, especially in promoting the needs of people with hearing loss
Jack was a delightful man, always smiling. The type of person that drew people to him. His ministry and kindness will surely be missed.
Your friend, Melodie Aubrey
Sr. Marilyn Larocque, R.H.S.J.
Posted Aug 07, 2020 at 06:51am
Dear Marion and Family,
Our love, prayers and sympathy are with you in the loss of Jack.
Thank you Marion and Jack for your friendship and sharing of your gift of music with us when we had Sunday Masses at Hotel Dieu Hospital Chapel several years ago.
Sister Marilyn Larocque and Sisters, R.H.S.J.
Marjorie & Kevin
With loving memories of "Jack Bennett",
A memorial tree was planted in the memory of Jack Bennett — Plant a Tree Now
Kevin Orr and Marjorie Sagriff
Although Marjorie's been good friends with Jack and Marion Bennett for a long time, I've only gotten to know them over the last few years. Marion and I would go grocery shopping Saturday morning and I'd visit with Jack for a few hours in the afternoon. The three of us would sit, talk and listen, mostly to Jack recalling the events of his life. What a story teller! Jack clearly led many lives, most of them, and no doubt the best of them, with his loving wife Marion. I'll never forget that mischevous grin that he would often share while recounting some humorous event from his past. Laughter came easy, no doubt an antidote to his and the whole worlds struggle to see the light when there was little to be had. I miss him greatly and I'll never forget our time together.
One more thing though. I still need to return his wrist watch. He gave it to me to replace the battery. I have yet to do that and I can't help but think that Jack is laughing at me now, as I try and figure out whether or not to bring that watch back to life. I'm really not in a position to speak for everyone, but I will anyway. We poor mortals are such a sad lot.
All Marjorie and I can offer is our heartfelt condolences to Marion and her children. Jack knew I was a non-believer but he's got me believing in something. I feel like I owe him something. I'm just not sure what it is (and no, I'm not talking about the watch); but that's ok. For me, life will just remain a mystery. Thanks Jack, for everything, said and unsaid.
Proudly Serving the Communities of Napanee, Kingston, Deseronto, Selby, Roblin, Tamworth, Newburgh, Camden East, Yarker, Moscow, Odessa, Bath, Amherstview, Collins Bay, Sydenham, Harrowsmith, Wilton, Marlbank, Wolfe Island, Amherst Island, Conway, Adolphustown, Verona, Seeley's Bay, Lansdowne, Parham, Inverary, Elginburg, Enterprise, Centreville.
980 Collins Bay Rd
Kingston, ON K7M 5H2
Email: wartmanfuneralhome@sympatico.ca
448 Camden Rd
Napanee, ON K7R 1G1
Admin | Obittree | Privacy Policy | Terms of Use | Sitemap | Obituary Directory |Powered by FrontRunner Professional & TA

redpajama_set_name: RedPajamaCommonCrawl


Marijuana remains federally illegal in 2018, but many states have released restrictions on the drug because it has proven to be useful by all. Although it has just recently become legal in many states, i.e. california, marijuana (aka the magical herb) has magical effects that have been realized for a long, long time. Before the American government began to regulate pot, the only individuals that handled and distributed the herb were 'Herbal Masters.' The story of the magical herb dates back to the middle ages in Europe.
In the midst of the rapid spread of Bubonic Plague in Europe, there lived various Herbal Masters. The end years of the Middle Ages were dark because of The Black Death, but the heroic Herbal Masters shed light upon the death stricken regions that fell victim to its wrath. In the historic journals of a medical scientist, Dr. John D. Reposado, a doctor that kept a detailed journal, wrote about men and women that delivered medical attention and healing powers. Herbal Masters, according to Dr. John D. Reposados observations, gave either a wiff-and-a-puff or a corn bread edible to victims. These wiff-and-puffs or edibles contained the magical herb and cured over 10,000 victims over the span of 80 years that the plague existed.
The true story of marijuana's history has been concealed and dusted over by time, but the magical effects continue to heal and save lives. After so many benefits reaped by so many people, America founded April 20th to be National Marijuana Appreciation day, in 1962. Since then, the people of America have fought for the right to wiff-and-puff or eat the magic herb as they please!


This order is made under section 2(2) of the Courts Matters Act 2018 on the advice and with the consent of the Executive Council.
This order is the Courts Matters Act 2018 (Amendments to Courts Security Act 1999) Commencement Order 2019.
Sections 7, 10, and 12 to 24 of the Courts Matters Act 2018 come into force on 8 April 2019.
Part 1 of the Courts Matters Act 2018 (Part 1) amends the Courts Security Act 1999. The amendments expand court security officers' powers to enable them to deal more effectively with low-level offending and disruptive behaviour in courts and tribunals. Some of Part 1 came into force on 14 November 2018. This order brings the rest of Part 1 into force on 8 April 2019.


Paul Krugman says, "Focus, people! Focus!" Let's hope that Hillary learned her lesson from Bill regarding health care and that John Edwards' message gets more attention.
NPR is live blogging the SOTU tonight?! Damn! Is liveblogging still cool?
Paraphrasing Emmanuel on Morning Edition: "The rift between Obama and Clinton isn't like JFK or LBJ. It's not like when Ted Kennedy tried to shiv Jimmy Carter in 1980. Heck, it's not even like George Bush vs John McCain in 2000. No, Hillary vs Obama is just a slight misunderstanding brought on by her loudmouth husband who we want to STFU. I'm not endorsing. I'm hiding under my desk." In other words, typical Rahm.
Ahhh, but does NPR have a drinking game to go with their SOTU liveblogging? Betcha they don't. Add your words, phrases and # of prescribed gulps in the comments.
SusanG is channeling the chaos? Ayayay! Must be pretty tumultuous behind the scenes.
Matt Stoller issues a warning. I have to agree with him. There is something very spooky here with so many people who are normally clear thinkers start jumping aboard the Obama bandwagon. The synergy of the media, some influential bloggers and others is directed primarily at taking down the Clintons not necessarily at putting Obama in the WH. I still think there are a lot of Republican operatives trolling the web, dominating comment threads at TPM and DailyKos and manipulating the discourse to make it look like Obama, not Clinton is the inevitable candidate. And when they finally have Clinton out of the way, Obama will be a sitting duck because he is a stump speech, an intelligent man and not much else. God help us.


What Channel is USA on DIRECTV?
What Channel is NESN on DIRECTV?
What Channel is NBC Sports Network on DIRECTV?
What Channel is NBA TV on DIRECTV?
What Channel is Nat Geo Wild on DIRECTV?
What Channel is National Geographic on DIRECTV?
What Channel is NASA TV on DIRECTV?
What Channel is N3D on DIRECTV?


Fans of Rockhouse Pizza in Henderson, eat your fill at the Wolf's Tavern building by this coming Saturday - -or on this Saturday if you want a real party. After the 28th, the business will be closing for a short time as they move into their modern new digs on the Henderson riverfront.
Christy Osborn is the owner and operator, along with co-owner and father Lindsey Embry and husband David Osborn.
Over the ensuing five years, however, the family decided the best way to run a business was to own the building, and when the former Ky. Unemployment Office building came up for sale on the beautiful Henderson Riverfront, they decided to make a change.
"We think the riverfront is the best area of Henderson," she said.
The new Rockhouse will hopefully be open before the end of August, but nothing's set in stone. As the new building was office space before, all the new code requirements for a restaurant kitchen applied, so it has taken some time to get the building ready to go.
"It was more of an undertaking than we thought it would be," said Osborn.
On Saturday, Rockhouse at Wolf's will open for the last time at 4 p.m., with live music starting at 6, happy hour specials and all the regular daily specials all evening. The idea is to use as much inventory as possible, so eat up, because when it's gone, it's gone. Until late August anyway.
Rockhouse at Wolf's is located at 31 N Green St in Henderson, Ky.
Monday – Thursday 10 a.m.-9 p.m.


The Fluco Beat is the official news site produced by students of Fluvanna County High School, 1918 Thomas Jefferson Parkway, Palmyra, VA 22963, (434-589-3666, ext. 3037). The purpose of Fluco Beat is to accurately inform Fluvanna County High School students and staff, as well as the county of Fluvanna, about the current events and inner workings of Fluvanna County School and the surrounding community.
The Fluco Beat recognizes the First Amendment guarantee of freedom of the press, and abides by the Tinker standard. Opinions published in the Fluco Beat do not necessarily reflect the views of the entire staff, advisor, administration, or entire student body.
The FCHS Editorial staff reserves the right to refuse to publish any photo, article, caption, or form of communication which violates this policy.
The Fluco Beat will never post rumors without facts to prove or disprove them.
Writers will directly quote a source and if removing a part they will use ellipses (…) in place.
The Fluco Beat will never report any inaccurate facts or false information about a person.
Always make sure that every image posted under the The Fluco Beat name is high quality.
The Fluco Beat will always obtain photos and videos by legal means.
The Fluco Beat will always endeavor to give full credit to the creator of an image or video.
The Fluco Beat will take down any posts that violate copyright laws.
The Fluco Beat will endeavor to never slander or libel others.
The Fluco Beat will endeavor to never post anything biased or offensive in nature.
Writers will never print a quote without asking permission from the quoted person.
The Fluco Beat will only take down posts if the person requesting it has an appropriate and thoughtful rationale as determined by the editorial staff.
The Fluco Beat staff members will endeavor to write newsworthy and relevant stories to inform the public of important events in a timely manner.
The Fluco Beat will only write posts that have purpose and meaning to Fluvanna County citizens.
The Fluco Beat recognizes that every post can and may be seen by people with different backgrounds, ethnicities, genders and religions worldwide.
The Fluco Beat will never post images, stories, or social media posts that are inappropriate in content.
The Fluco Beat will endeavor to never be biased towards/against specific backgrounds, genders, ethnicities, or religions.


text:
Deindustrialization 4, Other Europe
See more stories of other European countries deindustrializing, from ample supply and cheap energy to blackout preparations and expensive energy. More governments and UN climate and energy alarmism and interventions for decades led to this.
1. Europe is heading into a depression
Into the darkness, again.
Tuomas Malinen Aug 20 2022
https://mtmalinen.substack.com/p/europe-is-heading-into-a-depression
2. Azoty Drops as Polish Fertilizer Output Halts on Gas Prices
* Shares of country's leading chemical maker drop as much as 10%
* Government says fertilizer stocks sufficient for sowing season
Konrad Krasuski August 23, 2022
https://www.bloomberg.com/news/articles/2022-08-23/azoty-of-poland-halts-fertilizer-production-on-record-gas-prices#xj4y7vzkg
3. EU Energy Crisis Forces Major Fertilizer Producer To Halt Production
Irina Slav - Aug 23, 2022
https://oilprice.com/Latest-Energy-News/World-News/EU-Energy-Crisis-Forces-Major-Fertilizer-Producer-To-Halt-Production.html
4. Why the Energy Transition Will Fail
New report highlights the staggering cost of green 'delusions.'
James Freeman Aug. 26, 2022
https://www.wsj.com/articles/why-the-energy-transition-will-fail-11661547051
Even if you're never hit by a 7-ton blade falling from the night sky, alternative energy will fail you. Regardless of facts or feelings about the climate, there are reasons why wind and solar power are not replacing fossil fuels. Wind and solar are also no substitute for nuclear power.
5. Europe's widening fertilizer crisis threatens food supplies
Bloomberg - 26 Aug 2022
https://www.msn.com/en-za/news/other/europes-widening-fertilizer-crisis-threatens-food-supplies/ar-AA116fZO
6. The Crucial Cause Behind Energy Crisis is 'Green Fanaticism,' Says Czech President
Prague Morning AUGUST 26, 2022
https://www.praguemorning.cz/the-crucial-cause-behind-energy-crisis-is-green-fanaticism-says-czech-president/
7. Two more fertilizer plants in Europe shut down due to high gas prices – no energy means no food
Ethan Huff, August 26, 2022
https://naturalnews.com/2022-08-26-fertilizer-plants-europe-close-high-gas-prices.html
8. How West's "Green Agenda" Incentivized and Empowered Putin's Attack on Ukraine
Jaroslaw Martyniuk. Aug. 28, 2022
https://www.kyivpost.com/article/opinion/op-ed/how-wests-green-agenda-incentivized-and-empowered-putins-attack-on-ukraine.html
9. Czechs have most expensive electricity in Europe despite exporting huge amounts of power abroad
Czechs are paying massive energy bills even as the country remains one of the largest energy exporters in the world
LUKÁŠ KOVANDA August 29, 2022
https://rmx.news/czech-republic/czechs-have-most-expensive-electricity-in-europe-despite-exporting-huge-amounts-of-power-abroad/
10. One of the world's largest fertilizer producers, Yara (in Norway), slashes production due to skyrocketing natural gas prices
Ethan Huff August 29, 2022
https://naturalnews.com/2022-08-29-fertilizer-producer-yara-slashes-production-natural-gas.html
11. 'I never thought I'd see this again' – People in Poland sleeping in cars while waiting in line to buy coal for winter
A long line formed outside the Bogdanka Coal Mine to buy bargain price coal, with some people waiting up to a week to make their purchase
WPROST.PL August 29, 2022
https://rmx.news/poland/i-never-thought-id-see-this-again-people-in-poland-sleeping-in-cars-while-waiting-in-line-to-buy-coal-for-winter/
12. Europe's Alarming New Trend: Rapid De-Industrialization
Michael Bastasch / September 01, 2022
https://www.dailysignal.com/2022/09/01/europes-industrial-might-is-collapsing-while-its-elites-deny-reality/
13. We are all living in Greta's world now
This winter's energy crisis will give us a foretaste of what a world without cheap energy looks like
ROSS CLARK 2 September 2022
https://www.telegraph.co.uk/news/2022/09/02/living-gretas-world-now/
14. Darker and Colder: Europeans Warned of 'Unprecedented' Power Failures This Winter
"Production of electricity cannot keep up with demand."
Paul Joseph Watson 2 September, 2022
https://www.infowars.com/posts/darker-and-colder-europeans-warned-of-unprecedented-power-failures-this-winter/
15. "Worst Has Yet To Come": Civil Unrest Set To Surge Worldwide As Socioeconomic Pressure Builds, Report Warns
TYLER DURDEN SATURDAY, SEP 03, 2022
https://www.zerohedge.com/geopolitical/worst-has-yet-come-civil-unrest-set-surge-socioeconomic-pressure-builds-report-warns
16. Tens of thousands protest in Prague against Czech government, EU and NATO
https://www.reuters.com/world/europe/tens-thousands-protest-prague-against-czech-government-eu-nato-2022-09-03/
17. "Europe On The Brink:" 70,000 Czech Protesters Flood Prague Over Energy Crisis
https://www.zerohedge.com/geopolitical/europe-brink-70000-czech-protesters-flood-prague-over-energy-crisis
18. Europe Looks Set for Energy Rationing After Russian Gas Cut
* Germany has built up storage, but it may not be enough
* Europe's ability to get through winter depends on the weather
* European Gas Prices to Stay High Without Policy Intervention: Energy Aspects
Vanessa Dezem, Rachel Morison, and Ewa Krukowska. September 4, 2022
https://www.bloomberg.com/news/articles/2022-09-04/europe-looks-set-for-energy-rationing-after-russian-cut#xj4y7vzkg
19. Why Europe's Dependence On U.S. LNG Is Risky
Alex Kimani - Sep 05, 2022
https://oilprice.com/Energy/Natural-Gas/Why-Europes-Dependence-On-US-LNG-Is-Risky.html
20. DARK TIMES: Industry and infrastructure collapsing by the day across Europe and the USA
Mike Adams September 05, 2022
https://www.naturalnews.com/2022-09-05-industry-and-infrastructure-collapsing-across-europe-and-usa.html
21. Energy crisis: 30 public pools in France suddenly close after energy bills jump from €15 million to €100 million
The company's energy bill is a sign of what may come for business and public services across Europe
JOHN CODY September 06, 2022
https://rmx.news/article/energy-crisis-30-public-pools-in-france-suddenly-close-after-energy-bills-jump-from-e15-million-to-e100-million/
22. "Lehman Event" Looms For Europe As Energy Companies Face $1.5T In Margin Calls
Josh Owens - Sep 06, 2022
https://oilprice.com/Energy/Energy-General/European-Energy-Companies-Face-15-Trillion-In-Margin-Calls.html
23. Europe's Nightmare Scenario Comes True: Energy Bills To Rise By €2 Trillion, Will Reach 20% Of Disposable Income
TYLER DURDEN SEP 07, 2022
https://www.zerohedge.com/commodities/europes-nightmare-scenario-comes-true-energy-bills-rise-eu2-trillion-will-reach-20
24. Europe Is Buying All The Russian Oil It Can Before Banning It
By Irina Slav - Sep 07, 2022
https://oilprice.com/Energy/Energy-General/Europe-Is-Buying-All-The-Russian-Oil-It-Can-Before-Banning-It.html
25. Swiss citizens who overheat their homes this winter could face hefty fines and 3 years in jail
Radical new legislative proposals in the country could see citizens reporting their neighbors for overheating their homes
THOMAS BROOKE September 07, 2022
https://rmx.news/switzerland/swiss-citizens-who-overheat-their-homes-this-winter-could-face-hefty-fines-and-3-years-in-jail/
26. This Winter, Europe Plunges Into "The New Dark Ages"
by Michael September 7, 2022
http://theeconomiccollapseblog.com/this-winter-europe-plunges-into-the-new-dark-ages/
27. FORCE MAJEURE: Massive global shutdowns are now under way for METALS SMELTING operations covering iron, copper, nickel, aluminum, zinc and STEEL
https://www.naturalnews.com/2022-09-07-force-majeure-massive-global-shutdowns-are-now-under-way-for-metals-smelting-operations.html
28. Putin warns the West will 'keep freezing' if energy price caps are imposed – and Russia will stop all gas and oil supplies
* Putin said Western attempts to cap prices for Russian oil and gas were 'stupid'
* The Russian leader, 69, warned EU leaders that Russia would walk away from supply contract if EU imposed price caps on the country's exports of gas and oil
* If gas and energy supplies stopped, there would be devastating consequences
RACHAEL BUNYAN 7 September 2022
https://www.dailymail.co.uk/news/article-11188715/Putin-says-Russia-stop-oil-gas-supplies-price-caps-imposed.html
29. Putin Responds to Truss / EU Energy Price Cap: "Keep Freezing"
Eric Worrall September 7, 2022
https://wattsupwiththat.com/2022/09/07/putin-responds-to-truss-eu-energy-price-cap-keep-freezing/
30. Energy Transition a 'Dangerous Delusion': Report
By Nathan Worcester September 8, 2022
https://www.theepochtimes.com/energy-transition-a-dangerous-delusion-report_4717765.html
Deindustrialization 1, Europe's sagging energy supply, July 26, 2022
Deindustrialization 2, Germany, June-July 2022 reports, September 4, 2022
Deindustrialization 3, United Kingdom, August 2022 reports, September 6, 2022.
BWorld 561, Power demonopolization, privatization,...
Conservatives and rightists fighting back in Europe
Agri Econ 38, Fermin Adriano article on "Full blow...
BWorld 560, PEB Singapore, the PPP Center, transpo...
A Sin law by the government
Free Trade 71, Anti-Illicit Trade Conf in Manila, ...
BWorld 559, Build-build-build, extended welfare, v...
Covid 76, Covid vax effects on fertility
Deindustrialization 3, United Kingdom, August 2022...
BWorld 558, ABS-TV5 Partnership, SMC rate hike pet...
Covid 75, Vax effects -- myocarditis, thrombosis, ...
BWorld 557, 10 things to watch in energy, the budg...
Deindustrialization 2, Germany, June-July 2022 rep...
BWorld 556, Growth recovery, declining births, and...
Covid 74, Vax spending in the Philippines


Alex Gardner is a research scientist at NASA's Jet Propulsion Laboratory. He earned a degree in Engineering from the University of Saskatchewan, a doctorate in Earth Sciences from the University of Alberta and was a Natural Sciences and Engineering Research Council of Canada research fellow in the Department of Atmospheric, Oceanic, and Space Sciences at the University of Michigan. Alex studies Earth's cryosphere (frozen Earth) with a particular focus on glaciers and their impacts on sea level rise and water resources. He is interested in how glaciers respond to natural and human-induced changes in atmosphere and ocean as well as how changes in the reflectivity of snow and ice modify Earth's climate. He has published numerous high-impact scientific papers on the topic, is a contributing author to the United Nations' Intergovernmental Panel on Climate Change's 5th assessment report, and is a member of NASA's Sea Level Change and ICESat-2 Science Definition Teams.


text:
Schönbrunn Zoo (Tiergarten Schönbrunn)
Maxingstraße 13b, 1130 Wien
Very Good from 3 reviews
The oldest zoo in the world, over 250 years old, has developed into one of the most modern and - as many animal lovers say - the most beautiful zoo in the world over the past few decades. The zoo has already been voted the best zoo in Europe three times. Look forward to 700 different animal species, from the Amur leopard to the two-toed sloth! The most popular residents of the zoo also include the giant pandas, koalas, polar bears, elephants, and lions - as well as rare and endangered Austrian animal species in the Tirolerho
When you enter the Schönbrunn Zoo, you can look forward to a unique mixture of imperial ambiance and modern zoo
The zoo has already been voted the best zoo in Europe three times
The zoo internationally famous and recognized and valued worldwide with over 730 animal species and almost 9000 individuals.
Schönbrunn Zoo offers the unique opportunity to gain an intimate insight into the work of the animal keepers. There are feeding dates where the colorful animal world can be seen in action.
For more info :
Easy way to discover the city
Time Travel Vienna uses 5D Cinema
House of the Sea – Aqua Terra Zoo
Prater ( Amusement Park)


text:
A fall to the lottery didn't rush the Spurs' process, whatever that process is
Neither a spate of rumors nor the pall of mediocrity forced the Spurs' hand on draft night. Instead they stood pat in each round and made sound value moves that were perfectly on brand.
By BrunoPassos@bouncepassos Nov 20, 2020, 9:24am CST
Share All sharing options for: A fall to the lottery didn't rush the Spurs' process, whatever that process is
Photo by Nathaniel S. Butler/NBAE via Getty Images
If Brian Wright had spent all day frantically working the phones and trying to finesse last-minute deals that failed to materialize, he didn't look like it. At least not when he stepped into frame for the team's post-draft Zoom call as the clock approached midnight on Wednesday.
Instead, Wright (who was promoted to Spurs GM last summer) radiated a calm excitement as he fielded questions about the two picks the team made at their scheduled slots of 11 and 41: FSU's Devin Vassell and Duke's Tre Jones, respectively.
"Both very high character guys from great programs that have had a lot of success, won at every level. Workers, competitors, just good, solid basketball players," he said. "We think we added to our team on the court tonight, but in the locker room and in the community, as well. Just two really phenomenal young human beings."
In the weeks leading up to the NBA Draft, there was palpable buzz around what San Antonio might do, and how it may drastically alter their future or reimagine their present. Some of that may still take place — Wright spoke to impending free agency and a "roadmap" the team was confident it may realize — but nothing, including a rare lottery trip, forced their hand on Wednesday.
"With every draft there's always a bunch of things on the board," Wright said. "Whether it's to move up, move-backs, it's a chance for you to get creative and see what's there. Outside of just today, we just tried to understand the whole board, the entire draft, and as you get further and further you're just erasing and seeing what else comes in. We always thought we would pick in this draft. Where we would pick was always the question and ultimately when Devin was there we knew we had a good player at 11 and to stay put and draft there."
Free agency opens on Friday, November 20th, clearing the way for Wright and the Spurs to try and realize that plan. While we don't know whether that means moving DeMar DeRozan, LaMarcus Aldridge or Patty Mills, or preparing to match any offer for restricted free agent Jakob Poeltl, we do know which rookies will be in the fold.
"We're not able to do any negotiating yet," Wright said when asked what work they had left to do this offseason. "So everything is still a work in progress. I think we have a roadmap of what we hope to get done, and we'll see in the next few days if we can get that done"
There were two qualities that both Vassell and Jones shared, beyond being rising sophomores from the ACC: defensive accolades and reputations as high-character guys. Wright was quick to note that the two came back spotless in their background checks and, for whatever it's worth, both came across well in their draft-night media calls. Last season's ACC Defensive Player of the Year, Jones took a clear pride in his nightly effort on that end of the floor while Vassell was probably at his most enthusiastic when asked about his former teammate, Patrick Williams, who was taken with the 4th pick by the Bulls.
Of Vassell, Wright said: "He's someone that we've been evaluating a long time, a couple of years at Florida State... [He] impacts the game in so many different ways. [He has the] ability to create, make plays, score at all three levels, and obviously shoot the ball, as well."
A long and lean 6'7", Vassell projects as a versatile guard-wing with legitimate two-way potential. It's a profile that sounds a little familiar to fans that have watched team select a handful of players in recent years that exist somewhere in the growing chasm between point guard and power forward. And there were options at either of those positions should the Spurs have let need outweigh their scouting work and desire to go with who they saw as the best player available.
That approach, to be clear, does carry some risk. While Wright would later talk about how little that traditional positional designations mean today, tangible skills still do, and the reality is that Vassell adds to a stockpile of young perimeter players who can ostensibly guard 1 through 3 but who will give up size to bigger wings while neither serving as the engine or initiator of an offense.
"Speed, length, shooting ability all hold value, so we'll continue to look for those things," said Wright when asked if Vassell affirms the type of player the team has sought out. "I think the league has really changed where you look at guys as one-position players—you're either a 1, 2, 3, 4 or a 5. I think what you see now is you've got guards, you've got wings and you've got bigs, and depending on who they're playing with you diversify. And you want guys who are versatile, who can play multiple positions. I think with Devin for sure he can play across multiple positions. As he gets stronger, he'll be able to do that even more."
There's a certain madness to any method when it comes to building a winner. You have to gamble and step boldly in whatever direction you're headed. Even not gambling is a gamble. Whether Wright is speaking about the nuances of the physical development he expects of Vassell or bigger-picture sea changes with the league, you get glimpses of how he wants to bring the Spurs back to the top. Like Wright, it's a still-forming vision that seems to bridge the same values we're used to with sensibilities that befit the NBA in 2020. If draft night was any indication, we may not get the full picture anytime soon but the Spurs have never been one to skip steps.


text:
Za druge pomene glej Bajan (razločitev).

Bajan, Bujan ali Najan (kazaško Баян хан, Bajan han) je bil eden od najbolj slavnih kanov Bele horde, ki je vladal od leta 1302 do 1309, * ni znano, † 1309

Mongolska beseda bajan pomeni bogat, beseda bujan pa dobro delo ali dejanje (v veri ali verovanju).

V Modri in Beli hordi, ki sta tvorili Zlato hordo, so vladali Mongoli, ki so v obeh hordah tvorili tudi višji družbeni sloj prebivalstva. Podložniki so bili večinoma Kazahi. Ko je bil za kana Bele horde izvoljen Bajan, so se mu sorodniki uprli. Sorodnike pod vodstvom bratranca Kobluka sta podpirala kana Čagatajskega kanata Kajdu in Duva. Bajan se je večkrat spopadel s Koblekom in Kajdujem in zaprosil za pomoč Tokto, kana Zlate in Bele horde. Tokta, jezen zaradi stanja v Beli hordi, ga je opozoril, naj ne podpira upornikov.

Bajan je poskušal skleniti zavezništvo tudi s Timur kanom iz Dinastije Juan in suverenom Mongolskega cesarstva proti Čagatajskemu kanatu in Kajduju. Zavezništvo je bilo zaradi velike razdalje med državama neučinkovito. Bajan je nazadnje porazil svoje sovražnike in vladal v Beli hordi do leta 1309. V njegovi vojski so služili Čerkezi, Rusi, Ogri in verjetno Baškirci.

Howorth je okoli leta 1880 pisal, da je bil Bajanov sedež v Gazniju ali Bamijanu. Pravi tudi, da je Berke posodil Huleguju nekaj svojih vojaških oddelkov. Bajan in Hulegu naj bi zatem odšla nekam proti vzhodu in v sedanjem Afganistanu ustanovila novo kneževino, podložno Zlati hordi.

Sklici

Neznano leto rojstva
Umrli leta 1309
Mongolski kani
Vladarji v 14. stoletju


text:
Find your nearest Neptune stockist
Brochures & User Manuals
FAQ & Troubleshooting
Products, Equipment and Chemicals
Info and Tips
Pool Pro
What is Solar Heating?
Your Pool Pro Professional can help you if you are thinking of having Solar Heating Installed. Speak to them first.
Installing solar pool heating can increase the use of your pool by up to four months. By using heating energy from the sun, the cost to heat a pool in this way is very economical. Solar heated pools are best used in conjunction with a pool blanket which assists in retaining the heat.
The type of solar system may vary; however the basic principle remains the same. Pool water is circulated through a series of tubes (the collector) usually mounted on the roof, where heat is absorbed and the heated water returns to the pool. The collector can be of either EPDM Rubber or PVC/TPR material and is usually supplied in multiple tube "strips". The amount of heat absorbed and the ultimate increase in pool water temperature depends on several factors which should be considered when deciding on a solar heating system for your pool. They are:
Size or area of collector and number of tubes per sq.m (square metre).Naturally the major influence on the effectiveness of any solar system is its exposure to the sun, therefore, the location or positioning of the collector should be installed on the northern side of the roof.Control system.
SIZE OF AREA
The amount of collector used in your solar system will have a major influence on the effectiveness of the system. The size of the collector is usually expressed in square metres, and as a general rule, directly relates to the surface area of the pool.
Larger systems will be needed where a higher than average water temperature, or an extended swimming season is desired.
It is imperative that your solar system is installed by a reputable and professional Solar Company.
Your Pool Pro Professional can advise you on any further information you require.
What is Total Alkalinity?
What are my legal obligations as a pool owner?
How do I test my water at home and what does my Pool Pro Professional need to know about my pool?
Privacy Policy Website Disclaimer Terms and Conditions
© Copyright 2019 by Neptune for swimming pools ™ www.neptunepumps.com.au


text:
Prakash Javadekar
Developed nations should encourage renewable energy programmes: India
Environment Minister Prakash Javadekar said he will use the occasion to raise the "unfortunate" case of the US going to the WTO on the issue.PTI | April 22, 2016, 12:56 IST
Prakash Javadekar (File Photo)
NEW YORK: India has said that developed nations should encourage renewable energy programmes and not "put a spoke into it" as it termed "unfortunate" a recent WTO ruling against its power purchase agreements with solar firms.
Environment Minister Prakash Javadekar, who is here to sign the historic Paris climate change agreement at the United Nations today, said he will use the occasion to raise the "unfortunate" case of the US going to the WTO on the issue.
"I will definitely raise (this issue) in my speech. This is unfortunate, not the ruling, even America going to WTO, that is unfortunate," he told PTI here.
Javadekar added that India has launched the world's largest renewable program and reserved a "very small" part of it for Indian manufacturers.
Yet, if that is being "challenged without seeing the things in proper context and perspective" and on technical grounds, it is discouraging for the developing nations, he said.
Such an action "discourages. This is not multilateralism. We must encourage" nations undertaking clean energy programs.
"India generating 175 GW of renewable energy is the biggest program. One should not put a spoke into it. You are lecturing one thing and practicing the exact opposite," he said.
He said while it is up to the Commerce Ministry to take a call on how to proceed with the matter, "such things should not happen."
Ruling against India, WTO had recently said the government's power purchase agreements with solar firms were "inconsistent" with international norms -- a matter in which the US had filed a complaint before the global trade body alleging discrimination against American firms.
The US had dragged India to WTO on this issue in 2014, alleging the clause relating to Domestic Content Requirement (DCR) in the country's solar power mission were discriminatory in nature and "nullified" the benefits accruing to American solar power developers.
Javadekar will join heads of state, foreign ministers and other representatives from more than 165 countries who will sign the historic climate change agreement reached in Paris last December at the signature ceremony hosted by UN Secretary-General Ban Ki-moon.
The large number of countries will set a record for the most countries to sign an international agreement on one day, previously set in 1982, when 119 countries signed the Law of the Sea Convention.
Javadekar expressed hope that "collective wisdom" will ultimately prevail and both developed and developing nations will do their part to address the issue of climate change.
"India has come to New York for signing the Paris agreement with full confidence that ultimately the collective wisdom will prevail and all countries - developed and developing - will do their bit," Javadekar said.
Noting that the issue of climate fund continues to remain a concern, he said developed countries have to mobilize USD 100 billion "sooner than later" and they must also take enhanced targets for 2016-2020, which is the second commitment period of the Kyoto Protocol.
"Their actions should be declared immediately. That will give more confidence to the developing world that the developed world is also walking the talk," he said.
Javadekar underscored that India is "leading by example" as he highlighted that the country has put a six dollar cess per tonne on coal, besides already taking another 26 initiatives post the Paris pact to address climate change.
"The cess is the highest tax put on coal. It is a solid action taken against carbon emission," he said, adding that nations have applauded India's decision of taxing its coal.
"India has showcased its leadership and if developed world follows this example" and puts a similar cess on their coal production, "they will easily mobilize" the USD 100 billion required by 2020 for the climate fund, he said.
"We have led by example, taxed our coal. The developed nations should also do that. They have to show their commitment otherwise whole Paris agreement will fall apart," he said.
He said every climate action has a "cost" and developed nations are asking the developing world to pay that cost.
"The developed world has caused the climate change of today because of their 100 years of relentless carbon emissions. We are much cleaner at our development stages as compared to those of the developed world," he said, adding the developed world "behaved irresponsibly" and the developing nations are suffering.
Outlining the measures taken by the government to cut carbon emissions, Javadekar said India has incentivized and given subsidy to electrical and hybrid vehicles and enacted an 'e-rickshaw bill'.
The government has also taxed petroleum and diesel vehicles, aiming to "disincentivize" polluting vehicles.
Almost 40 per cent of India's energy mix by 2030 will be from non-fossil fuel.
"America will not achieve such a mix through their INDCs. So developed nations must take up more targets," he said.
Tags : Renewable, united nations, Prakash Javadekar, international, US


text:
5 Ways To Become A More Human Leader
Hiring & Career Tips January 25, 2019February 15, 2019 Ilana Greenberg
Blogpost by Bejan Douraghy. He is the founder of Artisan Talent, an award-winning staffing agency matching digital, creative, and marketing talent with success since 1988. Artisan places talent nationwide and has offices in Chicago, New York City, Indianapolis, and Denver.
I'm committed to helping leaders learn how to motivate their teams through compassion, kindness, and relationship building. Through the years, I've drawn from my own education, colleagues in groups like EO and Vistage, and many different experiences and instincts to create my approach to leadership.
Here's a list of actions that have helped me become a more human leader — I hope they inspire you along your own journey on becoming a better team leader.
Create Team Rituals
At my company, I love to start the day by going around with a cup of coffee and saying hello to everyone. I look forward to this little morning ritual because it sets the tone for the day. Plus, it's fascinating to see how my behavior has sparked others to make stronger connections with the people around them. It never hurts to say hello to your coworkers before you dive into that inbox or task list. Sometimes, it's the simple things that can bring a team closer together.
If you're looking to create a team bond, there's no right or wrong way to start. It could be playing an icebreaker game at the end of your daily huddle, bringing in lunch every other Friday, or taking votes to see who gets the oversized trophy that month. It doesn't have to cost a lot. Just make it special and unique to your team.
Really Get to Really Know Your Team
I believe the human experience drives business. Building personal connections might sound like a no-brainer, but it's often overlooked in the day-to-day. When it comes to my team, I like to visualize an "employee iceberg" — work-related stuff is just the tip.
Aim to get to know the rest of the iceberg, which could include your employees' personal aspirations and dreams, family goals, or even problems they are experiencing. How do you get people to open up? Start by creating an environment where people feel comfortable dropping by each other's desks. Create an "open-door policy" and be prepared to offer solutions, advice, or just an ear for people to talk to. I've found that getting to know your employees on a deeper level usually leads to more trust, respect, and ultimately, more collaboration.
Meet Face-to-Face
I will always feel passionate about meeting in person because, to me, there's no better way to build a strong connection.
According to the Harvard Business Review, a face-to-face request is 34 times more successful than an email, and it's mainly due to the benefits of human contact. As a leader, it's up to you to initiate this type of connection wherever you can. If your team is remote, opt for a video conference over a phone call to help bring the meeting to life.
After all, people may forget what you say, but they'll never forget how they felt when they met with you. Eye contact, facial expressions, and body language work together to develop first impressions and a lasting rapport. Without those indicators, things can be misunderstood or taken out of context. This is something that's too often replaced by calls and emails.
Pitch In
With more companies adopting agile methodologies, today's mindset is all about pitching in wherever, whenever, and however to keep things moving. That's why it's especially important for leaders to be able to wear many hats. As someone who started a national staffing company from the ground up, I've done it all — from stepping into sales calls to troubleshooting the printer.
Working alongside your team shows them that you're all in it together. — "Ivory tower syndrome" is a real thing, and it happens when leaders are isolated from the work their team is doing. Don't miss any opportunity to break free from your office and get involved in the day-to-day.
Be Decisive
A major part of being a leader is making decisions. Sometimes they need to happen fast and will have lasting effects on many aspects of your business. Think this doesn't matter for your bottom line? According to Forbes, up to 95% of an organization's financial performance is directly tied to decision effectiveness. Don't let this make you too anxious though. Remember that you won't always have the right answers, but it's important to make educated decisions and stick to them. When you go back and forth, you're actually making the decision to do nothing, and that doesn't help anything.
A trick of the trade I love is to ask myself:
What will it be like 10 minutes from now
What will it feel like 10 years from now?
These questions will help you gain short-term and long-term perspective on the issue at hand.
Bonus Tip: Celebrate Everything
It's easy to focus on big-picture achievements, but what about the day-to-day wins that lead up to them? I strongly believe in taking the time to celebrate the little wins. Recognize people and their milestones along the way. Whether it's a promotion, birthday, or completed project, there's always a reason to celebrate if you're willing to look for the positives. And it doesn't have to cost anything. It could be a round of applause, a silly animated GIF, or a feature on the company blog. Even the smallest gestures can be big motivators. Don't underestimate the power of remaining positive and recognizing your team members.
Just remember, when it comes to unlocking the power of human leadership, the possibilities are endless — and they're always evolving.
artisan talent, bejan douraghy, career tips, human experience, team leader
About Ilana Greenberg
View all posts by Ilana Greenberg →
The GDUSA Podcast #3: Megan Flood of Marine Lane
The GDUSA Podcast #4: Brett Traylor of Thinkso


When you see others in need, help them. You never know, it could be you in their place. When you see the facial expression of happiness in being helped without expecting it, brings joy. It is the gift of giving which brings so much power to your being.