I've looked through many questions before asking the following: I don't have permissions to edit this Stored Procedure, only to run it and define the parameters. I need to aggregate the data from the output. For that, I am trying to store the output of the Stored Proc into a Temp table first. This is what I am trying to do, but obviously SQL doesn't recognize this:  SELECT * INTO #temp1 FROM     (         EXEC [dbo].[LockedStoredProc]          @START = '12/01/2016'         ,@END = '12/01/2018'         ,@PLAN_TYPE = 'all'         GO     )  Is there any way to get this to work the way I am trying to? I am using Microsoft SQL Server Management Studio.  Thanks!
How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]?  Select all data from BusinessLine into tmpBusLine works fine.  select * into tmpBusLine from BusinessLine   I am trying the same, but using a stored procedure that returns data, is not quite the same.  select * into tmpBusLine from exec getBusinessLineHistory '16 Mar 2009'   Output message:     Msg 156, Level 15, State 1, Line 2   Incorrect syntax near the keyword   'exec'.   I have read several examples of creating a temporary table with the same structure as the output stored procedure, which works fine, but it would be nice to not supply any columns.
Delete Duplicate Rows? I have a column in an Excel spreadsheet with several hundred entries, and some of these entries are duplicated.  I would like to remove all duplicate entries from the column so that each entry remaining is unique.   Is there a way to accomplish this automatically? Unable to install rJava in R 3.0 in Ubuntu 13.04 How can I install Celestia on Ubuntu 18.04.1? Like the title said, I want to install Celestia. I already downloaded the packages  and then, I tried all the things that I found on some posts (also, they're outdated, cause the last one is for Ubuntu 16.04) but nothing works.  How can I install it on Ubuntu 18.04.1? In how many ways can we choose k items from n distinct items put in a circle.   Then further extension of the question, if I want to find out the number of ways to choose k items from n distinct items in a circle such that no 2 are together.  Thanks Converting Older United States Dollar Bills How to resolve BackgroundContainer.dll error on startup? When I start my desktop it gives me an error about BackgroundContainer.dll.    How to get rid of it?  I found nothing when i started regedit.exe and searched (F3 or CTRL+F) for BackgroundContainer.dll I have multiple datasets that I am attempting to use principal component analysis (PCA) on in order to infer the underlying structure of the data.  I'm attempting to predict growth increment of conifers (the response which apparently needed to be cube root transformed for my original linear models).  My predictor variables include: continuous (some log-transformed like size-related variables, some compositional, and some traditionally scaled); binary; ordinal; and nominal (of which I'm pretty sure I can order with respect to site productivity).  I'm mostly attempting to make inferences because some of my previous models from linear regression have not produced significant terms corresponding to categories like health or climate and I feel that they should have.  I've read in Joliffe (2002) that I might want to leave my compositional data uncentered.  Forgive my naiveté, but I'm wondering if I should also do this for my binary data.  It also seems that I might not want to scale these since they're already on a 0 - 1 scale but I'm not sure.  After only using my continuous predictors (including compositional variables), it appears that a size principal component makes up the largest portion of the variability and Joliffe also mentions that one might want to attempt a "double-centering" of the log-transformed data if this is the case.  I don't know if this is even possible since the log-transformed data only makes up a small portion of my datasets.  Finally, I should ask if having such a combination of data types will complicate analysis so much that it will make inferences unreliable.  I am currently using R for this analysis.  Thank you. I am just a high school student, and I haven't seen much in mathematics (calculus and abstract algebra).  Mathematics is a system of axioms which you choose yourself for a set of undefined entities, such that those entities satisfy certain basic rules you laid down in the first place on your own.  Now using these laid-down rules and a set of other rules for a subject called logic which was established similarly, you define certain quantities and name them using the undefined entities and then go on to prove certain statements called theorems.  Now what is a proof exactly? Suppose in an exam, I am asked to prove Pythagoras' theorem. Then I prove it using only one certain system of axioms and logic. It isn't proved in all the axiom-systems in which it could possibly hold true, and what stops me from making another set of axioms that have Pythagoras' theorem as an axiom, and then just state in my system/exam "this is an axiom, hence can't be proven".  EDIT : How is the term "wrong" defined in mathematics then ? You can say that proving fermat's last theorem using the number-theory axioms was a difficult task but then it can be taken as an axiom in another set of axioms .  Is mathematics as rigorous and as thought-through as it is believed and expected to be ? It seems to me that there many loopholes in problems as well as the subject in-itself, but there is a false backbone of rigour that seems true until you start questioning the very fundamentals . Why does Linux show both more and less memory than I physically have installed? I recieve the below error when I am trying to call a Custom Lightning Component in a Visualforce page that is used in Communities.    Unrecognized Content-Security-Policy directive 'reflected-xss'.   logo180.png Failed to load resource: the server responded with a status of 404 (Not Found)   CommunityHomePage:1 Uncaught SyntaxError: Unexpected token w in JSON at position 0     at JSON.parse ()     at XMLHttpRequest.xhr.onreadystatechange (lightning/lightning.out.delegate.js?v=ZCuyRUYzK_kAf4cKCIeS2A:143)   My Component  &lt;aura:component controller="LeadController" implements="forceCommunity:availableForAllPageTypes"&gt;     &lt;aura:attribute name="theLead"          type="Lead"          default="{ 'sobjectType': 'Lead',                    'Rating__c': 2,                    'Company': '',                    'FirstName': '',                    'LastName': '',                    'Email': '' }"/&gt;     &lt;form&gt;          &lt;ui:inputText value="{!v.theLead.Company}" label="Company" class="input"/&gt;         &lt;ui:inputText value="{!v.theLead.FirstName}" label="First" class="input"/&gt;         &lt;ui:inputText value="{!v.theLead.LastName}" label="Last" class="input" /&gt;         &lt;ui:inputEmail value="{!v.theLead.Email}" label="Email" class="input" /&gt;         &lt;ui:button label="Save" press="{!c.save}"/&gt;     &lt;/form&gt; &lt;/aura:component&gt;   My Lightning App is   &lt;aura:application access="GLOBAL" extends="ltng:outApp" implements="forceCommunity:availableForAllPageTypes"&gt;     &lt;aura:dependency resource="c:CommunityChatter"/&gt; &lt;/aura:application&gt;   My VF Page is  &lt;apex:page standardController="Lead"&gt;     &lt;apex:includeScript value="{!$Site.BaseUrl}/lightning/lightning.out.js"/&gt;     &lt;script&gt;         $Lightning.use("c:MyLightApp", function() {             $Lightning.createComponent(                 "c:CommunityChatter",                 {},                 "theLead",                 function(cmp) {                     console.log("Component created!");                     console.log(cmp);                 });             });     &lt;/script&gt;      &lt;div id="theLead"&gt;&lt;/div&gt; &lt;/apex:page&gt; I am using Google Chrome 48.0 32-bit. Today when I launched Google Chrome, I got this message:    This computer will soon stop receiving Google Chrome updates because this Linux system will no longer be supported   I thought Ubuntu 14.04 is supported for five years, what's exactly happening here?  And on 64-bit Ubuntu, I get an error from Update Manager and apt-get update:  Failed to fetch http://dl.google.com/linux/chrome/deb/dists/stable/Release  Unable to find expected entry 'main/binary-i386/Packages' in Release file (Wrong sources.list entry or malformed file)   Some index files failed to download.   They have been ignored, or old ones used instead. The space obtained by identifying the antipodal points of a circle Set normal orientation of origin I want to change the orientation of my object to a specified direction.  Say I have an axle of a train whose normal orientation is set off by 90° from the global orientation:    The green arrow (Y-axis) points to the back of the train (along the global X-axis). But I want it to point to the sides of the train, so all I want is to rotate the orientation by 90° without rotating the object itself.  In other words, I want the normal and global orientation of the axle to be the identical:    Is this possible and if so, how?  Background: The game engine to use this model will move the bogies and the axles according to their orientations. After importing this train into the game the axles rotated 90° off. MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) How can I copy files from A to B, only including files that exist in B? I'm on Windows 7 Professional, and this is my scenario :  Folder "Asd" (C:\)              Folder "Asd" (D:\) File 1                          File 1  File 2                          File 3  File 3                          File 4 File 4 File 5   I'd like to select the folder on C:\ (without selecting each single file, of course) and copy it over the same folder on D:. Usually, it will copy all files. But what I'm looking for is to copy only files (from C:) that are contained on folder d:.  So in my case I'd like to replace only File 1, File 3 and File 4.  File 2 and File 5 must be ignored.  Is it possible? Here $p$ and $q$ are co-prime integers. Is it necessarily an algebraic number? get values from ANY type Object Is there a $(6,9,3)_2$ code? Does there exist a $1$-error-correcting binary code with block length $6$ and $9$ codewords?   The Hamming bound says that for any code $C$ with those parameters, $|C| \le \frac{2^6}{1+6} \approx 9.14$. So, we can't rule out the existence of such a code using the Hamming bound. The Singleton bound says that for any code $C$ with those parameters, $|C| \le 2^{6-3+1} = 16$, so we can't rule out the existence of such a code using the Singleton bound. Also, this can't be a linear code, since $\log_2 9$ isn't an integer. That rules out the possibility of just enumerating the possible generator matrices.   I feel a bit silly asking this, but the direct approach (assume $000\ 000$ is in the code, then all others must have Hamming weight $\ge 3$, ...) becomes unmanageable quickly. How else can I go about this? I have been reading Hamilton Chapter 13 and he has the following state space representation for an ARMA(p,q). Let $r = \max(p,q+1)$.Then the ARMA (p,q) process is as follows: $$ \begin{aligned}  y_t -\mu &amp;= \phi_1(y_{t-1} -\mu) + \phi_2(y_{t-2} -\mu) + ... + \phi_3(y_{t-3} -\mu) \\ &amp;+ \epsilon_t + \theta_1\epsilon_{t-1} + ... + \theta_{r-1}\epsilon_{t-r+1}.  \end{aligned} $$ Then, he defines the State Equation as follows:   $$  \xi_{t+1} = \begin{bmatrix}      \phi_1 &amp; \phi_2 &amp; \dots &amp; \phi_{r-1} &amp; \phi_r \\      1 &amp; 0  &amp; \dots &amp; 0 &amp; 0  \\      \vdots &amp; \vdots &amp; \dots &amp; 0 &amp; 0 \\      0 &amp; 0 &amp; \dots &amp;1 &amp;0 \end{bmatrix} \xi_t  +  \begin{bmatrix}      \epsilon_{t+1} \\     0\\\vdots  \\     0       \end{bmatrix}  $$  and the observation equation as:  $$y_t = \mu + \begin{bmatrix}      1 &amp; \theta_1 &amp; \theta_2 &amp; \dots &amp; \theta_{r-1} \\     \end{bmatrix} \xi_t. $$  I do not understand what the $\xi_t$ is in this case. Because in his AR(p) representation it is $\begin{bmatrix}      y_{t} - \mu \\     y_{t-1} - \mu\\\vdots  \\     y_{t-p+1} - \mu       \end{bmatrix}  $ and in his MA (1) representation it is $\begin{bmatrix}      \epsilon_{t} \\     \epsilon_{t-1}      \end{bmatrix}  $.  Could someone explain this to me a little bit better? prove that if two real valued  functions are uniformly continuous on some interval $I$  and each is bounded on $I$ then their product $f\cdot g=f(x)\cdot g(x)$ is also uniformly continuous on $I$ . Is boundedness of each function  on $I$ is  necessary for the product