Results 1 to 4 of 4

Thread: Help: Sql Query

Threaded View

  1. May 23rd, 2012, 08:21 AM #1
    Teckniel
    Teckniel is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    167

    Exclamation Help: Sql Query

    Hello.
    I have constructed a query that look for a certain status code between to times
    My Query is as followed

    Code:
    SELECT [ID],[NAME], [CELLNUMBER], [RECEIVED], [STATUS] FROM [Ctrack].[dbo].[POSLOG] WHERE CELLNUMBER=(SELECT Cellnumber FROM Ctrack.dbo.MobDat  where id='Duy') AND STATUS='18' AND [MTIME] BETWEEN ('1337578200') AND ('1337580000')  ORDER BY RECEIVED ASC
    What i want todo is get the next 20 records that come right after the result of the query or all grab all the records until it reaches code 143.

    my problem is i don't know where to start looking.
    Hope anyone can help

    Regards Me
    Last edited by Teckniel; May 23rd, 2012 at 08:26 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width