Give this a shot:

with LatestInfo as (

select

[Name],

max([DateTime]) as [DateTime]

from

dbo.MyTable

group by

[Name]

)

select

mt.*

from

...

with EmailRecords as (

select

row_number() over (partition by Emailaddress order by Id desc) as RowNumber -- Assuming Highest Id is most recent

Id,

...

If you are using a named instance, you probably aren't connecting to port 1433. You may want to check the firewalls on the client sides as well.

Depending on your experience, the Wrox book Professional SQL Server Integration Services 2005 was the book I purchased and used when I started working with SSIS.

Best thing you can do...

Please read the first article I reference below regarding asking for help.

Ut would greatly help us in helping you if you would post the DDL for your table, sample data...

Edit: Sorry, wrong thread....

Can you provide a partial DDL for the table, primary key(s) and e-mail columns, and some sample data for the table. Also, how do you want to identify which...

nigel. (11/20/2009)

---

Talking of splitting. I'm surprised nobody has commented on this and it's use of recursive CTEs.

String Splitting[/url]

Needs to be shown the error of his ways 🙂

I would, but don't...

Not a bad solution but using a recursive CTE and a multi-statement TVF this function is not very scalable.

Here is another solution to this problem:

CREATE function [dbo].[DelimitedSplit] (

...

aaz (11/20/2009)

---

>>Note that in the discussion, there are a number of comments on the question prior to it being edited. Please understand the idea of the question is to understand...

Here is my shot at what you need.

select

om.Name,

ISNULL(pitem1.RehabTypeID, pitem1.StaffID) as Player1,

ISNULL(pitem2.RehabTypeID, pitem2.StaffID) as Player2

from

dbo.OptionsMapping...

A network person I am not, however, this looks like a netwrok issue. Please remember, I consider everything from the network card in the desktop to the network card...

I think it would help to see the whole error message. There may be other messages that will help determine what occurred.

You have to decide which you want to do. Issue with direct to tape, one it is slower than direct to local disk. Two, if you have a...

This is a might broad topic to cover. A general answer is yes, there is a way to change the isolation level within a procedure. This, of course,...