Results 1 to 3 of 3

Thread: IN query

Threaded View

  1. May 11th, 2006, 03:56 AM #1
    skyseh
    skyseh is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2002
    Posts
    69

    IN query

    Hi All,

    How can I better replace the IN(....) to a better code?

    SELECT TOP 1 MIN(table.Item), MIN(table.Post), MIN(table.add), MIN(table.creator), MIN(table.datecreated) FROM table WITH (NOLOCK) WHERE table.code IN('0012','0013','0014').

    The above has causes some performance and system run time error issue especially within the IN bracket the table code gets very large. Please advise.

    Thanks.
    Last edited by skyseh; May 11th, 2006 at 04:16 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