Yes, I do have some fields with the middle intial. How do I handle that?

Ok, that works for one name. I have a table with over 56,000 records that need the name separated. How do I do this with the entire table?

I am using SQL Server 2000. This query appears to work in SQL 2005 - what can I do to convert this query to SQL 2000?

Thanks for your help!

I am using SQL Server 2000 and it does not like the ROW_NUMBER syntax. Is there something else that I can use?

This did not work. Basically I am trying to calculate each minute of an employee time during their work shift. In the table above shows only the times...

SELECT

user_key AS User_id,

update_date AS createDate

FROM ...

SELECT billingcarriers.description, orders.orderid, orders.orderdate, orders.patientid,

sum(ocv1.amount) retail, sum(ocv1.amount) cost,

sum(ocv1.amount * -1)...

select EMPNO, sum(HRS_WRKD), PAYCODE_NAME

from tablename

group by EMPNO, PAYCODE_NAME

Try this query.

SELECT DISTINCT EA_ID, EA_ACC_ID, EA_LEA_ID, EA_DM_ID, EA_SCR_ID, EA_LD_ID, EA_LLT_ID, EA_LFTY_ID, EA_ADDRESS,

(SELECT COUNT(ER_ID) FROM EMAIL_RETURN WHERE ER_STATUS = 'A' AND ER_ADDRESS = EA_ADDRESS

AND CONVERT(VARCHAR(19),ER_DATE_INSERTED,120) >= '2008-03-27 10:43:04'),...