Home Forums SQL Server 2008 SQL Server Newbies query to search RE: query to search

  • June 3, 2013 at 6:43 am

    #1620515

    Rauf Miah (6/3/2013)

    I have a table with fields and data type like

    companycode [nchar(4)] actcode [nchar(12)] vounum [nchar(14)] trnam [decimel (18,6)]

    I like to build a query which will bring almost 900 rows

    and build query like

    select comcod, actcode, vounum,trnam where comcod=3305 and

    vounum in ('BC201203000073',

    'BC201204000001',

    'BC201204000002',

    'BC201205000001',

    'BC201206000001',

    'BC201206000002') ----------Here I would like to put 900 (nine hundred) vounum data and run the query, the

    problem is data type. It is time consuming to edit every data by putting ' ' and append coma (,) for every vounum. Is there any way to paste the vounum without putting single quote ' vounum ' and appending a coma (,) for every vounum and successfully run the query.

    You're copying and pasting vounum from a source into an SSMS window. What is the source? There are numerous tricks to make this easier, depending upon the source.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden