Can I hide displaying a certain member?

Hi,

I have a dimension called customers having the following levels:

ALL
Level 1 CustType
Level 2 Cust Rank
Level 3 Cust Name

Suppose that the possible CustTypes are "Potential", "Active", "Lost".
Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"create a view on the table like select col1,col3 from the table and access (http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21175087.html#) the view.|||Thanks for the reply. Yup it seems that the view approach is what I will have to go with.

Can I have SQL server clear a value after a certain amount of time?

I have an application that allows users to "reserve" a certain time and location for practice sessions. I want them to look at a web form that shows which times are available and then allows them to select an open slot and then submit this form with some personal information. My problem is that as soon as they select an open slot, other users should see that this slot is no longer available. On the other hand, if someone selects an open slot and then takes too long to type in their personal information, I want it somehow to kick them out and re-open this slot back up.

I know that I can create a field called 'status' in my database that gets turn to something like 'pending' as soon as the first user clicks on an open slot, but how would I turn this field back to the 'open' state if the user took too long to enter their data?

Any help would be surely appreciated.

Cheers,
AzFyou can store the time the page was requsted in some variable and check against some preset time like 5 min or 10 min...also when do you set the slot as reserved...as soon as the user clicks on the spot or at the end of the page after the user finished entering all the info...? i would suggest doing the latter...

hth

Can Events be fired in a certain order?

I am getting my arms around Notification Services (NS). We need to generate notifications based on about 5 different subscriptions. The 5 events that feed the subscriptions will be SQL based and will read from a work table. I would like to populate that work table with a subset of our high volume transaction data, run the events, and then clear the data for the next run...say 5 minutes later. So my question is, how do I know when the last of the 5 events has fired so I can clean out the data. In other words, I'd like the 5 events to fire in a certain order and have the last event clean up. Is there a way to tell the events in what order they can fire? Or other suggestions on how to solve this? I read up on Chronicles but it wasn't clear to me if that would solve my problem.

Secondly, if my events and subscriptions created notifications for 5 different subscriptions, can they be combined into one e-mail to be delivered to the subscriber? In other words, there are several subscription events that may happen during the day for a subscriber. The subscriber only wants one e-mail at the end of the day. Will NS combine it?

There are several ways to recognize new events in the SQL Server Event Provider. A couple that I've used in the past is:

1) Use a postprocessing query to update a column in the data source indicating that the row has been processed.

2) Use a Chronicles table to track the datetime of the last query and only look for rows that have been added since then.

HTH...

Joe|||Thanks Joe. That does help.

can connect to all servers but one on certain box

I have an issue where users can't connect to a server - Server A - from a pa
rticular client computer - Box B. They can connect to other servers from Box
B - even servers in the same cluster as Server A. On other client machines
the same users can connect
to all servers - including Server A. They are using Windows authorization. I
s there any setting that might need to be changed either in Windows or SQL S
erver on either Server A or Box B that might correct this situation?Sounds like you want to check Client Network Utility and Server Network
Utility on the involved machines.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"hawthorne" <anonymous@.discussions.microsoft.com> wrote in message
news:A3F01255-54EF-4F09-A8AD-0CBA21C6D04B@.microsoft.com...
> I have an issue where users can't connect to a server - Server A - from a
particular client computer - Box B. They can connect to other servers from
Box B - even servers in the same cluster as Server A. On other client
machines the same users can connect to all servers - including Server A.
They are using Windows authorization. Is there any setting that might need
to be changed either in Windows or SQL Server on either Server A or Box B
that might correct this situation?|||Can you PING Server A from Box B ?