This is my complete query:
-------------------------------
SELECT b.fld_agent_nm, count(*) AS 'Offer',
SUM(CASE WHEN a.fld_call_status = 'Ansd' THEN 1 ELSE 0 END) AS 'Answd',

I have a table, with the following Fields and Values:
Table: Products
Fields: ProductNumber,Location, Quantity.
The product numbers can repeat, with different locations, and quantities.

Is there a way to restore/recover data from an earlier date if you donot have a backup. The data was accidentally deleted from a table
Thanks in advanc
Hugo

I am having a problem with using UDF as part of a temp table computed
column. Here's the sample code:
IF EXISTS( SELECT 1 FROM information_schema.routines WHERE routine_name =
'fn_test')

I am trying to defrag my Hard-disk drive. Windows 2000 Server does not
defrag my drice compoletely as major portion is occupied by my SQL database
whose size is around 2GB. The Defrag program on completion says that it
cannot defrag the SQL Database files.

In response to another post I was replied that Data Mining is not the
final destination for the world of BI and is rather just a tool to solve
the problem/get insight into the data.
My question,as silly as it may sound, is that what really is Data Mining

I find the data mining "dependency network" feature the most useful feature
of Analysis Services, and I'm wondering if there's a way to expose this
functionality inside of a browser interface? I know that it isn't likely I
can drag around the nodes or easily implement the slider ...

Indexes..
I have a database with 1 table and 4 fields. No relational link with
anything or other databases. I add about 20 records per second and
periodically query for information. My question, should I create an index

I have several questions regarding clustering:
- Is there any way of exporting the results that Microsoft Clustering produces?
- Is there any way of finding out the optimal number of clusters?
- What is Cluster()?

   I Need To Know if there's away to use different where clauses in the
same select based on conditions , Inside My StoredProcedure
   like this
( THIS IS NOT A TRANSACT SQL- ACCEPTED STATMENT , IT ONLY REPRESENTS WHAT I

Is there any restriction on maximum length of a string in prediction tree?
I have created one decision tree mining model by selecting OLAP data type. But in prediction tree drop down box after 256 characters the statement is truncated.
e.g.
?Grouped Items (StoreDay([StoreDay].[All ...

I have problem. I analyze data using Microsoft Clustering Algorithm.
When I Browse reuslts in column cases I have not integer count of casas.
For example:
In Node ALL:

I've written a fairly complex query in sql2k, but when I attempt to paste the query into the 'new view' generator in Enterprise Manager, I get an error "The Query Designer does not support the DECLARE CURSOR SQL construct."  I want to be able to call the sp from the .asp page, ...

Is it possible to combine continous and dummy variables in a single cluster analysis?
---

hello, I'm reusing the ASP.NET OLAP sample to connect to
Analysis Services using HTTP. Everything runs fine except
when web clients try to launch Excel from the OWC
component, a dialog is displayed : An error ocurred.