Looking at BULK INSERT in BOL (Books Online, the SQL Server Help System), it appears that to accomplish what you are trying to do you will need to use dynamic...

Agree, I must. Need DDL for the table, sample data, and expected results based on sample data.

Follow the instructions in the article that Bru provided (also happens to be...

rparakalla (11/20/2009)

---

Lynn Pettis (11/20/2009)

---

aaz (11/20/2009)

---

>>Will all these statements (...) return an equivalent date, hour, minute and second <<

Actually it did, if you take into account the time zones, and adjust...

aaz (11/20/2009)

---

>>Will all these statements (...) return an equivalent date, hour, minute and second <<

Question was about "date, hour, minute and second" returned by the statements, not about "moment in...

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...