foxjazz,

You post the DDL for your tables, which is good. What you also need to do is post the SQL code you are writing and having difficulty with, not...

Roy Ernest (3/24/2009)

---

Hahahaha Lynn, Maybe you should not have put Drop Table statements in the end. :hehe:

Maybe you should edit your post and state that you should not use the...

Is it me or are the people we are trying to help just getting dumber, or do we need to start commenting are code a lot more heavily?

You don't need to use the INSERT statements. Those were there to load the test table (dbo.TestTab1) with data, which was then used to load dbo.TestTab2 with the same...

As I said before, we need the DDL (CREATE TABLE statement) for the table, sample data for the table (formated as INSERT statements so we may cut, paste, and run...

suhailquadri (3/23/2009)

---

Hey,

following expects to display distinct rows but it is not.. can any body help me out..

TID datatype is integer

SELECT distinct TID, EID, ENAME, EDATE, UID, EISSUCCESSFUL, EREMARKS

FROM ...

Here is some test code for you to start with and it does it all in T-SQL, not SSIS:

-- Create initial test table that will be the source data

create table...

Jack Corbett (3/23/2009)

---

And what's your definition of short? Even though I'm...

You are missing the "end" for the case statement in your original code.

try one of these:

select

(case when (leavedate is null)

...

True, but for me there are three seasons of soccer, Fall, Spring, and Tournament with a definate break in there to relax. I haven't done indoor soccer and I...

Steve Jones - Editor (3/23/2009)

---

Lots of soccer talk, and good to talk to. Hopefully...

foxjazz, I am more than willing to help here, but I am not writing a line of code without the sample data and expected results. I need something to...

Linson.Daniel (3/23/2009)

---

Hey FoxJazz,

I couldnt really read through all the posts..but from what I have understood , ur requirment seems to be that from the set of records having the same...

Good, but still lacking. Some sample data and expected results would be the icing on the cake. That would allow us to validate our code before posting back.

Please...

RBarryYoung (3/23/2009)

---

So what's Lynn really like in person? Can you actually see the...