Good day
I have a table in SQL with the following columsn in it
Column A         Clumn B
6000                  4

I need to provide a pull-down that combines names from two different tables,
but I don't want to change the contents of either table. I want to combine
the the contents of a UnitPersonnel table and a NonUnitPersonnel table into a
Personnel_V view like this:

Am I right to say that DTS in SQL2k is unable to process data
predictions for data models constructed from OLAP cubes? I'm trying
find out if its possible to schedule a Data Mining Prediction Task for
a Mining Model constructed on a cube, but the option to choosing these

Hello people!
How are You?
Nice to meet you, my name is Marco.
I'm Italian from Rome!

I have a table that has a date/time field.  The field will consists of
either M/15/YYYY or M/LDOM/YYYY where LDOM = Last day of month.  I want to
run a query that will only pull information where date is greater that
M/15/YYYY.  I'm really new to SQL queries and I just don't know ...

We are creating a large table of company word/excel/text etc type of files
in them.  
What is the best/fastest way to (google) search for text in these various
documents?

I made a DM model in Analysis Manager. Then i can see it in DMSample, it's
OK. But then i delete it in Analysis Manager, it disapeard but in DM Sample
it's still accessible and i can see it 'Mining Models' box. Why ?
Then i made a model in DMSample with CREATE statement. It is ...

       i have a table which contains for arguments sake, beans -
   Table         Beans
                   BeanId
                   DecriptionId

Hi Fellows,
It's been quite sometime!
Please I need your help as regards SQL Server 2000's Analysis Manager.
After creating a mining model and browsing it, I want to generate a