Insert Stored Procedure Results Into New Table Without Using OPENQUERY (SQLServerCentral 9/22/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Insert Stored Procedure Results Into New Table Without Using OPENQUERY]( - [The Best of Both Worlds: Using Excel and Power BI Together]( - [Multi Script Removes 25 Database Limit]( (From the SQLServerCentral Blogs) - [Uniquifier is a rather unique word isn’t it?]( (From the SQLServerCentral Blogs) The Voice of the DBA Help from Cortana I've been reading about and watching some of the experiments that people are conducting with [Cortana]( and other types of devices. I'm not quite sure what I think, though I would like to experiment with Cortana at some point and see how useful a computer assistant might be. I have tried to make notes of ideas that I think could be helpful, but for some reason I haven't really gotten the speech bug. I don't talk to my computer or phone very often, with the exception being texting with my family while driving. In that case, speech is handy and much safer than anything else. My wife is the opposite; she really likes speech. It seems many companies have been working to implement more assistant-like interactions with users. Amazon has the [Echo and Dot devices with Alexa]( Google has the [Home speaker](, and I'm sure more and more devices are coming over time. I don't know how useful these are in multi-person situations where people are speaking, but it does seem that some people like the help from devices. Perhaps I'm too much of a DYI person, since I prefer to push buttons and make my own selections. However, it seems some people prefer to talk, even in busy, loud, crowded situations. Many of us are data professionals, and even if we aren't planning on using speech, there is the possibility that bots or other technologies might help us improve the way we work with databases or help our customers use the information we manage. I've seen some interesting interactions with [Slack](, including one company that allows limited developer access to systems through a Slack bot that handles some provisioning work, including raising and closing a ticket, without requiring human interactions. I could even see some sort of alerting or "check this soon" interactions that might alert developers or administrators to take actions in a more casual way, perhaps doing so as part of a conversational queue of things to check rather than a list of items in a tool or a stack of email messages. An interactive assistant can be useful not only in providing information, but managing the flow to prevent overload. A personalized assistant might even do a better job or reminding you of items over time, perhaps anticipating future needs, or realizing some task hasn't been completed in some time. Certainly the same type of bot or agent might perform work on your behalf. This week, I'm wondering how many of you might find ways that a narrow, niche assistant might help you. Is there something in your work that an assistant might help you do? Or maybe there's some way that a device might help you in your life, separately from a simple notification on your mobile or through email. Perhaps in conversation or in a semi-structured fashion. I'm sure many of you have a creative way that you might like to see technology assist you. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( --------------------------------------------------------------- The Voice of the DBA Podcast Listen to the [MP3 Audio]( ( 4.5MB) podcast or subscribe to the feed at [iTunes]( and [Libsyn](. [feed]( The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. ADVERTISEMENT [Foundry]( How might classification and better documentation improve data safety? SQL Atlas is the latest prototype to come from the Redgate Foundry - find out more about what the tool does and try out the interactive demo for yourself. [Try the free prototype]( [Redgate Hub]( Do a lot more with Redgate tools You probably have a favored Redgate tool but if you’ve been using it for a while, you may not be making the most of the latest features. Keep track of features and releases on the new Redgate Hub. [Discover the Redgate Hub]( Featured Contents  [] [Insert Stored Procedure Results Into New Table Without Using OPENQUERY]( Orlando Colamatteo from [SQLServerCentral.com]() OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.[More »]( ---------------------------------------------------------------  [] [The Best of Both Worlds: Using Excel and Power BI Together]( Additional Articles from [SimpleTalk]() Excel and Power BI work well together. This allows you to use the two tools together to provide for many types of business workflow and BI practices. You can publish an Excel file to Power BI to share with others, analyse a Power BI dataset in Excel or import either an Excel workbook or Excel data to Power BI. You can gain the workgroup power and business-orientation of Power BI without losing the ease and versatility of Excel. Saurabh shows how.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Multi Script Removes 25 Database Limit]( Steve Jones from [SQLServerCentral Blogs]( I woke up to a Slack message that alerted me to a post in one of our channels. An engineer...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Uniquifier is a rather unique word isn’t it?]( Kenneth Fisher from [SQLServerCentral Blogs]( tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny name,...[More »]( Question of the Day Today's Question (by Steve Jones): Of these operations, which one is handled last in the logical order of query processing? - CUBE/ROLLUP - GROUP BY - HAVING - ON - TOP - WHERE Think you know the answer? [Click here](, and find out if you are right. --------------------------------------------------------------- We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: T-SQL. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. ADVERTISEMENT [Expert T-SQL Window Functions in SQL Server]( Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. [Get your copy from Amazon]( today. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): I have a database with a Database Master Key created in it. How do I back up the key? Answer: Use "BACKUP MASTER KEY" Explanation: The BACKUP MASTER KEY syntax is used. There is no database master key syntax, despite the name of the key as a Database Master Key (DMK). This is protected by the Service Master Key, but this key can be backed up and restored. Ref: BACKUP MASTER KEY - [( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Partitioning Data on First Character]( - Evening Guys, Let's say I have a table with a couple of billion rows of data. That I want to partition.... [SQL Server 2016 RTM (13.00.1708.0) Database Mail Not working]( - Hi Does anyone have database mail working with SQL 2016 (Standard Edition) and the Critical update 3164398? I've configured DB mail on... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [replace text in large number of view and procedure definitions]( - I want to find and replace one particular word (happens to be the name of a database, which I know... [Pivot basic question]( - All, Apologises for the basic question. I have the following pivot: DECLARE @SQLStr --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [order by predefined list]( - Hi I would like to issue the --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [How to encrypt Credit Card numbers?]( - We have now finally moved all our customers to SQL 2014 from old or very old SQL versions and I... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [disk space after deleting records.]( - I was running out of space so I ended up deleting some records from one of the biggest table I... [Intellisense on some databases, not others??]( - I have an issue in SSMS that I can't figure out. In SSMS, connected to an SQL Server 2012 instance (Enterprise... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Return parents for children with certain condition]( - Ok, so here is my sample data I am testing against... declare @t table (  Id  int ,  Section int,  DateOccured DATE,     Missed int ); insert into... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [Column Length]( - Dear All, Question regarding the length of a column . As its understandable it has to be in accordance with the data... [Display commands and results to the screen or file using SSMS]( - Hi I want to run a long list of disable accounts & update password commands in sqlserver using SSMS. I want to... [Script to Clean up Trace Files?]( - Does anybody have an already packaged method to clean up trace files that have reached a size threshold? I have... [Procedure to upgrade SQL Server on same server]( - Hi Experts, We have been asked to upgrade SQL server version on a number of STAND ALONE  as well as CLUSTER... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [Mortgage amortization table]( - *** EDIT 2015-03-04: please be advised the code I posted originally below was in need of some improvement, and Solomon... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 High Availability]( [SQL Server Mirroring Issue]( - Hello, I have SQL server 2008 R2 Enterprise edition 64 bit in Principle and Mirror Server and SQL Server 2008 R2... --------------------------------------------------------------- [Data Warehousing]( : [Strategies and Ideas]( [Multiple Calendars Using Kimball Outrigger Technique]( - Has anyone successfully used Kimball's outrigger technique for multiple corporate calendars in SSAS? If so, can you share the technical... --------------------------------------------------------------- [Database Design]( : [Design Ideas and Questions]( [Column Arrangement]( - Hello, I would like to understand about column arrangement in multi table relationship as mentioned below 1. Job Planning Header 2. Job Planning... --------------------------------------------------------------- [SQLServerCentral.com]( : [SQLServerCentral.com Website Issues]( [A user you are following, "...", has posted new content: but I'm not following this user]( - Today I received an email A user you are following, "...", has posted new content:but I'm not following this user "Thom A", has... --------------------------------------------------------------- [SQL Server 2005]( : [SQL Server 2005 General Discussion]( [Openrowset and Microsoft.Jet.OLEDB.4.0]( - Hi, I have seen quite a few requests for help on the subject of importing data from Access and Excel... --------------------------------------------------------------- [Microsoft Access]( : [Microsoft Access]( [best practices for Access to SQl conversion]( - One our network we have an Access front end and back end. The front end contains the queries, forms and... This email has been sent to {EMAIL}. To be removed from this list, please click [here.]( If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. --------------------------------------------------------------- This newsletter was sent to you because you signed up at [SQLServerCentral.com](. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it [here](. --------------------------------------------------------------- This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com