MH... seriously... just tell me what the PK of the table is...

Also, still need to know the PK of the table for the highspeed Tally table solution...

Mh (2/27/2008)

---

No it's not consistent, but most of the times it's either:

1. lastname, firstname MI

2. Lastname, Firstname, MI

There are some data issues, just for now let's consider the above...

Heh... it's real tough when the OP doesn't have a clue what they want... here's what he posted just before his edit for names...

NYSTROM, GRAHAM, A

CLOSSON, SEAN T

MOORE, AMANDA

In any...

Have you tried anything on your own??? Have you looked into CHARINDEX or PATINDEX?

Ummm... the example I posted is pretty clear... I'm thinking that you should be able to cut and paste a couple of table and column names on your own...

Sure... create a file called "CR.txt" and store a single blank line in it. Almost any editor including NotePad can do this just by opening a new file, pressing...

Ummm... neither is Model...

kurraraghu (2/27/2008)

---

declare @dt datetime

set @dt = '1900-01-1 00:00:00.000'

select cast(@dt as float)

----------------------

0.105555555555556

(1 row(s) affected)

here how is the time calculate is it seconds of the day or milliseconds smthng like...

Actually, it's stored as a "fixed place float"...

Then, most likely, the last row does not have a final row termination character... a very common mistake. I don't know enough about DTS to force it to load,...

Could be the code or could be missing the final line terminator in the data. Dunno because you've posted neither...

Kenneth Wilhelmsson (2/27/2008)

---

Yep, what Jeff shows is basically what's left when you take out the isolation level and transaction handling code. You can also remove the (rowlock) hint, it's also...

77...

Heh,... yeah, coffee helps me too 😀 Thanks for the feedback, Adam...