no material are showing instead it takes a still color of the background in viewport
AMD GPU Material in "material preview mode" and "rendered mode", is entirely gray as background. Only outline is displayed
Simulating group_concat MySQL function in Microsoft SQL Server 2005? I'm trying to migrate a MySQL-based app over to Microsoft SQL Server 2005 (not by choice, but that's life).  In the original app, we used almost entirely ANSI-SQL compliant statements, with one significant exception -- we used MySQL's group_concat function fairly frequently.  group_concat, by the way, does this: given a table of, say, employee names and projects...  SELECT empName, projID FROM project_members;   returns:  ANDY   |  A100 ANDY   |  B391 ANDY   |  X010 TOM    |  A100 TOM    |  A510   ... and here's what you get with group_concat:  SELECT      empName, group_concat(projID SEPARATOR ' / ')  FROM      project_members  GROUP BY      empName;   returns:  ANDY   |  A100 / B391 / X010 TOM    |  A100 / A510   So what I'd like to know is: Is it possible to write, say, a user-defined function in SQL Server which emulates the functionality of group_concat?   I have almost no experience using UDFs, stored procedures, or anything like that, just straight-up SQL, so please err on the side of too much explanation :) Random test data: How to do it right? So, I got some laptop charger from my neighbor and I was thinking about to do something with it. Then one day I feel tiny shock from the output of the charger. I thought ac to dc filtering mechanism maybe shorted. Then I had tested other remaining charger to see if there was any AC current going on. And they all do the same. Is it normal to have flow some AC through DC ? Can I do something about it ? make it safer for work ? It does not feel like comfortable. Questions about right ideals When I'm editing a stack snippet, I often want to copy code from the original question into the snippet. But while the snippet editor is on display, there's no way to access the question, other than opening another tab/window. What I often do instead is copy all the code in the question to the clipboard, open the snippet editor, then paste it all in and revise it to what I want. But when the original code is poorly designed, that ends up being more work than just copying the bits and pieces that I want.  There could be a "View Question" button that pops up the question over the snippet editor and allows copying. Or maybe the Snippet Editor could be draggable and resizable, so you can reveal the question and copy from it; but this would require that it not be purely modal. group of units in a topological ring A physical explanation for negative kelvin temperatures Word for "not consciously aware of" What's the word to convey the meaning "not consciously aware of"? Options for crowdsourcing GIS data? I am looking at collecting spatial information from a range of stakeholders to identify opportunities within a landscape.  However, the data that we are collecting are not presently mapped and so we wish to use an interactive method to get this information onto a map.  Which online websites/methods would people recommend for circulating to a non-technical audience to try and get them to map what they know?    Where the emphasis is on ease of use by the stakeholder. What did Enel do after being defeated? As shown in the Manga and the Anime, Enel survived along with the Ark.  He then Embarks to Fairy Verth      The Moon.   In the Manga it shows his adventures on the Moon.  But what happened?  I didn't understand the situation that happened.  What exactly happened on the Moon? What can I do with .chk files in FOUND.000 folders? Just discovered I have gotten a FOUND.000 folder on my usb drive. I guess from running chkdsk once. It has three files in it:   FILE0000.CHK FILE0001.CHK FILE0002.CHK   What exactly can I do with these files? What are my options? Are they lost files? Are they garbage? Can I use them for anything at all? Or will I just have to delete them? Movie with humans battling aliens piloting giant animalistic, water-walking robots or sea warships I have memories of watching it a few years ago (I was a kid then) in the early 2000s probably; before 2010 I think. It was a movie with giant robots, and the enemies were aliens piloting what I remember as giant, more animalistic robots. I remember those animalistic ones running on water. The aliens themselves were a little taller than humans but mostly humanoid. I remember what the aliens look like a bit; most of the movie they were clad in some kind of armor, but the scene I mentioned showed one's face, if I remember well, grey skin, vividly green eyes, a beard made of some kind of quills, bald. I have this one scene that stayed crystal clear in my memories. The heroes had captured an injured alien, and other aliens attack to, in the end, just retrieve the injured one, leaving with this one without attacking further this time. I also remember the aliens going through a city in some machine (I'm actually not sure this one was piloted though) and destroying anything it perceived as a threat, from cars to security cameras. My memories are coming from years ago, so I might be wrong in a bunch of things there, but this one scene, I can assure is correct. This might remind a bit of Pacific Rim, but it isn't. (It's watching Pacific Rim that reminded me of this movie.) It doesn't seem to show up on any giant robot movie list on internet, weirdly, so I hope you can help me. And now I'm starting to wonder if there was really robots on the heroes' side. Maybe it was warships (sea ones, not spaceships). As I said it was some time ago and I was young, so bad memories are likely. Rkhunter warnings help I installed Ubuntu 14.04 a few days ago. I've made a scan with a RkHunter and got a few warnings that I don't really know what to do with. I read about false positives a little bit but I didn't find the answer for myself really. I got those errors:  Checking /dev for suspicious file types         [ Warning ] [19:44:16] Warning: Suspicious file types found in /dev: [19:44:16]          /dev/.udev/rules.d/root.rules: ASCII text [19:44:16]   Checking for hidden files and directories       [ Warning ] [19:44:16] Warning: Hidden directory found: /etc/.java: directory [19:44:16] Warning: Hidden directory found: /dev/.udev: directory [19:44:16] Warning: Hidden file found: /dev/.initramfs: symbolic link to `/run/initramfs' Checking for group file changes                 [ Warning ] [19:44:16] Warning: Group 'winbindd_priv' has been added to the group file.   Should I be worried ? What equipment and settings do I use for panning shots of moving objects? Profile picture cannot have transparent background How does an accelerating charge radiate electromagnetic waves? How do I apply differential cryptanalysis to a block cipher? I have read a lot of summaries of block ciphers particularly with regards to the NIST competitions stating that reduced-round block ciphers are – for example – vulnerable to differential cryptanalysis.  I have a general idea that the application of differential cryptanalysis is to look at the difference between inputs;  makes that fairly clear. However, I could take any two inputs for any given block cipher and I am pretty certain I'd be staring at random differences.    I am aware this is the idea of a well written block cipher; however, assuming a broken or vulnerable cipher (feel free to provide simple examples) how do I go about choosing differences to try?  Are there any clues in algorithm design that would inform a decision on which values to choose?  How does being vulnerable to differential cryptanalysis impact a cipher in the wild?  If all I have are differences between known plain-texts and known keys as my analysis and a captured ciphertext as my data to exploit, what can I actually deduce? Reducing resolution of huge categorical raster in QGIS? android expandablelistview how to set space between groups items Going through the spells, I see the phrase "Willing creature" used to determine who you can cast some spells on. I don't ever see a proper definition of what a willing creature is, but I would assume that it would go something like if you asked them "Can I perform this spell on you" they would answer yes. Is there a more formal definition of what makes a target willing in 5e?  What are the ways I could make an otherwise unwilling creature willing? Suggestion spells, for instance, should probably work but what other options do I have?