Wherever you heard that....but I am not talking about INDEXING.....I'm talking about maintaining a table as an...

I thought the OP wants the previous date for the "Latest" test date. The latest test date not only in this case but in all cases will be the top...

The values keep changing because of the JOIN itself. The values must be getting filtered further because of the JOIN with #table4.

If you want all the data from the result...

Would this work?

SELECT TOP 1 test_date

FROM (

SELECT DISTINCT TOP 2 test_date

FROM datetest

ORDER BY test_date DESC) a

ORDER BY test_date

Sure does Dwain....:-)

+1 Dwayne....that sure is worth the +1

Why don't you keep an Index Table where you can store all the Customers and the names of the Databases of the respective Customers?

Then you can create a Stored Procedure...

These are the things I wanted it to do

1. I wanted the old record in SMARTAdmissions table to be deleted as the upload process start

2. then as data are added...

vicdileo (4/24/2012)

---

Hi asranantha,

1) please supply the full CREATE TABLE sql (including table name) of both tables.

2) how is the data being copied? Using SQL? Using a tool? Please...

Yes...thats right.

No loops! No CURSORs! No RBAR! Hoo-uh!

MAAAAN!!!!...He really knows it all....lol

+1 SQLKnowItAll....I agree.

Eugene Elutin (4/24/2012)

---

You can create unique index (or unique constraint) on username....

You're welcome.

Yes. Seems like the only way to do "WHERE column = anything" is using a temporary variable ie: "WHERE column = @anything".

Can't think of anything else until the OP clarifies...

Excellent Allen....it was as simple as that :laugh: