Trickey (for me) SQL problem

Results 1 to 2 of 2

Thread: Trickey (for me) SQL problem

  1. #1
    Join Date
    Dec 1969

    Default Trickey (for me) SQL problem

    Is there an easy way to take the top 50 statements from a database sorted by DATE (ie the 50 earliest entries) then sort those 50 entries based on a different field, say "Name"? I think I need to use embedded SQL or something, if you know of a good online sql resource I would be greatly appreciative,<BR>thanks,<BR>Justin

  2. #2
    Join Date
    Dec 1969

    Default RE: Trickey (for me) SQL problem

    I think you can just create stored procedure and call it...<BR>e.g. sp_date will return 50 last entries:<BR>select * from table where entrydate &#062;= convert(varchar,getdate()-50,101)<BR>date format here 11/29/00<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts