Search Results

Search found 89681 results on 3588 pages for 'cross server'.

Page 570/3588 | < Previous Page | 566 567 568 569 570 571 572 573 574 575 576 577  | Next Page >

• Trouble Setting up Open SSH with Putty

  - by warpstack

  I for the life of me can't seem to get openSSH to work on Ubuntu Server 10.10 with keys I generated in PuttyGen on my Windows machine. After hours of trial and error and web searches I can't get my ssh service to accept my private key! Here is my sshd_config. I generated my public and private keys using Putty in Windows then used a ssh connection to paste my key from putty directly into my authorized_keys2 file located in */etc/ssh/publickeys/authorized_keys2* The authorized_keys2 file looks something like: ssh-rsa AAAAB3NzaC1yc2EAAAA... with no email or anything at the end of it. I just pasted it straight from PuttyGen without using a key comment. I feel like it's not working because of some nuance I am not understanding or some unusual setting or incompatibility. I've restarted the ssh service (and the machine) to no avail. What are some common pitfalls I might have gotten myself into? Is there a simpler way to generate ssh keys that putty can use in windows?

  Read the article

• Best database setup for one click games

  - by ewizard

  I am building a one click game website/mobile app, and I am debating between using MySQL and MongoDB for the backend. The way I have been exploring it is with a NodeJS/Express/Angular/Passport/MongoDB stack - I have also implemented Socket.io. I have gotten to the point where I am sending data from the flash game to the server (NodeJS). The only data that needs to be sent is basic user information, the players score at the end of each game, and some x,y positions for each players game (for anti-cheating). It seems like MySQL would work fine, but as I am already using MongoDB - are there any major drawbacks to continuing to work with MongoDB on this project?

  Read the article

• How do I install OpenStack?

  - by csgeek

  Supposedly openstack can be installed easily under Ubuntu 12.04 LTS. I've installed 32 and 64bit versions of Ubuntu Server with the same behavior. sudo tasksel check OpenStack hit Okay then I get a tasksel: aptitude failed (100) I've seen: http://www.hastexo.com/resources/docs/installing-openstack-essex-20121-ubuntu-1204-precise-pangolin and https://github.com/EmilienM/doc-openstack documentation, but I was hoping that since it was an LTS released and it was an option in tasksel that I was simply overlooking something obvious and it's just a matter of selecting the right checkbox and hitting okay. Too much wishful thinking?

  Read the article

• Not assigning Bugs to a specific user

  - by user2977817

  My question: Is there a benefit to NOT assigning a Bug to a particular developer? Leaving it to the team as-a-whole? Our department has decided to be more Agile by not assigning Bugs/Defects to individuals. Using Team Foundation Server 2012, we'll place all Bugs in a development team's "Area" but leave the "Assigned To" field blank. The idea is that the team will create a Task work item which will be assigned to an individual and the Task will link to the Bug. The Team as a whole will therefore take responsibility for the Bug, not an individual, aligning to Scrum - apparently. I see the down side. The reporting tools built into TFS become less useful when you cannot sort by assigned vs unassigned, let alone sorting by which user Bugs are assigned. Is there a benefit I'm not seeing? Besides encouraging teamwork by putting the responsibility on the team-as-a-whole instead of an individual?

  Read the article

• How large should I make root, home, usr, var, and tmp partitions?

  - by Teddy Okidoki

  i install ubuntu server 10.04, have 64 Gb VHD. And want to separate partitions in this mode: /dev/xvda0 p on swap (2 Gb) /dev/xvda1a0 e on /boot (128 Mb) /dev/xvda1a1 e on / type ffs (local) /dev/xvda1a2 e on /usr type ffs (local, nodev) /dev/xvda1a3 e on /tmp type ffs (local, nodev) /dev/xvda1a4 e on /var/log type ffs (local, nodev) /dev/xvda1a5 e on /var type ffs (local, nodev, nosuid) /dev/xvda1a6 e on /home type ffs (local, nodev, nosuid, with quotas) /dev/xvda2 p on /new (local, nodev, nosuid, noexec) with rest of space ~50Gb. But i'ma stuck, and don't know what size to give to each folder. Also i want to encrypt partitions. Thank you for any tips. EDIT: System need minimum size, here will be installed about 10 apps like ufw, apache,mysql, chkrootkit and so on.

  Read the article

• Make public webcam. Which protocol, which codec. (Using VLC)

  - by gsedej

  Hi! I want to use my old (1GHz) PC as webcam video stream server (like you can see those road cameras). I thought of using VLC and already tried using http output but it was not really good. Too cpu hungry, too big stream (kBps), not stable... I been reading VLC how-to's but thre is still a question. Which output should I use? Http, RTSP, UDP? I want to make for more than one computer at the same time (multicast). Which codec should be good? PC is not so fast so it shouldn't be too cpu hungry codec. Mpeg2, mpeg4, xvid? how much video buffer should I use (vb=?)? What about setting IP and ports? So I need some help with ideas, but if someone can make a VLC command line it's even better :) Oh, computer has direct internet connection and own IP.

  Read the article

• OpenStack + Ubuntu 12.04

  - by csgeek

  Supposedly openstack can be installed easily under Ubuntu 12.04 LTS. I've installed 32 and 64bit versions of Ubuntu Server with the same behavior. sudo tasksel check OpenStack hit Okay then I get a tasksel: aptitude failed (100) I've seen: http://www.hastexo.com/resources/docs/installing-openstack-essex-20121-ubuntu-1204-precise-pangolin and https://github.com/EmilienM/doc-openstack documentation, but I was hoping that since it was an LTS released and it was an option in tasksel that I was simply overlooking something obvious and it's just a matter of selecting the right checkbox and hitting okay. Too much wishful thinking?

  Read the article

• ACL tool for audit of Ubuntu production servers

  - by migrator

  In my production environment, I have close to 10 Ubuntu 12.04 Servers and I want to get the list of users from them. I am looking for some kind of script or tool (non-gui) to get the same. Yes, I can get the list from /etc/passwd and /etc/groups files but it would be good to have a tool or script to do this due to the following reasons. I have right now 10 systems in Ubuntu and 30 systems in Windows 2003. I am recommending my organization and IT to move all the systems to Ubuntu except the one running MS SQL server We do not have good Ubuntu admins with us and they should not mess up with the system if I give some manual commands I also need to find out date of creation of user, group, password standards like strength, expiry etc Please help me as I want to automate the process and get the list on weekly basis from IT team. Thanks in advance.

  Read the article

• Writing Ubuntu shell scripts

  - by Lukesh

  Write a script that will shut down one of your server called “appsserver” every night in order to preserve power. But before the appsserver is brought down, your script should do the following: Check if there are any users logged into the appsserver Check the size of the directory /usr/tmp is bigger than 1G and delete all its content. If (a) is true, send a broadcast message to all user that the machine will shut down in 20 minutes and that they should log out of the appsserver All the output of the commands in your script should be sent to a log file with the script running date appended to the log file itself (e.g. shutdown_14_Nov_2011.log).

  Read the article

• Webmin no longer works - connection rejected

  - by Omeed

  I've had webmin installed on my 12.04 server and everything has been fine until recently. Now when I navigate to https:// myip:10000 I get a message saying the connection attempt is rejected. The last thing I did was set up a cron job to start utorrent webUI. I tried reinstalling but no change. When I check with netstat I see a webmin entrance on port 10000. I've also reset the iptables and allowed everything. I'm at a loss as to what to do now.

  Read the article

• Install failing new hard drives

  - by John

  I'm trying to install Ubuntu server 12.04 on my new hard drives but it seems to fail. Once past the option menu where is asked the partition to install the OS on, goes into a hold and no progress is shown afterwards. The hard disk I'm trying to install it on is: Western Digital WD20EARX The installation process hangs around 'installing core packages/installing the base system' . The CD comes through the test with being valid/ok. any help would be appreciated. Thanks in advance.

  Read the article

• Desktop GUI Client - Remote RDBMS communication

  - by magom001

  Sorry if I am asking a trivial question but I have been searching for a while without any luck. I need to design a system and I am looking for advice on the technology that should be used. The layout is very simple: it is a sales application with a centralized database and multiple clients. Each salesperson has GUI app installed on his/her laptop that should be able to connect to the database to retrieve data and upload data (i.e. register new orders). My question is the following: how should the communication between the client and the server be implemented? I doubt that connecting directly to the RDBMS is a good idea... Should I use web-services? XML-RPC? How to implement authentication and encode the data? Thanks for your advice!

  Read the article

• Any risks in forwarding incoming requests to my computer? [closed]

  - by pimvdb

  I just installed EasyPHP, which is basically a combination of Apache, PHP and MySQL for dummies. I'd like to make my router forward incoming requests to my computer, so that everyone on the Internet could fetch data from my computer using the Apache server. However, I was wondering if there are many risks in this. For example: Could someone get full control of my computer this way? Is my computer more exposed to secutiry risks? Could I (practically) get DDOSed? The last question might be exaggerating, but I'm just curious. Thanks.

  Read the article

• Data transfer from 12.04 to 14.04 using same hostname?

  - by Mark

  I've been using my 12.04 server for a year and a half. I'd like to install 14.04 on a new drive and transfer all my data over once that is complete. I have 720GB of files to to deal with. 12.04 was setup using LVM. I'd like to use the same hostname. I'd prefer a clean install as opposed to an upgrade. What would be the best way go about this? Is it as simple as booting to the new install and mounting the 12.04 VG? I suppose I'd have to manually set up LVM on 14.04 if I want to use the same hostname.

  Read the article

• iptables rule problem

  - by thakrage

  I've been searching around for some time now, but nothing solves my problem. I'm setting up a mail server, but when writing to the iptables, I get an error: iptables-restore: line 2 failed. I'm tryig to use the following /etc/iptables.test.rules: # Allows SMTP access -A INPUT -p tcp --dport 25 -j ACCEPT # Allows pop and pops connections -A INPUT -p tcp --dport 110 -j ACCEPT -A INPUT -p tcp --dport 995 -j ACCEPT # Allows imap and imaps connections -A INPUT -p tcp --dport 143 -j ACCEPT -A INPUT -p tcp --dport 993 -j ACCEPT After this, I'm issuing the following command: sudo iptables-restore < /etc/iptables.test.rules However I get returned this: iptables-restore: line 2 failed. I don't know what the problem is. Can anyone clarify? btw. I'm using Ubuntu 10.10 LTS

  Read the article

• How do I configure Mediawiki on EC2 if anonymous browsing is disabled?

  - by Feasoron

  So I have new MediaWiki instance install on a brand new Amazon EC2 instances. All is going swimmingly, until I have to log in via the web browser to configure it. Since I'm running on a hosted server, I can't hit http://localhost/mediawiki/config/index.php like the instructions say to. If I try to hit it via http://<My IP address>/mediawiki/config/index.php, my browser just tries to download the file because anonymous browsing isn't enabled. I seem to be before LocalSettings.php is created, so I don't know how to move forward from here.

  Read the article

• Using multiple servers for hosting [on hold]

  - by foo

  I need help understanding the concept of using multiple servers (for hosting at home). More specifically multiple WAMP servers. (I have tried looking online but have found no good resources, maybe i am searching for for the wrong things to answer my questions) Questions -How do multiple servers work together? -Do they all have their independent hard drives storing different information? and if so, does the server dynamically locate files? -How do shell commands get executed? -How do they share the "load"? i.e. processing power, resources? Please tag links to resources so i may use a reference. Cheers!

  Read the article

• Active GridLink for RAC???????? NEC??????/???????! ????

  - by ???02

  ????????????????·????????????WebLogic Server 12c?????????1???Oracle Database????????????Oracle Real Application Clusters(RAC)??????????????Active GridLink for RAC?????????????WebLogic Server 12c???????????NEC??????????????????????????????????????????NEC ??IT??????????????????????????????????????(???) NEC?Active GridLink for RAC????????? NEC ??IT????????? ????? WebLogic Server?????WebLogic Server 12c?????Oracle RAC?????????????????????????????????????1??????????Active GridLink for RAC??Active GridLink for RAC??RAC?????????????????????????????????????????????????????·???????????????????????????·???????????????????????????? ???????????????????????????????????????????????????????WebLogic Server 12c?Oracle RAC??????????????????·??????????????????????????????????? ??????Active GridLink for RAC??????????????????????????????????????????????WebLogic Server????????????NEC???? NEC????????WebLogic Server???Fusion Middleware?????Oracle Database????????????????????????????????????????????????????????????????????NEC?2012?????????Partner of the Year(????)??3?????????????????????? Active GridLink for RAC?Oracle RAC??????????????????????????????????2????????????????NEC?????????NEC??WebLogic Server?????????????????????????????????????????????????????????????????????????????????????WebLogic Server?Oracle Coherence?JRockit??Fusion Middleware??????????????????????????????????????????????????????Active GridLink for RAC?????????????????????????? Active GridLink for RAC???????????????NEC????????????????SIer?????????????????????????????????????????????? Active GridLink for RAC????????????? ???????????????????????????????·?????????FCF(????????????)????? Active GridLink for RAC???????????????????1????????????????????????????????????1???????????????GridLink????????????????????????????????????????????1???????????????????????????????????????GridLink??????????????????????????? ???Active GridLink for RAC???RAC???????????????????????????????????Oracle Notification Service(ONS)???????????????????·??????????/?????DOWN/UP???????????????????????RAC??????????????????WebLogic Server????????????????ONS???????????????????????????????????????????1??????????FCF????·????????????????????????????????????????????? ??????2???RAC?2???WebLogic Server?????????????????????4???RAC?????????????????????????????????? ??????????????5????? (1)??????????·??????(RCLB) (2)Web?????·?????? (3)???RAC??????/?? (4)????????????(FCF) (5)GridLink????????????? ??????????????????????????????? (1)??????????·??????(RCLB) ??????????·??????(RCLB)???????????????????????????????????????????????????·??????????????????????????????????????????(CLB)????????????RCLB????????CLB???????????????????????? RCLB?????????Oracle RAC?????????????????(?????·??????????)????????????????????????????????????????????????????????????????·???(SERVICE_TIME)?????????1???????????????RAC????????????????????????(THROUGHPUT)???????1?????????·??????????RAC?????????????????????????? ????????????RCLB??????????????????????????(????????????????????????????????)?????????????3?????????????? ??1-a:???????????????????????? ??1-b:???????????????????????????1-c:???????????????????? ??????????????????????? ??????1-b????1-c?????????????????????????????????RCLB???????????????????????????????????????????????????????????????????????????????????????????CPU???????????????RCLB??????????????????????????? ??????????????RCLB???????????????????????????????????Oracle Database??????????CPU???????????????????????????CPU???????????????CPU?????????????????????ELAPSEDPERCALL?CALLSPERSEC???????????????????????Oracle Database??????????????????????????????????RCLB?????????????????????????????????????????? RCLB???????????????????????????FAN???????????????????Oracle RAC???????????????????????????RAC??????????????????????????????????????????????????RCLB??????????????????????????????????????????????????????????????????????????????????????????????????????????????? (2)Web?????·?????? Active GridLink for RAC?Web?????·????????Oracle RAC?????????????·?????????????????????????????????·???????????????????????????????????????? Web?????·????????HTTP?????????????????????/?????????????????????????????????????????????????????2???RAC?4???RAC?????????????·????????????????????????????????????????? ???????????RCLB??????·??????????????????·???????????????????????????????????????????????????????? ??????Web?????·?????????????????·???????????????·???????????????????????????????????????????????????????·????????????????????????????????RCLB???????????????????????????????????WebLogic Server??????????????????????·??????????1??????????????????????·?????????????????????????????? ??????NEC?????Active GridLink for RAC??????????????????????·??????(RCLB)?Web?????·??????????????????????????????RAC??????/?????????????????(FCF)???GridLink????????????????????????????

  Read the article

• ????????SPARC????? ?OVM???????!

  - by Yusuke.Yamamoto

  ????? ??:2010/10/26 ??:?????? SPARC ???????????????????????·??????????????!????????SPARC CMT ????? Solaris ?????????????????? Oracle VM Server for SPARC(?? Logical Domains:LDoms)????????????????????????? Oracle ??????/ Oracle Virtualization Strategy?Only From Oracle?Oracle ?????????????Oracle VM for SPARC ????/ Oracle VM for SPARC?Release History?Key Components?SPARC Enterprise T / SPARC T3?????System Firmware?Oracle Solaris?Logical Domains Manager??????????Oracle VM for SPARC???????!/ ???????(????)?????????ldm?????Configuration Assistant?Logical Domains P2V?????????? ????????? ????????????????? http://www.oracle.com/technology/global/jp/ondemand/otn-seminar/pdf/1026_OVMforSPARC_Rev02.pdf

  Read the article

• SQL Server CLR stored procedures in data processing tasks - good or evil?

  - by Gart

  In short - is it a good design solution to implement most of the business logic in CLR stored procedures? I have read much about them recently but I can't figure out when they should be used, what are the best practices, are they good enough or not. For example, my business application needs to parse a large fixed-length text file, extract some numbers from each line in the file, according to these numbers apply some complex business rules (involving regex matching, pattern matching against data from many tables in the database and such), and as a result of this calculation update records in the database. There is also a GUI for the user to select the file, view the results, etc. This application seems to be a good candidate to implement the classic 3-tier architecture: the Data Layer, the Logic Layer, and the GUI layer. The Data Layer would access the database The Logic Layer would run as a WCF service and implement the business rules, interacting with the Data Layer The GUI Layer would be a means of communication between the Logic Layer and the User. Now, thinking of this design, I can see that most of the business rules may be implemented in a SQL CLR and stored in SQL Server. I might store all my raw data in the database, run the processing there, and get the results. I see some advantages and disadvantages of this solution: Pros: The business logic runs close to the data, meaning less network traffic. Process all data at once, possibly utilizing parallelizm and optimal execution plan. Cons: Scattering of the business logic: some part is here, some part is there. Questionable design solution, may encounter unknown problems. Difficult to implement a progress indicator for the processing task. I would like to hear all your opinions about SQL CLR. Does anybody use it in production? Are there any problems with such design? Is it a good thing?

  Read the article

• SQL Server, how to join a table in a "rotated" format (returning columns instead of rows)?

  - by Joshua Carmody

  Sorry for the lame title, my descriptive skills are poor today. In a nutshell, I have a query similar to the following: SELECT P.LAST_NAME, P.FIRST_NAME, D.DEMO_GROUP FROM PERSON P JOIN PERSON_DEMOGRAPHIC PD ON PD.PERSON_ID = P.PERSON_ID JOIN DEMOGRAPHIC D ON D.DEMOGRAPHIC_ID = PD.DEMOGRAPHIC_ID This returns output like this: LAST_NAME FIRST_NAME DEMO_GROUP --------------------------------------------- Johnson Bob Male Smith Jane Female Smith Jane Teacher Beeblebrox Zaphod Male Beeblebrox Zaphod Alien Beeblebrox Zaphid Politician I would prefer the output be similar to the following: LAST_NAME FIRST_NAME Male Female Teacher Alien Politician --------------------------------------------------------------------------------------------------------- Johnson Bob 1 0 0 0 0 Smith Jane 0 1 1 0 0 Beeblebrox Zaphod 1 0 0 1 1 The number of rows in the DEMOGRAPHIC table varies, so I can't say with certainty how many columns I need. The query needs to be flexible. Yes, it would be trivial to do this in code. But this query is one piece of a complicated set of stored procedures, views, and reporting services, many of which are outside my sphere of influence. I need to produce this output inside the database to avoid breaking the system. Any ideas? This is MS SQL Server 2005, by the way. Thanks.

  Read the article

• Can Sql Server 2005 Pivot table have nText passed into it?

  - by manemawanna

  Right bit of a simple question can I input nText into a pivot table? (SQL Server 2005) What I have is a table which records the answers to a questionnaire consisting of the following elements for example: UserID QuestionNumber Answer Mic 1 Yes Mic 2 No Mic 3 Yes Ste 1 Yes Ste 2 No Ste 3 Yes Bob 1 Yes Bob 2 No Bob 3 Yes With the answers being held in nText. Anyway what id like a Pivot table to do is: UserID 1 2 3 Mic Yes No Yes Ste Yes No Yes Bob Yes No Yes I have some test code, that creates a pivot table but at the moment it just shows the number of answers in each column (code can be found below). So I just want to know is it possible to add nText to a pivot table? As when I've tried it brings up errors and someone stated on another site that it wasn't possible, so I would like to check if this is the case or not. Just for further reference I don't have the opportunity to change the database as it's linked to other systems that I haven't created or have access too. Heres the SQL code I have at present below: DECLARE @query NVARCHAR(4000) DECLARE @count INT DECLARE @concatcolumns NVARCHAR(4000) SET @count = 1 SET @concatcolumns = '' WHILE (@count <=52) BEGIN IF @COUNT > 1 AND @COUNT <=52 SET @concatcolumns = (@concatcolumns + ' + ') SET @concatcolumns = (@concatcolumns + 'CAST ([' + CAST(@count AS NVARCHAR) + '] AS NVARCHAR)') SET @count = (@count+1) END DECLARE @columns NVARCHAR(4000) SET @count = 1 SET @columns = '' WHILE (@count <=52) BEGIN IF @COUNT > 1 AND @COUNT <=52 SET @columns = (@columns + ',') SET @columns = (@columns + '[' + CAST(@count AS NVARCHAR) + '] ') SET @count = (@count+1) END SET @query = ' SELECT UserID, ' + @concatcolumns + ' FROM( SELECT UserID, QuestionNumber AS qNum from QuestionnaireAnswers where QuestionnaireID = 7 ) AS t PIVOT ( COUNT (qNum) FOR qNum IN (' + @columns + ') ) AS PivotTable' select @query exec(@query)

  Read the article

• How do you concat multiple rows into one column in SQL Server?

  - by Jason

  I've searched high and low for the answer to this, but I can't figure it out. I'm relatively new to SQL Server and don't quite have the syntax down yet. I have this datastructure (simplified): Table "Users" | Table "Tags": UserID UserName | TagID UserID PhotoID 1 Bob | 1 1 1 2 Bill | 2 2 1 3 Jane | 3 3 1 4 Sam | 4 2 2 ----------------------------------------------------- Table "Photos": | Table "Albums": PhotoID UserID AlbumID | AlbumID UserID 1 1 1 | 1 1 2 1 1 | 2 3 3 1 1 | 3 2 4 3 2 | 5 3 2 | I'm looking for a way to get the all the photo info (easy) plus all the tags for that photo concatenated like CONCAT(username, ', ') AS Tags of course with the last comma removed. I'm having a bear of a time trying to do this. I've tried the method in this article but I get an error when I try to run the query saying that I can't use DECLARE statements... do you guys have any idea how this can be done? I'm using VS08 and whatever DB is installed in it (I normally use MySQL so I don't know what flavor of DB this really is... it's an .mdf file?)

  Read the article

• How can I test this SQL Server performance Utility?

  - by Martin Smith

  As part of my MSc I need to do a three month project later this year. I have decided to do something which will likely be useful for me in the workplace and spend the time getting to understand SQL Server internals. The deliverable for this project will be a performance advisor looking at a variety of different rules. Some static such as finding redundant indexes, some more dynamic such as using XEvents to find outlying invocations of stored procedure execution times when certain parameters are passed. I am struggling to come up with a good way of testing this though. I can obviously design a "bad" database and a synthetic workload that my tool will pick up issues on but I also need to demonstrate that it has real world utility. Looking at the self tuning database literature it is common to use TPC benchmarks but I've had a look at the TPCC site and it looks very time consuming to implement and not that good a fit to my project's testing needs in any event (I would still be able to "rig" it by the decisions I made on indexing or physical architecture). Plan A would be to find willing beta tester(s) but in the event that isn't possible I will need a fallback plan. The best idea I have come up with so far is to use the various MS sample applications as examples of real world applications. e.g. http://msftdpprodsamples.codeplex.com/ http://www.asp.net/community/projects/ Does anyone have any better suggestions?

  Read the article

• SQL Server 2008: Comparing similar records - Need to still display an ID for a record when the JOIN has no matches

  - by aleppke

  I'm writing a SQL Server 2008 report that will compare genetic test results for animals. A genetic test consists of an animalId, a gene and a result. Not all animals will have the same genes tested but I need to be able to display the results side-by-side for a given set of animals and only include the genes that are present for at least one of the selected animals. My TestResult table has the following data in it: animalId gene result 1 a CC 1 b CT 1 d TT 2 a CT 2 b CT 2 c TT 3 a CT 3 b TT 3 c CC 3 d CC 3 e TT I need to generate a result set that looks like the following. Note that Animal 3 is not being displayed (user doesn't want to see its results) and neither are results for Gene "e" since neither Animal 1 nor Animal 2 have a result for that gene: SireID SireResult CalfID CalfResult Gene 1 CC 2 CT a 1 CT 2 CT b 1 NULL 2 TT c 1 TT 2 NULL d But I can only manage to get this: SireID SireResult CalfID CalfResult Gene 1 CC 2 CT a 1 CT 2 CT b NULL NULL 2 TT c 1 TT NULL NULL d This is the query I'm using. SELECT sire.animalId AS 'SireID' ,sire.result AS 'SireResult' ,calf.animalId AS 'CalfID' ,calf.result AS 'CalfResult' ,sire.gene AS 'Gene' FROM (SELECT s.animalId ,s.result ,m1.gene FROM (SELECT [animalId ] ,result ,gene FROM TestResult WHERE animalId IN (1)) s FULL JOIN (SELECT DISTINCT gene FROM TestResult WHERE animalId IN (1, 2)) m1 ON s.marker = m1.marker) sire FULL JOIN (SELECT c.animalId ,c.result ,m2.gene FROM (SELECT animalId ,result ,gene FROM TestResult WHERE animalId IN (2)) c FULL JOIN (SELECT DISTINCT gene FROM TestResult WHERE animalId IN (1, 2)) m2 ON c.gene = m2.gene) calf ON sire.gene = calf.gene How do I get the SireIDs and CalfIDs to display their values when they don't have a record associated with a particular Gene? I was thinking of using COALESCE but I can't figure out how to specify the correct animalId to pass in. Any help would be appreciated.

  Read the article

< Previous Page | 566 567 568 569 570 571 572 573 574 575 576 577  | Next Page >