View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Weird SQL Question

You could build a query based upon that data, but it would be inefficient,
and the development time is just wasted.

Go back and argue the case for adapting the existing code, logically and
firm.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"simsjr" wrote in message
...
Ok, so my boss handed me a spreadsheet that contains about 1,000 records

as
retrieved by a SQL query.

My boss now wants me to run a query on ONLY the records given to me in the
spreadsheet. He wants me to grab two more fields of data for each of the
records in the sheet.

Naturally, my first question to my boss is, "Why don't you just give me

the
SQL code that was used for that query, and I'll just add a string or two

to
grab those additional fields? ...And then we'll run the new SQL?"

My boss says, "Isn't there a way to run a query on just the records I've
given you? Someone in another department has been able to do that before."

I've never heard of this. Can anyone provide insight into how I might
accomplish what my boss wants before I tell him he's full of crap?