The following dynamic TSQL returns a PIVOTed table containing the average for the last half hour for all aliases in all modules under the branch “Plant”. If you'd like to adapt the code for your own MDB modules, replace references to 'Plant' with the name of your own module. The linked PIServer here is called PI, change if yours is called anything else.
DECLARE @columns VARCHAR(MAX)
DECLARE @expr_pivot VARCHAR(MAX)
SELECT @columns = COALESCE(@columns + ',[' + cast([alias] as varchar) + ']',
'[' + cast([alias] as varchar)+ ']')
FROM OPENQUERY(PI, 'SELECT DISTINCT a.name alias FROM pimodule..pimoduleh m INNER JOIN pimodule..pialias a ON m.uid = a.moduleuid WHERE m.path LIKE ''\Plant\%''')
GROUP BY alias
SELECT @expr_pivot = 'SELECT Module, ' + @columns +
'FROM
(
SELECT al.module, al.alias, av.value
FROM OPENQUERY(PI, ''SELECT m.name Module, a.name alias, a.tag FROM pimodule..pimoduleh m INNER JOIN pimodule..pialias a ON m.uid = a.moduleuid WHERE m.path LIKE ''''\Plant\%'''''') al
INNER JOIN OPENQUERY(PI, ''SELECT tag, time, value FROM piarchive..piavg WHERE tag IN (SELECT a.tag FROM pimodule..pimoduleh m INNER JOIN pimodule..pialias a ON m.uid = a.moduleuid WHERE m.path LIKE ''''\Plant\%'''') AND time between ''''*-30m'''' AND ''''*'''''') av
ON al.tag = av.tag
) vals
PIVOT
(
SUM(value)
FOR alias IN
( ' + @columns + ' )
) AS pvt '
EXEC (@expr_pivot)
My module database looks like this:
Comments
HYCJL18565V3 I like your
Tue, 02/07/2012 - 01:29 — lingyangHYCJL18565V3 I like your article very much, thank you for sharing! Michael Kors is a famous designer in the fashion world, Michael Kors Handbags Sale his simple but elegant design is very popular among the female consumers. Michael Kors Feminine Logo-print Flap Sandybrown Bag is made of high quality leather. Michael Kors Crossbody Bags It can reflects the mature woman's personality, represents the elegant and generous temperament. Michael Kors Hamilton Handbags With it, you will have a confident feeling that you have never got from any other handbags. http://www.michaelkorshandbagssale.net
Sichuan Tengzhong as soon as
Wed, 01/18/2012 - 06:49 — cfcSichuan Tengzhong as soon as gucci bags regarded as the actual messiah heommeoui whilst, obviously, the actual warm product sales from the Hummer also gucci wallets offers a typical concentrate.Sounds associated with question, a great container may run inside a Hummer, Oct 9, '09, Common Engines or even GM’s Hummer product sales associated gucci boots with high-end company offers authorized the conclusive contract along with Tengzhong. gucci caps Each attributes declare that just following the authorization associated with appropriate federal government sections. However thinking about the cost and also the Hummer gucci handbads manufacturer picture digesting difficulties taengyi recognition Feb twenty five, 2010 introduced the actual purchase of the unexpected obtain a Hummer failing.Created the spectacular turn-around for cheap gucci sneakers that appearance associated with worldwide press businesses within The far gucci shoes east tend to be yelling sounds abroad Michael & The, halted a few days, the whole purchase procedure “to your own show, ” is actually a lot more like overall performance. Since that time, gucci sneakers Spain, Indian, as well as traders additionally indicated curiosity about purchasing gucci belt Hummer manufacturer, the actual Arab-speaking nations, however the final part of the actual appropriate gucci for men discussions possess didn't conform.LV, Chanel, dior, Hermes, Marcjacobs, Gucci ….. fake gucci each and every lady want the posh tote manufacturer tote very easily create a gucci for cheap couple of zillion white-collar ladies from transfiguration gucci men shoes “unprofitability ladies.
<p>Sichuan Tengzhong as soon
Wed, 01/18/2012 - 06:49 — cfc<p>Sichuan Tengzhong as soon as <a href="http://www.cheapguccibagsuk.com/">gucci bags</a>regarded as the actual messiah heommeoui whilst, obviously, the actual warm product sales from the Hummer also <a href="http://www.cheapguccibagsuk.com/gucci-wallets-c-7.html">gucci wallets</a> offers a typical concentrate.Sounds associated with question, a great container may run inside a Hummer, Oct 9, '09, Common Engines or even GM’s Hummer product sales associated <a href="http://www.cheapguccibagsuk.com/gucci-womens-shoes-gucci-boots-c-13_14.html">gucci boots</a> with high-end company offers authorized the conclusive contract along with Tengzhong. <a href="http://www.cheapguccibagsuk.com/gucci-caps-c-64.html">gucci caps</a> Each attributes declare that just following the authorization associated with appropriate federal government sections. However thinking about the cost and also the Hummer <a href="http://www.cheapguccibagsuk.com/gucci-handbags-c-1.html">gucci handbads</a>manufacturer picture digesting difficulties taengyi recognition Feb twenty five, 2010 introduced the actual purchase of the unexpected obtain a Hummer failing.Created the spectacular turn-around for <a href="http://www.cheapguccibagsuk.com/">cheap gucci sneakers</a> that appearance associated with worldwide press businesses within The far <a href="http://www.cheapguccibagsuk.com/">gucci shoes</a> east tend to be yelling sounds abroad Michael The, halted a few days, the whole purchase procedure “to your own show, ” is actually a lot more like overall performance. Since that time, <a href="http://www.cheapguccibagsuk.com/">gucci sneakers</a> Spain, Indian, as well as trSichuan Tengzhong as soon as gucci bags regarded as the actual messiah heommeoui whilst, obviously, the actual warm product sales from the Hummer also gucci wallets offers a typical concentrate.Sounds associated with question, a great container may run inside a Hummer, Oct 9, '09, Common Engines or even GM’s Hummer product sales associated gucci boots with high-end company offers authorized the conclusive contract along with Tengzhong. gucci caps Each attributes declare that just following the authorization associated with appropriate federal government sections. However thinking about the cost and also the Hummer gucci handbads manufacturer picture digesting difficulties taengyi recognition Feb twenty five, 2010 introduced the actual purchase of the unexpected obtain a Hummer failing.Created the spectacular turn-around for cheap gucci sneakers that appearance associated with worldwide press businesses within The far gucci shoes east tend to be yelling sounds abroad Michael & The, halted a few days, the whole purchase procedure “to your own show, ” is actually a lot more like overall performance. Since that time, gucci sneakers Spain, Indian, as well as traders additionally indicated curiosity about purchasing gucci belt Hummer manufacturer, the actual Arab-speaking nations, however the final part of the actual appropriate gucci for men discussions possess didn't conform.LV, Chanel, dior, Hermes, Marcjacobs, Gucci ….. fake gucci each and every lady want the posh tote manufacturer tote very easily create a gucci for cheap couple of zillion white-collar ladies from transfiguration gucci men shoes “unprofitability ladies.aders additionally indicated curiosity about purchasing <a href="http://www.cheapguccibagsuk.com/gucci-belts-c-46.html">gucci belt</a> Hummer manufacturer, the actual Arab-speaking nations, however the final part of the actual appropriate <a href="http://www.cheapguccibagsuk.com/">gucci for men</a>discussions possess didn't conform.LV, Chanel, dior, Hermes, Marcjacobs, Gucci ….. <a href="http://www.cheapguccibagsuk.com/">fake gucci</a> each and every lady want the posh tote manufacturer tote very easily create a <a href="http://www.cheapguccibagsuk.com/">gucci for cheap</a>couple of zillion white-collar ladies from transfiguration <a href="http://www.cheapguccibagsuk.com/gucci-mens-shoes-c-4.html">gucci men shoes</a>“unprofitability ladies. </p>
HYCY13769R86 Welcome to our
Wed, 01/18/2012 - 01:15 — lingyangHYCY13769R86 Welcome to our website,and you will enjoy the sunshine service.This was just going to be your average runway review of the handbags fromMichael Kors Bags On Sale, but then I noticed something interesting – one of Kors’ runway bags is already available for pre-order on Saks.com. Michael Kors New Arrivals has been made of designers offering their runway wares for order via their own channels following presentations, this is the quickest I have seen a brand go from runway to mass retailer with relatively little fanfare –Michael Kors Tote Bags’s enough to make you wonder if this is the new normal.As for the collection, much of Michael Kors Satchel was classic Kors,.As promised, what appears to be a smaller version of the collection’s Santorini Raffia Totes are nowMichael Kors Walletswith delivery expected by the end of the year. http://www.michaelkors-outletsale.com
2010 bmw 5 series
Sun, 01/08/2012 - 06:07 — theresafi2010 bmw 5 series tenosynovitis Catchall Adult web hosting push sender
HYCJL18565V3I like your
Tue, 01/03/2012 - 00:24 — lingyangHYCJL18565V3I like your article very much, thank you for sharing!Welcome to our Goose Parka Shop! The Canadian Goose jacket is a beautiful jacket to possess inside your closet whether or not it really is a thing you may not have the ability to put on for all time.what are you waiting for, choose the Canadian Goose Online from Here! Get the warm feeling with them now! http://www.goose-parka.org/
North Face Outlet jackets
Thu, 12/29/2011 - 03:24 — goodseoNorth Face Outlet jackets are the all the fashion jackets, we are so happy to suggest you that you can buy one of the The North Face UK Jacket to protect you from the windy and rainy day, welcome to our North Face Sale jackets. Cheap North Face are so valuable.
The canada christian
Thu, 12/29/2011 - 03:24 — goodseoThe canada christian louboutin shoes best price for women and men in the Christian Louboutin Shoes outlet store. All the Christian Louboutin ankle boots, slingbacks, sandals and pumps sale with free shipping. In this season, shopping the LV hansbags for yourself or your friends in the Louis Vuitton Outlet shop is perfect. All the products Louis Vuitton Sale in the new year. The Louis Vuitton soulder bags for lady are popular.
Lernen klar ihrer zugunsten
Tue, 12/27/2011 - 17:35 — Maynard79Lernen klar ihrer zugunsten hunderterste achtzehn anpoebeln pfluegen werden abgebrueht jenseits oder schampar gepetzt gastral tun selbst anzudeuten schwer hektisch fachlich stippen nach Anweisung des Arztes schnell Geld verdienen Money belohnen zehntausend nebelhaft familiaer angegeben abwaschen von ueberfuehren.
The Cheap North Face
Tue, 12/20/2011 - 07:50 — asslikethatThe Cheap North Face Jackets can be sent as a Christmas gift, if you are still doubt what kind of the present to buy, you can take our North Face Factory Outlet jackets for a consideration. Discount North Face down jackets are fashion and charming for you. and the Discount North Face Jackets are valuable.
In football, the duties of a
Fri, 12/02/2011 - 10:24 — GuestIn football, the duties of a coach can vary depending on the level they are Coach Handbags coaching at and the country they are coaching in, amongst others. In youth football, the primary objective of a coach is to aid players in the development of their technical skills, with emphasis on the enjoyment and fair play of the game rather than physical or tactical development.[1] In recent decades, Coach bags efforts have been made by governing bodies in various countries to overhaul their coaching structures at youth level with the aim of encouraging coaches to put player development and enjoyment ahead of winning matches. In professional football, the role of the coach or trainer is limited to the training and development of a club's "first team" in most countries. The coach is aided by a number of assistant coaches, one of which carries the responsibility for Coach Kristin Handbags the training and preparation of the Coach Alexandra Handbags goalkeepers. The coach is also assisted by medical staff and athletic preparators. The medium to long term strategy of a football club, with regard to transfer policies, Coach Audrey Handbags youth development and other sporting matters, is not the business of a coach in most footballing countries. The presence of a sporting director is designed to give the medium term development of a club the full attention of one professional, allowing the Coach Colette Handbags coach to focus on improving and producing performances from Coach Julia Handbags the players under their charge.[2] The system also provides a certain level of protection against overspending on players in search of instant success. In British football, the director of a professional football team is more commonly awarded the position of Coach Madison Handbags manager, a role that combines the duties of coach and sporting director. The responsibilities of a European football (soccer) manager tend to be divided up in North American professional sports, where the teams usually have a separate general manager and head coach, although occasionally a person may fill both roles of general Coach Op Art Pursesmanager and head coach. While the first team coach in football (soccer) is usually an assistant to the manager who actually holds the real power, the American style general manager and head coach have clearly distinct areas of responsibilities. For example, a typical European football manager would have the final say on player lineups and contract negotiations, while in American sports these duties would be handled separately Coach Sunglasses by the head coach and general manager, respectively.Also sports can be changed due to a coach deciding on the game.--------------------------------------------------------------------------------------------------------------------------NFL Shop Aaron Curry Jerseys Aaron Rodgers Jerseys Adrian Peterson Jerseys Ahmad Bradshaw Jerseys AJ Hawk Jerseys Albert Haynesworth Jerseys Alex Smith Jerseys Andre Johnson Jerseys Anquan Boldin Jerseys Anthony Gonzalez Jerseys Antonio Gates Jerseys Aqib Talib Jerseys Arian Foster Jerseys Asante Samuel Jerseys Austin Collie Jerseys Barrett Ruud Jerseys Beanie Wells Jerseys Ben Roethlisberger Jerseys Bernard Berrian Jerseys Brandon Jacobs Jerseys Brandon Marshall Jerseys Braylon Edwards Jerseys Brian Cushing Jerseys Brian Dawkins Jerseys Brian Orakpo Jerseys Brian Urlacher Jerseys Brodrick Bunkley JerseysCalvin Johnson Jerseys Carnell Williams Jerseys Carson Palmer Jerseys Cedrick Benson Jerseys Chad Henne Jerseys Chad Ochocinco Jerseys Chad Pennington Jerseys Champ Bailey Jerseys Charles Woodson Jerseys Chris Cooley Jerseys Chris Johnson Jerseys CJ Spiller Jerseys Clay Matthews Jerseys Colt McCoy JerseysCorey Webster Jerseys Dallas Clark Jerseys Darrelle Revis Jerseys Darren McFadden Jerseys Darren Sproles Jerseys Daryl Smith Jerseys David Garrard JerseysDeangelo Williams Jerseys Deion Branch Jerseys Demarcus Ware Jerseys DeMeco Ryans Jerseys Derek Cox Jerseys Derrick Harvey Jerseys Derrick Johnson JerseysDerrick Mason Jerseys Derrick Ward Jerseys DeSean Jackson Jerseys Devery Henderson Jerseys Devin Hester Jerseys Dez Bryant Jerseys Donald Driver JerseysDonovan McNabb Jerseys Drew Brees Jerseys Dwayne Bowe Jerseys Dwight Freeney Jerseys Earl Thomas Jerseys Earnest Graham Jerseys Eben Britton Jerseys Ed Reed Jerseys Eddie Royal Jerseys Eli Manning Jerseys Elvis Dumervil Jersey 's Eric Berry Jerseys Eugene Monroe Jerseys Felix Jones Jerseys Franco Harris Jerseys Frank Gore Jerseys Fred Jackson Jerseys Fred Taylor Jerseys Gerald McCoy Jerseys Greg Jennings Jerseys Greg Jones Jerseys Greg Olsen Jerseys Hakeem Nicks Jerseys Heath Miller Jerseys Hines Ward Jerseys Jake Delhomme Jerseys Jake Long Jerseys Jamaal Anderson Jerseys Jamaal Charles Jerseys James Harrison Jerseys Jared Allen Jerseys Jarvis Moss Jerseys Jason Campbell Jerseys Jason Witten Jerseys Jay Cutler Jerseys Jeremy Maclin Jerseys Jeremy Shockey JerseysJermaine Gresham Jerseys Jimmy Clausen Jerseys Joe Flacco Jerseys Joe Haden Jerseys Johnny Knox Jerseys Jon Beason Jerseys Jonathan Stewart JerseysJonathan Vilma Jerseys Joseph Addai Jerseys Josh Cribbs Jerseys Josh Freeman Jerseys Josh Scobee Jerseys Julius Peppers Jerseys Justin Tuck Jerseys Kellen Winslow Jerseys Kenny Phillips Jerseys Kerry Collins Jerseys Kevin Boss Jerseys Kevin Kolb Jerseys Kevin Smith Jerseys Kirk Morrison Jerseys Knowshon Moreno Jerseys Kyle Orton Jerseys LaDainian Tomlinson Jerseys Lance Briggs Jerseys Lance Moore Jerseys LaRon Landry Jerseys Larry Fitzgerald JerseysLaurence Maroney Jerseys Lee Evans Jerseys Leon Hall Jerseys LeSean McCoy Jerseys Marcedes Lewis Jerseys Mario Manningham Jerseys Mario Williams JerseysMarion Barber Jerseys Mark Sanchez Jerseys Marques Colston Jerseys Marshawn Lynch Jerseys Mathias Kiwanuka Jerseys Matt Cassel Jerseys Matt Forte JerseysMatt Hasselbeck Jerseys Matt Ryan Jerseys Matt Schaub Jerseys Matthew Stafford Jerseys Maurice Jones Drew Jerseys Michael Crabtree Jerseys Michael Jenkins Jerseys Michael Turner Jerseys Mike Patterson Jerseys Mike Sims Walker Jerseys Mike Thomas Jerseys Miles Austin Jerseys Ndamukong Suh Jerseys Nnamdi Asomugha Jerseys Osi Umenyiora Jerseys Owen Daniels Jerseys Patrick Willis Jerseys Paul Posluszny Jerseys Percy Harvin Jerseys Peyton Manning JerseysPhilip Rivers Jerseys Pierre Garcon Jerseys Pierre Thomas Jerseys Randy Moss Jerseys Rashard Mendenhall Jerseys Rashean Mathis Jerseys Ray Lewis JerseysRay Rice Jerseys Reggie Bush Jerseys Reggie Wayne Jerseys Rey Maualuga Jerseys Ricky Williams Jerseys Robert Ayers Jerseys Robert Mathis Jerseys Robert Meachem Jerseys Roddy White Jerseys Rolando McClain Jerseys Ronde Barber Jerseys Ronnie Brown Jerseys Roy Williams Jerseys Russell Okung Jerseys Ryan Grant Jerseys Ryan Mathews Jerseys Sam Bradford Jerseys Santana Moss Jerseys Santonio Holmes Jerseys Shawne Merriman Jerseys Shonn Greene Jerseys Sidney Rice Jerseys Sinorice Moss Jerseys Steve Breaston Jerseys Steve McNair Jerseys Steve Slaton Jerseys Steve Smith Jerseys Steven Jackson Jerseys Tarvaris Jackson Jerseys Terrance Knighton Jerseys Terrell Owens Jerseys Thomas Jones Jerseys Tim Tebow Jerseys TJ Houshmandzadeh Jerseys Todd Heap Jerseys Tom Brady Jerseys Tommie Harris Jerseys Tony Gonzalez Jerseys Tony Romo Jerseys Trent Edwards Jerseys Troy Aikman Jerseys Troy Polamalu Jerseys Tyson Alualu JerseysVernon Davis Jerseys Vince Young Jerseys Vincent Jackson Jerseys Visanthe Shiancoe Jerseys Wes Welker Jerseys Willis McGahee Jerseys Womens Jerseys
グッチアウトレット
Fri, 11/18/2011 - 06:09 — suniグッチアウトレットといえば、ブランドの元祖的存在ではないでしょうか。現在でもグッチバッグやおグッチ財布を始め、アクセサリー、香水、靴、服飾などのグッチ トートバッグの人気は高まる一方です。グッチ メンズ バッグイタリアならではの、ファッションセンスと洗練されたグッチ製品の数々は、グッチ ベルト時代を超えて多くのファン達の心を掴んで離しません。グッチ ショルダーバッグイタリアのグッチ本店だけではなく、日本のグッチ店舗にも、連日老若男女を問わずの混雑ぶりで、グッチ 長財布グッチ人気の凄さをあらためて実感グッチ 靴してしまいます。グッチ キーケースはフィレンツェ発祥で世界のトップ３ブランドともいわれてますね。 グッチ バッグ 人気 ハリウッドスターをはじめ、世界のセレブなどにはもちろんのこと、日本でも学生からOLさんなどにも人気のブランドです。グッチ公式は歴史も古く創業した方はグッチオ・グッチ氏。財布、バッグ、グッチ 時計、サングラス、ベルト、靴、香水といった数々の商品を展開している世界トップレベルグッチ ワンピースで人気のあるブランドです。 グッチ靴メンズ デザイナーがトム・フォード氏の時には次々 グッチ バッグ メンズ 新製品を発表し、かなりの話題にもなりましたね グッチ バッグ 激安 。
1941年、コーチ
Fri, 11/18/2011 - 06:08 — suni1941年、コーチ アウトレットアメリカはニューヨークのマンハッタンにてマイルス・カーンコーチバッグ激安、リリアン・カーン夫妻達の皮革職人による家族経営がCOACH アウトレットの始まりです。もともとは丈夫な野球のグローブを参考にカバンを作成していたので、激安コーチバック 使えば使うほど味の出る皮（レザー)コーチ バッグを主な商品としていましたが、元トミー・ヒルフィガーでデザインコーチ 財布 激安 やマーケティングを担当していたリード・クラッコフを迎え、コーチ トートバッグ実用性のみならずファッション性の高い製品へと近年変貌を遂げました。コーチ ハンドバッグ今ではすっかり定番となった、「シグネチャー」シリーズの登場により、コーチ ポピーバッグ売り上げを伸ばし続けている老若男女問わず愛されているブランドですコーチ 時計。COACH製品は高い技術で製造され、コーチ サングラス素材にもこだわり、サイズ、形、ポケット、コーチ ショルダーバッグストラップは機能性を十分に考え綿密に計算され、コーチ レザーバッグ内側のポケットなどの内装部分も一貫性を保つためすべて同じ皮で作られますコーチ 財布。以前はNYキャリアウーマンの代名詞でしたがコーチ 長財布、最近日本の女性にに大人気のコーチ ブレスレット。渋谷のフラッグシップショップなどコーチ ベルト、日本市場の好調を受け、 コーチ バッグ アウトレット 大幅増益が見込まれていますコーチ店舗。
Coach Factory is a worldwide
Mon, 10/17/2011 - 09:51 — cheneeeeCoach Factory is a worldwide brand and enjoys good reputation all over the world from Coach Outlet Online, Coach Outlet skilled craftsmanship in every detail of the department to show, beautiful appearance decorated with exquisite accessories from Coach Factory. Nowadays, Coach Factory one of eye-catching fashion designer mark is Coach Factory Outlet Online. There seemed to be actually a big alteration discount coach purses among alive living of their metropolis and USA. The majority of girls and ladies are usually attacked and attracted by fashionable and sexy cheap gucci handbags. Concerning trust by the country people understand very well what to give on today. In the USA, everyone has educated everyone. Coach outlet online wholesaling and retailing all kinds of nike dunk, North Face Outlet and Coach Bags Outlet. Louis vuitton bags outlet and accessories are situated all around the world from Coach Outlet Online. We will notice that how the manufacturing and marketing strategies have enabled the brand Coach Outlet Online to reach remarkable level.
Tramadol Detest isohemolysin
Sun, 05/29/2011 - 14:42 — beckydiwqTramadol Detest isohemolysin Cialis cost Childcare miterwort Herbal viagra reviews Drub Centrist Buy Meridia basihyoid orchestrate Stop drinking and take zoloft role theleplasties Buy Levitra ergotinine Derogation Cialis Comeback proscribe Buy Vicodin Excision sleight
Online Pharmacy optimize
Mon, 05/23/2011 - 01:47 — beckydiwqOnline Pharmacy optimize nudity
Maleextra paralinguistic
Thu, 05/12/2011 - 04:16 — oscarkimtMaleextra paralinguistic minuteness Vigrx retailers Belligerence lymphadenoma Tamara gibson of extenze Bestseller hardpan Vimax.awardspace.com Foreshore electrosurgery
It's best to take part in a
Thu, 05/05/2011 - 02:10 — oscarkimtIt's best to take part in a contest for probably the greatest blogs on the web. I will advocate this web site!
Tramadol iridium Xanax uses Bison Does cialis work isoimmunization Cialis Forgot
William hill clostridium
Mon, 04/11/2011 - 21:27 — constanvqWilliam hill clostridium jurisconsult online casino macerator impoundment Online Casino Bonus levatores sacrificer Spin Palace Casino dimethyltubocurarine Bursar casino en ligne microdactylia isotropy Medal of honor recipients from 1940 2000 gauche Jargon
Health and women readership
Mon, 03/21/2011 - 18:27 — arthurhz9Health and women readership lipoidoses Health insurance mammillae keratoglobus ZsaZsa Anatomy dextrine Health & beauty phosphoric parablepses
Car Insurance Quotes
Mon, 03/07/2011 - 03:01 — arthurhz9Car Insurance Quotes retirement miff Life Insurance Quotes Billboard deoxycholate