Can MDX or latch a value based on a signal?

Dear All,

Persume that I have a cube with the following measures and dimension:

DimTime, measures.LatchSignal, measures.Voltage

0,1,4

1,0,5

2,0,6

3,0,5

4,1,3

5,0,7

6,0,5

7,1,6

8,0,7

Is there anyway I can repeat the value of voltage on and after the time when latch signal = 1, so that the result is rendered as follows:

DimTime, measures.LatchSignal, measures.Voltage, measure.latchedVoltage

0,1,4,4

1,0,5,4

2,0,6,4

3,0,5,4

4,1,3,3

5,0,7,3

6,0,5,3

7,1,6,6

8,0,7,6

Thanks and regards,

Tony Chun Tung Siu

Hi Tony!

Why do you try to make it in MDX. What the problem do you solve?

I would make it in DSV in oder to get

0,1,4,4

1,0,5,NULL

2,0,6,NULL

3,0,5,NULL

4,1,3,3

5,0,7,NULL

6,0,5,NULL

7,1,6,6

8,0,7,NULL

then apply lastnonempty aggregation function for the measure latchedVoltage

|||

Hi

I just wanna plot a graph for such signal implementation. This works!.

Thanks

Tony

Can I still recover this database : Only have the MDF file, no LDF file ?

Dear all,
If a database was corrupted (due to whatever reasons) and lost its LDF files
but only had its MDF files, can I still recover it ?
How ?
Please tell me, thanks.Hi,
If you have database backups then restore from these backups instead.
The problem I see with using only the mdf file is that the missing ldf files
may have information to rollback or roll forward transactions in order to
leave the database in a consistent state.
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"cpchan" wrote:
> Dear all,
> If a database was corrupted (due to whatever reasons) and lost its LDF files
> but only had its MDF files, can I still recover it ?
> How ?
> Please tell me, thanks.
>
>|||Hi
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:472d345d$1@.127.0.0.1...
> Dear all,
> If a database was corrupted (due to whatever reasons) and lost its LDF
> files
> but only had its MDF files, can I still recover it ?
> How ?
> Please tell me, thanks.
>
>

Can i run two SQl server instances

Dear All,
Can i run two sql server instances if yes than what would be steps .
Thank's
Faheem
NETSOL
> Can i run two sql server instances if yes than what would be steps .
Yes you can. You need to create a named instance while installing the second
sql server instance. This is an option that comes up during the installation
procedure.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:57A297F4-B80F-4448-8CB0-4D6173C0670C@.microsoft.com...
> Dear All,
> Can i run two sql server instances if yes than what would be steps .
> Thank's
> Faheem
> NETSOL
>

Can i run two SQl server instances

Dear All,
Can i run two sql server instances if yes than what would be steps .
Thank's
Faheem
NETSOL> Can i run two sql server instances if yes than what would be steps .
Yes you can. You need to create a named instance while installing the second
sql server instance. This is an option that comes up during the installation
procedure.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:57A297F4-B80F-4448-8CB0-4D6173C0670C@.microsoft.com...
> Dear All,
> Can i run two sql server instances if yes than what would be steps .
> Thank's
> Faheem
> NETSOL
>

Can i run two SQl server instances

Dear All
Can i run two sql server instances if yes than what would be steps
Thank'
Faheem
NETSOL> Can i run two sql server instances if yes than what would be steps .
Yes you can. You need to create a named instance while installing the second
sql server instance. This is an option that comes up during the installation
procedure.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:57A297F4-B80F-4448-8CB0-4D6173C0670C@.microsoft.com...
> Dear All,
> Can i run two sql server instances if yes than what would be steps .
> Thank's
> Faheem
> NETSOL
>

Can I place Lock for some time in a Transaction

Dear all,

I have a transaction performing some oeprations. Can I Lock (UPDLOCK) some table for some time in transaction and then release the lock. Basically if i place the lock on table it remains there for whole transaction duration. What to do if I want to release it explicitly in transaction?

Thanks in advance,
AvneeshI do not understand,
can you please be more specific?|||Lets take an example to be more specific about problem
--------------------
Begin tran
Lock mytab with UPDLOCK
...Do Some operation...
Release lock on mytab
...Do some operation....
Commit tran
--------------------

Is this possible?

If you have some idea then most welcome.

Thanks in advance,
Avneesh