Your expected results and ColdCoffee's are very similar.

Your results:

Day 1st shift 2nd Shift 3rd Shift

3/1 3 1 1

3/2 2 1 0

3/3 0 0 0

Cold Coffee's:

DayNumberFirstShiftEventCountMiddleShiftEventCountLateShiftEventCount

Day 1360

Day 2360

Day 3361

Why don't you...

Actually the late, middle and early sample data was not from the original poster. I was just trying to use my intuitive powers to provide some code that might be...

All depends on the consistency of your data.

I would import into a one coumn statging table.

Then update the data. This is really ugly, but it works.

CREATE TABLE TEST

(

String ...

Are you going to have data like this?

Ann Arbor MIMICHIGAN 48103 20080109

In this case the spaces are not really delimiting your fields.

If this is the case then the first...

Does this help?

CREATE TABLE Shifts

(

ShiftStart datetime

)

INSERT INTO Shifts

SELECT '2011-02-01 01:10:00.000' UNION

SELECT '2011-02-01 01:20:00.000' UNION

SELECT '2011-02-01 01:30:00.000' UNION

SELECT '2011-02-01 13:10:00.000' UNION

SELECT '2011-02-01 13:20:00.000' UNION

SELECT '2011-02-01 13:30:00.000' UNION

SELECT '2011-02-01 13:40:00.000' UNION

SELECT...

Do you want a count of each shift?

You have not provided a table structure, sample data and expected results. If you did we wouldn't have to guess. Here's a guess.

This...

Thanks, that looks good. I had never used PIVOT before.

Since you don't have a DBA, I have to ask this. Are you comforatable with your backup and disaster recovery processes?

I faced a similar issue recently and used a varchar field of a length that I though would accommodate all my results. I did have some reservations about this.

In my...

Yes, the granularity question is key. Even if you are stamping your datetime field with getdate() then its possible though unlikely you could get duplicates.

It sound like you have...

Hi, You probably don't want to go there as far as creating a custom key. Anyway you haven't convinced me that this is really necessary so I would try to...

Check the cluster logs, usually in C:\Windows\Cluster.

Do you get similar results when you use the tracert command to both the name and the IP?

You may be running into networking issues since replication has specific requirements.

http://support.microsoft.com/kb/164667

'Synching' data is often problematic although the available tools have come a long way.

Is there any way...

Thank you both. Each of these solutions looks viable.