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

Posted on 2006-05-26
Last Modified: 2008-03-06

I request the moderator to pin this message.

I have seen many people post all useless stuff and fail 2 desc the actual problem..
this may be helpful...

any suggestions are welcome
Question by:pai_prasad
    LVL 10

    Author Comment

    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)


    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


    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

    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.
    LVL 65

    Expert Comment

    by:Jim Horn
    Is this a question?
    LVL 10

    Author Comment

    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...

    Accepted Solution

    PAQed with points refunded (20)

    Community Support Moderator

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now