My aim is to display the person name and all the reason for his absences(concated and displaying in a string).  I am using the following query to display the EmployeeName, ReasonForAbsence. I am having problem with concatenating and Displaying all record specific column called 'AbsenceReason'. The error is  Incorrect Syntax near ='. More info about error- its happening for displaying absence reason part.  SELECT               --Displaying Name,                            EMP.NAME,                --Displaying Absence Reason              (                SELECT                     @AbsenceReasons= @AbsenceReasons + ';' + REASONTEXT                 FROM                      ABSENCE                  WHERE ID=EMP.ID                )   FROM            (              SELECT                     *                FROM                        Employees             ) EMP   What have I missed?  Thank you
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 :)
Can a massless rope accelerate? Does it have or has? How can I view all my unaccepted questions across SE? There are many different kind of options that you can do  in order to start using LaTeX on Ubuntu. I would prefer doing that through Eclipse, but if there is a better way of doing it, feel free to write your opinion on why using this instead of something else. Calculate sum of squares of first $n$ odd numbers Is there an analytical expression for the summation $$1^2+3^2+5^2+\cdots+(2n-1)^2,$$ and how do you derive it? command not found and syntax error near unexpected token How to get address of cell which calls a VBA Functions in a Excel sheet Can the Detect Magic spell detect prepared spells or spellcasters? Inspired by a recent question about discerning divine and arcane spellcasters, of like to hear the case for and against detecting spellcasters of either style with .  I think you can detect whether someone has prepared spells, based on this language:     For the duration, you sense the presence of magic within 30 feet of you. If you sense magic in this way, you can use your action to see a faint aura around any visible creature or object in the area that bears magic, and you learn its school of magic, if any. (emphasis mine)   Preparing spells is described as having the spell "fixed in mind" (). I'd argue that qualifies as bearing magic, and opens the door to using detect magic to identify spellcasters with currently prepared spells. What do you think? This is sort of a follow-up to a feature request that resulted in obscuring spam / offensive content from 10K-visible answers:   Suggest the same to be done for questions. As of now, spam questions (, ) preserve their titles and content. Suggest to revise the titles to something like     This question was marked as spam or offensive and is therefore not shown   And the text to something like:     This question was marked as spam or offensive and is therefore not shown - you can see the revision history for details".   Where "the revision history" links to the question revision history.    For those interested, here is a link to screen shots of how spam shines through my flagging summary page and is displayed to me when I click the link to one of deleted questions: .  For the sake of precision, flagger having less than 10K rep would see only upper screen shot - the one that lists question titles ("Call giRℒs blah blah &lt;phone number&gt;") - in their  page. Can Selenium interact with an existing browser session? Can't login with Google using Internet Accounts To convert an MKV to AVI, I do two things. The first thing I do is this:  ffmpeg -i filename.mkv -vcodec copy -acodec copy output.avi   or this:  ffmpeg -i filename.mkv -sameq -acodec copy output.avi   Either of these will convert the MKV to an AVI, but the problem is that the video does not play smoothly for some reason. That's fine though, because if I do one more thing it gets fixed:  ffmpeg -i output.avi -vcodec mpeg4 -b 4000k -acodec mp2 -ab 320k converted.avi   After I do this then the file plays without problem. I had success doing it this way for one file, but then I tried it on another file, and there is a slight, but noticeable loss in video quality. This is the output I get when doing the second step:  FFmpeg version 0.6.1, Copyright (c) 2000-2010 the FFmpeg developers   built on Dec 29 2010 18:02:10 with gcc 4.2.1 (Apple Inc. build 5664)   configuration:    libavutil     50.15. 1 / 50.15. 1   libavcodec    52.72. 2 / 52.72. 2   libavformat   52.64. 2 / 52.64. 2   libavdevice   52. 2. 0 / 52. 2. 0   libswscale     0.11. 0 /  0.11. 0  Seems stream 0 codec frame rate differs from container frame rate: 359.00 (359/1) -&gt; 29.92 (359/12) Input #0, avi, from 'output.avi':   Metadata:     ISFT            : Lavf52.64.2   Duration: 00:04:17.21, start: 0.000000, bitrate: 3074 kb/s     Stream #0.0: Video: mpeg4, yuv420p, 704x480 [PAR 229:189 DAR 5038:2835], 29.92 fps, 29.92 tbr, 29.92 tbn, 359 tbc     Stream #0.1: Audio: vorbis, 48000 Hz, stereo, s16 Output #0, avi, to 'converted.avi':   Metadata:     ISFT            : Lavf52.64.2     Stream #0.0: Video: mpeg4, yuv420p, 704x480 [PAR 229:189 DAR 5038:2835], q=2-31, 4000 kb/s, 29.92 tbn, 29.92 tbc     Stream #0.1: Audio: mp2, 48000 Hz, stereo, s16, 320 kb/s Stream mapping:   Stream #0.0 -&gt; #0.0   Stream #0.1 -&gt; #0.1   I just used arbitrarily large settings on the second step and it worked nicely before but not in this case. What settings should I use? How can I make a camera the active one? I have multiple cameras in a scene. What I want to do is to change which one is active. This way I can view the scene from different angles. How would I do this? I am a Swedish citizen traveling to Kyrgyzstan via Russia. Do I need a transit visa while waiting for my flight iin 24 hours? How can I change some pages into document into landscape mode, while leaving the others in portrait mode (or vice versa)? Uniform convergence of $\sum\limits_{k=1}^{\infty}\dfrac{kf(x^2)}{1+k^3f(x^2)^2}$ Have Chrome autodetect language before spelling checking? Proper fstab entry to mount a samba share on boot? I am a little confused on the proper fstab entry for a samba share in Ubuntu 12.04     I can get the drive to mount manually by using:  sudo mount -t cifs //192.168.2.2/raid_drive /mnt/homeserver -o username=jon,password=password  So I tried putting this in fstab:  //192.168.2.2/raid_drive /mnt/homeserver cifs username=jon,password=password,iocharset=utf8,mode=0777,dir_mode=07‌​77 0 0  Which gives me this error in syslog:  kernel: [ 2217.925354] CIFS: Unknown mount option mode kernel: [ 2217.936345] CIFS VFS: default security mechanism requested.  The default security mechanism will be upgraded from ntlm to ntlmv2 in kernel release 3.3  This  says to use smbfs although I believe smbfs is deprecated?   What is a common fstab configuration for a samba share in Ubuntu 12.04?   EDIT:  Using the accepted answer below I was initially getting this error message (from dmesg):  [   45.520883] CIFS VFS: Error connecting to socket. Aborting operation [   45.520990] CIFS VFS: cifs_mount failed w/return code = -115   although it turns out this was due to network connectivity issues, and not related to improper fstab entry. Repeated ANOVA unbalanced data I did experiment on one group of rats, the group was tested during 8 days, this is the first stage. The same group was also tested again but this time the test phase was 7 days. I tried to do my analysis using ANOVA repeated measures but I had a problem with the days.. I want to know the difference in the 2 tests but the days are not the same number. I don't know how to handle it. If there is any way to do the analysis using repeated measures ANOVA.   I tried to use repeated measure anova within subjects effect. My first factor will be test with 2 levels (test 1 &amp; 2),second factor is day with the level of ?? Here is the problem! if I write 8 there will be extra day in test 2 and the analysis cant carry!! I have installed some apps through the Ubuntu Software center. How can I find the corresponding terminal command? For many apps, this is not the same as the displayed name. For example, the app called Text Editor can also be launched by typing "gedit" in the terminal, but how can I find this for other apps?