sql server stored procedure - collection of data for fields as input
What's the best practice of inserting a collection of data into a SQL Server database
Why doesn't Spotlight show invisible files that I know exist? I am running Mac OS X 10.8 (Mountain Lion) and had to edit an invisible file as part of an Android project. While I eventually found it, Spotlight was of no help, since it could not find an invisible file when searching for the exact name (.classpath) and with the 'File Visibility' option set to 'Visible or Invisible'.  Why didn't Spotlight work in this instance? Where were the Avengers during Iron Man 3? How to start a terminal with certain text already input on the command-line? Rather than rephrasing my question, let me describe to you the desired user-case:  I create a short shell-script to run command "gnome-terminal --someoptionflagname 'my text to be posted'", and execute this script.  Gnome-terminal pops up, with command-line prompt followed by my text.   ie: fields@mycomputer:/$ my text to be posted  Can this be done? Do Indian passport holders with UK Tier 2 need to get a tourist visa for Mexico? I'm an Indian passport holder currently resident in the UK under a Tier 2 (General) visa and planning on going to Mexico on a holiday. So I was looking into the rules on the Mexican embassy in the UK and :     According to the new regulations who entered into effect on 18th, May   2016 (article 26 of the Guidelines and Requirements for Migratory   Services) regarding foreign nationals visiting Mexico, holders of a   valid UK visa, regardless their nationality, are not required to apply   for a Mexican visa as a tourist, business (Non-Lucrative Activities)   or transit visitors for a stay of up to 6 months. This regulation does   not apply to British Travel Document holders.   However, :     PERMANENT RESIDENT IN THE UK (ILR / ILE / PERMANENT RESIDENTS)        According to Mexican regulations which came into force in June 2009,   Permanent residents in the United Kingdom wishing to travel to Mexico   do not require a visa to enter the country as tourists or business   visitors for up to 180 days and as visitors in transit for up to 30   days, regardless their nationality.   So which one is correct? Are Tier 2 holders with an Indian passport allowed visa-free / visa on-arrival entry to Mexico? How to find orphaned files and images which are not linked from any css stylesheet or from any node? Is there a way to list all unused files which reside inside public file system and inside a theme directory and list them, or maybe even have an option to delete them automatically?  I mean files which are currently not linked from any css stylesheet or from any node. How to prove the positive definite property of the semidefinite matrix with regularization? If I have a positive semidefinite matrix $A_{n\times n}$, I want to transform it to positive definite matrix. I plug the following operation to the original matrix: $$B=A+\lambda I_{n}$$ where $\lambda &gt; 0$. I want to know whether B is positive definite matrix. Could anyone proof it? Recolor Artwork: single swatch to multiple swatches I have an Illustrator document with a lot of objects. All the objects are black, same swatch.  I have a swatch group with a few dozen coloured swatches. I wish to apply these swatches to all the many black objects. It doesn’t have to be in any particular order, but each object should be coloured individually—I don’t just want to change black into some other colour, but to dozens of other colours. What I really want to avoid is having to select each object individually and then applying a different swatch to each.  I’ve never quite managed to get my head properly around the Recolor Artwork feature in Illustrator, and I cannot for the life of me get it to do anything like this. The “New” box in the Recolor Artwork dialogue box appears to accept only one colour.  Is there some way to do this using the Recolor Artwork feature? Or using some other feature that I’m not aware of? Bonus points if there’s a way to control the order in which the colours are applied; e.g., specifying an order and then click on each object in turn to apply each swatch being ‘iterated’ through in that order.  (I would prefer to avoid having to script it, but I will if there’s no other way.) Is there a tool that combines zcat and cat transparently? When handling log files, some end up as gzipped files thanks to logrotate and others not. So when you try something like this:  $ zcat *   you end up with a command line like zcat xyz.log xyz.log.1 xyz.log.2.gz xyz.log.3.gz and then with:  gzip: xyz.log: not in gzip format   Is there a tool that will take the magic bytes, similar to how file works, and use zcat or cat depending on the outcome so that I can pipe the output to grep for example?  NB: I know I can script it, but I am asking whether there is a tool out there already. I think the answer is yes but I know a lot of people disagree. So, I would like to ask these people when exactly does it stop being me.  Let's say I want to upload my brain into a computer using the following procedure:  I have each of my neurons replaced by electronic neurons. By electronic neurons I mean chips with the necessary hardware and software to perform the exact same function that the neuron being replaced was performing. This means that given the same inputs that the biological neuron was given it would produce the same outputs. Then I connect that electronic neuron to all the neurons that former biological neuron was connected to.   At the end of this process is it still me? If not when did it stop being me? When one neuron was replaced? When 1,000 were replaced? When 1,000,000 were replaced?  (assuming it is still me)  Then, I divide these electronic neurons into groups and for each group I perform the following:   Write software to simulate the group of electrical neurons in my computer such that given the same inputs that go into the group of electronic neurons in my brain, it will produce the same outputs. Replace each group of neurons with another chip that communicates with my computer. Each of the chips will communicate to the corresponding software module in order to determine how to transform its inputs into the necessary outputs. Connect all of the inputs and outputs of the group of electronic neurons to that new chip.   At the end of this process is it still me? If not when did it stop being me? When one group was replaced? When 1,000 were replaced? When 1,000,000 were replaced?  (assuming it is still me) Now, what I have is a bunch of these new chips in my head, connected to each other and for each of these chips I have a small neural network software module in my computer. So, now for each pair of chip/software module I do this:   Transfer all connections going into and out of the chip into the computer version (i.e. connect the software module to the other software modules that represent the other chips that this chip is connected to) Disconnect the chip from the other chips and remove it   At the end of this process is it still me? If not when did it stop being me? When one of the new chips was replaced? When 1,000 were replaced? When 1,000,000 were replaced?  If it is still me then I have successfully moved my brain into a computer without ceasing being myself.  So, again the question is if at the end it is not me anymore when exactly does it stop being me and why does it stop being me?  EDIT: This question assumes that our universe and everything in it (including ourselves) follows the (testable) laws of physics. As it stands it also assumes that neuroscience is mostly right, although the question could also be considered without that requirement if instead of neural simulations we were to implement physics simulation of the brain. Of course this is a lot less practical. However, if your view is that our minds have a supernatural component then the question does not make any sense.  It was also pointed out that this is related to the Ship of Theseus, i.e. is something still the same if all its parts have been changed. With regards to that I think it is useful to consider that most of the cells in our body (not including brain cells) are regularly replaced anyway and some people even get entire organs replaced. Yet, we don't say that they stopped being themselves. Note, however, that if you are assuming a supernatural component of the mind that this explanation is not really adequate or relevant. 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. Gaming with Virtualbox, has it worked for you? Currently I am using Windows 8. I have a virtual box with Ubuntu set up for development. Aside from that I sometimes just want to relax and enjoy a game (Battlefield 3, Skyrim, Saints Row: The Third, etc) after hours of research and development.   I want to have my main machine with linux, and install windows on a virtual box.   What I want to know, from those who have tried or seen it:   How is the performance? I've never been clear on this but, even if I install the correct drivers on the windows box, will it matter? At least on this part, I'm just curious how it offload. Which drivers will matter the most.  Mouse and Keyboard integration, I'll be honest, sometimes the mouse integration in Virtual Box is a bit frustrating, mouse cursor disappears, etc.    I'm not sure if this is the right place to ask. I'm merely trying to come back to linux, yet I'm a PC gamer so I can't throw away Steam. I'm aware of the linux client, but most of those games won't work.   If there's a right place to ask this whether StackExchange sites or any other site let me know.   Cheers and I hope those in the same position find a middle ground. Community isn't on ~15 sites! I was looking at the Community user's profile, and I noticed that there was about 15 sites missing in the "accounts" tab. There's a little over 120 sites on SE, and, there's about 15 sites missing from this count. Why is this happening?    Additionally, clicking on view more just shows one account, on Area51: Pass Blob through ajax to generate a file (Ubuntu 13.04 with GNOME Shell, upgraded, GNOME version 3.8) Recently, I upgraded Ubuntu to 13.04. the default desktop is gnome-shell. Except Nautilus, other software border doesn't disappear when I make them to be maximized. I checked the problem for these software:  LibreOffice Firefox Rhythmbox thunderbird GNOME-Terminal  On the other hand there are three bars on maximized mode:  GNOME Shell panel  Title-bar for software which contains - + x (minimise, maximise, close) buttons.  Software menu-bar  Number &quot;2&quot; is extra. Is a package missing? How can I retrieve mp3 metadata in Python? Break a loop animation (Make Cyclic) to start a new one I've used the 'Make Cyclic' to loop these keyframes (image below). So, I want to break the loop at a certain time to do a new animation (insert another kf to do a different thing than the loop does). Any help how to do this?    Thanks in advance! Run TTY script every time I open a GUI terminal Prove that if every node in a simple graph $G$ has degree $3$ or higher, then $G$ contains a cycle with a chord. Inheritance of static members in PHP In PHP, if a static attribute is defined in the parent class, it cannot be overridden in a child class. But I'm wondering if there's any way around this.   I'm trying to write a wrapper for someone else's (somewhat clunky) function. The function in question can be applied to lots of different data types but requires different flags and options for each. But 99% of the time, a default for each type would suffice.  It would be nice if this could be done with inheritance, without having to write new functions each time. For example:  class Foo {     public static $default = 'DEFAULT';      public static function doSomething ($param = FALSE ) {         $param = ($param === FALSE) ? self::$default : $param;         return $param;     } }  class Bar extends Foo {     public static $default = 'NEW DEFAULT FOR CHILD CLASS'; }  echo Foo::doSomething() . "\n";  // echoes 'DEFAULT'  echo Bar::doSomething() . "\n";  // echoes 'DEFAULT' not 'NEW DEFAULT FOR CHILD CLASS'  // because it references $default in the parent class :( Is it supposed to be a HTML or an HTML I've seen many people who say:     This is a HTML page.   Yet I've also seen many people who say:     This is an HTML page.   Are both usages equally correct?  Or, which is the grammatically correct one?       Possible Duplicates: