[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2006-05-26
Medium Priority
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
  • 2
LVL 10

Author Comment

ID: 16772180
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 66

Expert Comment

by:Jim Horn
ID: 16772221
Is this a question?
LVL 10

Author Comment

ID: 16772381
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

GranMod earned 0 total points
ID: 16967765
PAQed with points refunded (20)

Community Support Moderator

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Suggested Courses

834 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