I work for an insurance agency that needs to run a multitude of checks on
applications when they are added to our database.  A large union query in a
stored procedure works just fine, but is slow.  I want to create a temp
table, transfer the data into it, then run the union query ...

Hello.. I'm trying to convert a numeric value to a monetary format. Take my
query "Select 1000 As MyNumber" for example. This obviously returns 1000. I'd
like to return $1,000. When I run "Select Convert(Money,1000) As MyNumber",
it still returns 1000 (no commas or $). Any ideas? ...

I'm just curious - is there a (preferably free but if needs be my company
will have to pay) web front end (much like Web Data Administrator) for
Analysis Server?
I've searched high and low and I've heard of Digial Dashboard but I can't

Can some one give me a brief list of data mining techniques and when they
are useful. Please if you can keep it basic. Im not very Bright

I am trying to manipulate data before it is inserted into a column.  For
instance
I am reading in a MAC addreess which looks like '00DE0B16AA99'  and when I
do an insert into the column I want it to be '00:DE:0B:16:AA:99'  In other

This looks simple but I can't figure it out.
If there's a n-n relationship between two tables, how can I find all records
in the first table that are linked to all records of the second table.
For Example:

Can any one tell me how I choose a data mining technique
Does anyone have examples of when they think they have applied the wrong
tecnique

I have two tables (tblPOLICIES and tblCLAIMS) from which I need to extract
the following information: Total active policies and their related claims.
If in a query I sum all active policies.
SELECT     COUNT(POLICY_ID) AS T_Policies

Hi Jamie MacLennan ,
         Can i use PMML for connecting to analysis server 2000.I have a
decision tree.But i dont know xml.Can i use PMML for creating a web
based application.If so please tell me how should i proceed.Please tell

Can anyone recommend a good book on SQL Server 2000 Analysis Services and
data mining techniques. I have used SQL database for a while now, but i am
totally new to data mining and analysis services. Will it let me to things
like projections & forecasts based on historical ...

I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
@String = 'word1word2word3word4word5' - This value is passed to Stored
Procedure from the script.
Column1 in a table1 has many rows with "words" . One row in this column1

Please could some one tell me of a good web source that would help get an
introduction to the data mining techniques and when they are supposed to be
used

i am using sql server 2000 and have already generated a decision tree
using Analysis Manager Decision Tree Mining Model approach. I wanted to
know the different ways in which the user can use the rules of the
mining model to do some prediction which the above mentioned server

Hi Jamie MacLennan ,
            Thanks for helping me....I have one more question..I have
just created the tree using decision algorithm.I have not formed the
cube.....should i form a cube compulsorily for doing a predicting

Hi Jamie MacLennan ,
Hi,
       I have a question???The name of my model is intrusion(name of
the decision tree