I am thinking that since there is an active table sitting
there in the result pane (columns and rows) there should
be a way to drill into it.  I have a query that runs for
about 2 hours, and reurns a few thousand rows from a

I have a stored procedure like:
SELECT * FROM MyTable WHERE CityID = @CityID AND Name like @Name     AND
Contains(Description, @Description)
its job to retrieve the row satisfying some criteria provided by the

The query I am passing is as follows
--------------------------
select distinct mobile, assigned_to from ticketout where mobile In
(select mobile from customerout where activation = 'yes')

The following query provides the following result
-----------------
(select distinct mobile, assigned_to from ticketout where mobile in
(select mobile from customerout where activation = 'yes' and simnumber

A query result is as follows
Offered  Answd  Abnd  ring_time (secs)  talk_time (mins)  
243       227    16    2.679012         4.445267  
how do i restrict the number of decimal places in the result.

I'm trying to find some information that explains the math
or programing behind the requirement for an ID field (key
column) when building a Decision Tree model in Analysis
Services.

I have a zip code search, if a user enters a zip code not in the db I want
the user to get a message that says zip code in not listed.
How do I validate a db return when no data is returned?
Any Idea's on how to pull this off? thanks.