Here's what I'd do next (assumes you have primary key on the source table):
[font="Courier New"]CREATE TABLE logins
(
pk datatype,
lastlogon bigint
)
INSERT INTO logins
SELECT TOP 50%
A.pk,
A.laslogon
FROM
TABLE A LEFT JOIN
logins L ON
A.pk = L.pk
WHERE
L.pk IS NULL
SELECT
lastlogon
FROM
TABLE
WHERE
ISNUMERIC(lastlogon) <> 0[/font]
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question