SELECT a.GROUPNUMBER, a.SSN,

ISNULL(b1.FIRSTNAME, b.FIRSTNAME) AS FIRSTNAME,

ISNULL(b1.LASTNAME, b.LASTNAME) AS LASTNAME

FROM tblNewData a

LEFT OUTER JOIN tblExistingData b1

ON b1.GROUPNUMBER =...

I've always used this method:

SELECT a.*, b1.*, b.*

FROM tblNewData a

LEFT OUTER JOIN tblExistingData b1

ON b1.GROUPNUMBER = a.GROUPNUMBER AND b1.SSN = a.SSN

LEFT OUTER JOIN tblExistingData b

ON a.GROUPNUMBER =...

What have you done so far? Even if this is homework you may still get help with it, especially if you can demonstrate a willingness to do at least some...

So what? We've known for years that the answer is 42.

Your output list includes a column with an alias not used in the query (which uses aliases a, g and h):

SELECT a.IPEquipmentID IPEquipmentDataRowID, a.IPEquipmentName, a.IPEquipmentTypeID,

g.ManagementIPAddress, g.VoiceIPAddress, p.HDFReference,

h.IPTVStateID as...

sandy-833685 (12/18/2009)

---

Its a simple insert statement Its not possible for me to insert inverted commas for each statement, you can go through the sample data

common understanding is i am having...

Sandy, please review and adjust the following sample code to match your sample data.

CREATE TABLE #Sample (Col1 CHAR(3), Col2 VARCHAR(60), Col3 VARCHAR(60))

INSERT INTO...

Restate your requirements - this is a very straightforward query.

ningaraju.n (12/18/2009)

---

In my examples there are two groups

Group1: Java,Perl

Group2: Java,PHP

If an Candidate has both java and perl knowledge and then he has the full knowledge of Group1 then he...

ningaraju.n (12/18/2009)

---

In my examples there are two groups

Group1: Java,Perl

Group2: Java,PHP

If an Candidate has both java and perl knowledge and then he has the full knowledge of Group1 then he...

Can...

Must a winner have all the skills of the group?

Here's one way to do it - I suspect the performance would really suck on a large data set though.

SELECT pt.dtCheckIn, pt.dtCheckOut, pt.sGuestFName, pt.sGuestLName, ct.*

FROM (

SELECT CurrentID =...

I'd go along with Jack on this one.

What do you want your output to look like, using the sample data you've provided?