I have the following query (SQL SERVER):  select id,id_nivel_estructura from estructuras_empleado where id in (1,2)   The result is the following:    but I want to display in columns in the following way:   1 | 4 | 67 | 146 | 345 | 2158   2 | 3 | 34 | 267 | 345 | 2152   Could you help me?
Trying to find some simple SQL Server PIVOT examples.  Most of the examples that I have found involve counting or summing up numbers.  I just want to pivot some string data.  For example, I have a query returning the following.  Action1 VIEW   Action1 EDIT   Action2 VIEW   Action3 VIEW   Action3 EDIT     I would like to use PIVOT (if even possible) to make the results like so:  Action1 VIEW EDIT   Action2 VIEW NULL   Action3 VIEW EDIT     Is this even possible with the PIVOT functionality?
I am trying to solve this exercise from Jech's book on set theory:  Ex. 3.6: There is a well ordering of the class of all finite sequences of ordinals such that for each $\alpha$, the set of all finite sequences in $\omega_{\alpha}$ is an initial segment and its order-type is $\omega_{\alpha}$. Definition: If $W$ is a well ordered set and $u \in W$, then the set $\{ x \in W \mid  x &lt; u \}$ is an initial segment in W  Any help? Is it time for Stack Exchange, Inc and the community to legally separate amicably? There's no need to  the  that have led to a lack of trust between  of  and . Suffice it to say that astoundingly they continue to assert that  and, instead of apologizing and reinstating Monica have demanded that she go through a process with no transparency, due process, or involvement from the community.   Has the time has come for Stack Exchange, Inc to spin off the community and all the data needed to keep the sites running to a separate non-profit, who would then in turn license the software from the company?  What's in it for the community?   The community can practice self determination for issues from as basic as the number of moderators they have to as fundamental as the policies they enforce. If the company development continues to be unresponsive to the community's needs, the community would be able to develop its own open source software that would meet its needs. They can find their own funding model instead of having ads imposed on them.   What's in it for the company?   Community actions will no longer reflect on the company. Interaction with the community as a customer may come more naturally to current leadership than the present paradigm. They don't have to worry about paying for the community's operating expenses. They can focus on doing one thing well. homemade chilli oil I am making chilli oil using light olive oil, crushed chilli, dried garlic, dried fennel seeds and parsley.  I have been making this for years. I am concerned about this Botulinum business. Should I be concerned? And what can i do to avoid this?  Currently, I heat the olive oil before putting it into the mixture, jar it, and normally keep it in the cupboard for months, with no problems with taste.  Another thing I am wondering is, how does one measure the expiry date on homemade chilli oil? Can someone help? Backtrack, Wi-Fi not working I've installed Backtrack 5R3 KDE, and I realized that my wireless is not working, but wired is working fine.  Here's the lshw output:     *-network         description: Ethernet interface         product: RTL8101E/RTL8102E PCI Express Fast Ethernet controller         vendor: Realtek Semiconductor Co., Ltd.         physical id: 0         bus info: pci@0000:02:00.0         logical name: eth0         version: 05         serial: 04:7d:7b:b7:46:f8         size: 100MB/s         capacity: 100MB/s         width: 64 bits         clock: 33MHz         capabilities: pm msi pciexpress msix vpd bus_master cap_list ethernet physical tp mii 10bt 10bt-fd 100bt 100bt-fd autonegotiation         configuration: autonegotiation=on broadcast=yes driver=r8169 driverversion=2.3LK-NAPI duplex=full firmware=rtl_nic/rtl8105e-1.fw ip=192.168.2.2 latency=0 link=yes multicast=yes port=MII speed=100MB/s         resources: irq:42 ioport:2000(size=256) memory:f0404000-f0404fff memory:f0400000-f0403fff   lspci output:      00:00.0 Host bridge: Intel Corporation 2nd Generation Core Processor Family DRAM Controller (rev 09) 00:02.0 VGA compatible controller: Intel Corporation 2nd Generation Core Processor Family Integrated Graphics Controller (rev 09) 00:14.0 USB Controller: Intel Corporation Panther Point USB xHCI Host Controller (rev 04) 00:16.0 Communication controller: Intel Corporation Panther Point MEI Controller #1 (rev 04) 00:1a.0 USB Controller: Intel Corporation Panther Point USB Enhanced Host Controller #2 (rev 04) 00:1b.0 Audio device: Intel Corporation Panther Point High Definition Audio Controller (rev 04) 00:1c.0 PCI bridge: Intel Corporation Panther Point PCI Express Root Port 1 (rev c4) 00:1c.1 PCI bridge: Intel Corporation Panther Point PCI Express Root Port 2 (rev c4) 00:1d.0 USB Controller: Intel Corporation Panther Point USB Enhanced Host Controller #1 (rev 04) 00:1f.0 ISA bridge: Intel Corporation Panther Point LPC Controller (rev 04) 00:1f.2 SATA controller: Intel Corporation Panther Point 6 port SATA AHCI Controller (rev 04) 00:1f.3 SMBus: Intel Corporation Panther Point SMBus Controller (rev 04) 02:00.0 Ethernet controller: Realtek Semiconductor Co., Ltd. RTL8101E/RTL8102E PCI Express Fast Ethernet controller (rev 05) The difference between "Older" and "Elder" What is the difference between "Older" and "Elder" ?  And are they interchangeable ? Other explanation for cosmological redshift? Suppose $f(x)$ is linear i.e. $f(x + y) = f(x) +f(y) $ and monotone on $[-\infty, +\infty]$, then $f(x) = ax$, a real. Suppose $f(x)$ is linear i.e. $f(x + y) = f(x) +f(y) $ and monotone on $[-\infty, +\infty]$, then $f(x) = ax$, a real.  We know $f(0)=0$, and if one assumes differentiability it is quite easy.      But how does monotone make up for differentiability? The following is the residuals vs predicted scatter plot for a regression model with two IVs.   Initially, I thought it was evidence of heteroskedasticity. But, I reasoned that although there is a visible pattern in the plot, the variance across different levels of predicted values is same.  To clear my doubts, I saved the standardized residual and predicted values and ran a bi-variate correlation test. The correlation is zero, as expected. I am, nevertheless, intrigued by this observation. Any idea why I might have obtained this pattern?  PS:- My dependent variable is a sum of two likert-type items (Response scale: 1-5). So, it's theoretical range is 2-10 and it has no absolute zero value. How coherent light is created for single slit experiment? Let's say I'm trying to answer a lot of questions just to up my reputation (even if I generally don't know what I'm talking about).  Then, whenever I get downvoted, I just delete my answer so that nobody sees that I've posted stupid answers, and so I don't lose reputation points.   Is this frowned upon? Do I lose reputation points on downvoted answers if I delete them? Example 1) Let's say I have some random creature with protection from white, and my opponent plays , a white card with the effect "Destroy all creatures." Can my creature with protection from white be destroyed by a white card that isn't actually targeting it specifically?  Example 2) I was playing a match with a friend where I had  on the field against his 3 zombies. Is he able to declare his zombies as blockers even though Elite Inquisitor has "protection" from zombies?  If he can declare them as blockers, does protection mean that no damage is dealt by the zombies to  Elite Inquisitor? Is the "Roman alphabet" what we use for English? I understand that the alphabet for the English language is not strictly English as languages such as French, Dutch and many more use the same alphabet, with few additions in other languages. Is Roman alphabet the common term to refer to this set of symbols for writing texts? Is "funnest" a word? We seem to be stuck at an impasse on this issue.  Is funnest a word or not?  If so, does it mean "most fun"? I have found the command to delete files older than 5 days in a folder  find /path/to/files* -mtime +5 -exec rm {} \;   But how do I also do this for subdirectories in that folder? iBooks preview not working? I recently converted one of my books into an iBooks format using Author. However when I connected to my iPad and went into 'preview', I saw my device, clicked it, but the 'preview' button to enable the previewing process was faded and I could not click it. Has anyone actually used the preview feature enough to give me some help? Thanks! How can I make a single event handler handle ALL Button.Click events? fleqn document class option, long text lines, and hyperref package When the fleqn option is used, the vertical spacing before an equation placed right after a "long" text line (exactly \linewidth I would say) is improperly set up. See below:    From the mathmode user guide, this could probably be fixed through the \topsep length. Is it the right way to proceed? The problem is reproduced by the code below:  \documentclass[12pt,fleqn]{book} \usepackage{amsmath} \usepackage{hyperref} \begin{document} \chapter{plo} \section{plo} eoiu oieu oeiuoe ueoi ueoi ueoiu eoiu oeu oe iupaêio umùaeoiuaem oeiu eoiu eoiu oeee. eoiu oieu oeiuoe ueoi ueoi ueoiu eoiu oeu oe iupaêio umùaeoiuaemm \begin{equation} \cos\pi=-1 \end{equation} eoiu oieu oeiuoe ueoi ueoi ueoiu eoiu oeu oe iupaêio umùaeoiuaem oeiu eoiu eoiu oeee. eoiu oieu oeiuoe ueoi ueoi ueoiu eoiu oeu oe iupaêio umùae \begin{equation} \cos\pi=-1 \end{equation} \end{document}   There is something wrong involving hyperref, amsmath, and fleqn. Removing one of those removes the problem. Firstly, how do I read it? Is below right? With braces   $$p \vdash (q \Rightarrow p)$$  The given proof is:    ${p}$, premise ${q}$, assumption  $p$ by (1) // what???  ${q} \Rightarrow p$ by implication introduction with 2 and 2.1 QED...    I can't really get the link between $p$ and $q$ in 2.1 ... A beginner's guide to SQL database design Do you know a good source to learn how to design SQL solutions?  Beyond the basic language syntax, I'm looking for something to help me understand:   What tables to build and how to link them How to design for different scales (small client APP to a huge distributed website) How to write effective / efficient  / elegant SQL queries What is the best way to explain how to choose between "its" and "it's"?