• At my company we run into "requests" like this all the time.  Us lowly developers don't have the right to create jack in the production database but the data results the business unit wants come from there.  Our normal solution is to use Excel.  In a Query analyzer window we'll do a create table statement to create a temporary table to hold the data, in this case "create table #tmp (cust varchar(5))"

    We'll have a list of clients sent to us in Excel or a text file.  Opening the attachment in Excel.  We'll insert a blank column in front of the data column and define a formula as ="insert into #tmp values('" & A2 & "')"  Copy the formula in A1 to the entire A column.  Copy the column and do a Past...Special...Values.  Copy the column of insert statements into QA and run.  Now you have a temp table in a QA session you can join to the data in the database and use in whatever ways one needs.

    We deal with payroll data for millions of people employed throughout the country and it is not uncommon to get a request to pull demographic info on 10-20K people at a time for some report or another.  This method makes these requests trivial to handle.


    Shuffle Up and Deal!