Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottishcalvin
Starting Member
10 Posts |
 Posted - 2010-03-10 : 10:54:01
|
| Ok, I've known SQL a few weeks now through excel; pulling in numbers, aplpying filters, logic etc. This all comes from a server with companywise figures. However, the data entry application also stores other datafields on a seperate server (which I can see in that query loader) and I really want to pull through the text summary for each entry in the system (so that I can have a double-click pop-up window in Excel). My thinking is I could do two queries and merge the data in Excel care of VBA and matching the reference numbersI know that the text entry must be stored somewhere on that server except that there's hundreds (maybe 1000+) tables and I obviously don't want to try finiding it brute force style. Is there some way of pulling through any data where the entries are 100+ characters long and logging the table things were found in? My gut feeling is that this is a more fancy or top-down expansion of WHERE or the like |
|
|
|
|
|
Tracking down a text summary entry