MSSQL Limit! Time out

Results 1 to 2 of 2

Thread: MSSQL Limit! Time out

  1. #1
    Rob Guest

    Default MSSQL Limit! Time out

    I have a SQL string that goes like this<BR><BR>select * from users where zipcode IN (31410,90210,....) <BR><BR>There are 1200 zipcodes which equal 7200 Characters which will brak MSSQL. Thats when I get a timeout. Anyone know of a workaround?

  2. #2
    Join Date
    Dec 1969

    Default I'd hate to debug that query

    1200 zips in an IN clause? There isn&#039;t a possiblity to break this down a bit more?

Posting Permissions

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