how to ask a question:----->> some hints... moderator

Please state your problem in the context of a business requirement. Please do not force a narrowly focused technical solution, which may or may not be of any value.


It may also be a distraction to what the actual solution would be. To aid in the solution please do the following if possible

1. State the question

"How do I find the earliest row entered"

2. Please post the DDL of your tables (Including Indexes, and constraints)

Like

CREATE TABLE myTable99(Col1 int IDENTITY(1,1), Col2 char(1), Col3 datetime, PRIMARY KEY (Col1))

3. Post some sample data in the form of DML

Like

INSERT INTO myTable99(Col2, Col3)
SELECT 'a', '01/01/2005' UNION ALL
SELECT 'b', '02/01/2005' UNION ALL
SELECT 'c', '03/01/2005'

4. Post whatever DML that you have attempted already...

SELECT * FROM myTable99 a CROSS JOIN myTable99 b

5. Post the expected results


Code:
Col1        Col2 Col3                                                  
----------- ---- ------------------------------------------------------
1           a    2005-01-01 00:00:00.000
Good Luck. If these instruction are followed, you will most likely get an answer in minutes.

And don't forget to use [ code] [ /code] tags when posting code, just eliminate the spaces I have used here.


EDIT: A FAQ Section

Q: How do I create DDL as requested in step 2?

A: 1. Go to Enterprise Manager.

2. Open the database folder to display all of the tables.

3. Right Click on the table you want.

4. Choose Menu options All Tasks>Generate SQL Scripts

5. Look at the dialog, there are three tabs. Make sure you pick all the correct options (indexes, keys, ect)

6. Click Preview.

7. Copy and paste the code.

Is this a question?

no this aint a question....
this is a suggestion for some1 who wants to ask questions...
i didnt know how to share this info so posted as a question...