Please help its urgent

i have a data which will be updated daily in database.. my crystal report will show all that data..

Now here is da query on which i need help..

Take an example i have values shown on report.. eg

100

300

500

900

1000

.......

note above values will keep on increasing every day..

OUTPUT should be

300 - 100 = 200

500 - 300= 200 .......

so its like i want difference by subracting second value (D2) minus (D1) and then (D3) minus (D2) and so on till it encounters last row.

ACTUAL VALUES ........ how can i get
FROM DB ....... DIFFERENCE OUTPUT ...... OUTPUT

100 ............... ( 300 minus 100 ) ....... 200

300 ............... ( 500 minus 300 ) ....... 200

500 ............... ( 900 minus 500 ) ....... 400

900 ............... ( 1000 minus 900 ) ....... 100

1000 ............... last row will be blank as below this der is no row

i hope u ppl get ma query and plz help me.. its urgentNext({field}) - {field}

please give any example for using UpdateQueryColumns Property

please help me...

what i required is, When a table is updated i want to get the column names
that affected , I think that UpdateQueryColumns Propertey may help me..

If what i am thinking is correct,please specify how to use that propertey,

otherwise specify how i can satisfy my requirement..

Thanks in advance........

Quote:

Originally Posted by ramesh1210

please help me...

what i required is, When a table is updated i want to get the column names
that affected , I think that UpdateQueryColumns Propertey may help me..

If what i am thinking is correct,please specify how to use that propertey,

otherwise specify how i can satisfy my requirement..

Thanks in advance........

create a trigger. use the UPDATE(field) function

Please Assist! Installation Issue - Updated Info

I have updated this - I really need help! If you read this before, see the
bottom for additional info.
--
Due to configuration changes, I had to uninstall RS (which was running just
fine).
Now I cannot reinstall it.
I have a test server that is a domain controller.
It is running Windows Server 2003 Enterprise.
Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
I have not been able to put it back on - its really strange - I get the
dialog box that says it successfully installed the SQL Server Reporting
Services Setup Support Files. When I click the Next button nothing happens.
If I reboot the machine and log back in as Administrator, I get the Error
Report dialog:
SQL Server Setup encountered an error and needed to close.
Of course, I choose "Send" to send the error report. In the event viewer, it
has this:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
--
Now it occurred to me that it appears to be dying when it is supposed to go
to the "System Check" dialog.
I have tried to generate a setup log using /l*v setup.log to no avail - as
no log is ever generated.
Can anyone shed any light on this? I would be happy to allow a remote
desktop connection - just send me an email to
Chris.Conner@.REMOVETHISgisinfosystems.comRun the command line setup with the silent option.
I remember this from a previous post..
Jeff
"Christopher Conner" <someone@.someplace.com> wrote in message
news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> I have updated this - I really need help! If you read this before, see the
> bottom for additional info.
> --
> Due to configuration changes, I had to uninstall RS (which was running
just
> fine).
> Now I cannot reinstall it.
> I have a test server that is a domain controller.
> It is running Windows Server 2003 Enterprise.
> Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> I have not been able to put it back on - its really strange - I get the
> dialog box that says it successfully installed the SQL Server Reporting
> Services Setup Support Files. When I click the Next button nothing
happens.
> If I reboot the machine and log back in as Administrator, I get the Error
> Report dialog:
> SQL Server Setup encountered an error and needed to close.
> Of course, I choose "Send" to send the error report. In the event viewer,
it
> has this:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> --
> Now it occurred to me that it appears to be dying when it is supposed to
go
> to the "System Check" dialog.
> I have tried to generate a setup log using /l*v setup.log to no avail - as
> no log is ever generated.
> Can anyone shed any light on this? I would be happy to allow a remote
> desktop connection - just send me an email to
> Chris.Conner@.REMOVETHISgisinfosystems.com
>|||How is it that the silent switch is going to allow me to install RS on the
machine?
I have tried /qn, /qb, /qr with no avail.
=-Chris
"Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
news:#BiLrOwsEHA.3200@.TK2MSFTNGP14.phx.gbl...
> Run the command line setup with the silent option.
> I remember this from a previous post..
> Jeff
> "Christopher Conner" <someone@.someplace.com> wrote in message
> news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> > I have updated this - I really need help! If you read this before, see
the
> > bottom for additional info.
> > --
> >
> > Due to configuration changes, I had to uninstall RS (which was running
> just
> > fine).
> > Now I cannot reinstall it.
> >
> > I have a test server that is a domain controller.
> > It is running Windows Server 2003 Enterprise.
> > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> >
> > I have not been able to put it back on - its really strange - I get the
> > dialog box that says it successfully installed the SQL Server Reporting
> > Services Setup Support Files. When I click the Next button nothing
> happens.
> >
> > If I reboot the machine and log back in as Administrator, I get the
Error
> > Report dialog:
> >
> > SQL Server Setup encountered an error and needed to close.
> >
> > Of course, I choose "Send" to send the error report. In the event
viewer,
> it
> > has this:
> >
> > Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> > sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> > --
> > Now it occurred to me that it appears to be dying when it is supposed to
> go
> > to the "System Check" dialog.
> >
> > I have tried to generate a setup log using /l*v setup.log to no avail -
as
> > no log is ever generated.
> >
> > Can anyone shed any light on this? I would be happy to allow a remote
> > desktop connection - just send me an email to
> > Chris.Conner@.REMOVETHISgisinfosystems.com
> >
> >
>|||I believe the silent install circumvents a known bug or something. Search
this group for more info..sorry that's all I have
Jeff
"Christopher Conner" <someone@.someplace.com> wrote in message
news:#2lEolStEHA.312@.TK2MSFTNGP10.phx.gbl...
> How is it that the silent switch is going to allow me to install RS on the
> machine?
> I have tried /qn, /qb, /qr with no avail.
> =-Chris
> "Jeff Dillon" <jeff@.removeemergencyreporting.com> wrote in message
> news:#BiLrOwsEHA.3200@.TK2MSFTNGP14.phx.gbl...
> > Run the command line setup with the silent option.
> >
> > I remember this from a previous post..
> >
> > Jeff
> > "Christopher Conner" <someone@.someplace.com> wrote in message
> > news:#8V9WzrsEHA.3532@.TK2MSFTNGP15.phx.gbl...
> > > I have updated this - I really need help! If you read this before, see
> the
> > > bottom for additional info.
> > > --
> > >
> > > Due to configuration changes, I had to uninstall RS (which was running
> > just
> > > fine).
> > > Now I cannot reinstall it.
> > >
> > > I have a test server that is a domain controller.
> > > It is running Windows Server 2003 Enterprise.
> > > Running SQL Server 2000 Enterprise with SP3a and hotfix 859.
> > >
> > > I have not been able to put it back on - its really strange - I get
the
> > > dialog box that says it successfully installed the SQL Server
Reporting
> > > Services Setup Support Files. When I click the Next button nothing
> > happens.
> > >
> > > If I reboot the machine and log back in as Administrator, I get the
> Error
> > > Report dialog:
> > >
> > > SQL Server Setup encountered an error and needed to close.
> > >
> > > Of course, I choose "Send" to send the error report. In the event
> viewer,
> > it
> > > has this:
> > >
> > > Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> > > sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> > >
> > > For more information, see Help and Support Center at
> > > http://go.microsoft.com/fwlink/events.asp.
> > >
> > > --
> > > Now it occurred to me that it appears to be dying when it is supposed
to
> > go
> > > to the "System Check" dialog.
> > >
> > > I have tried to generate a setup log using /l*v setup.log to no
avail -
> as
> > > no log is ever generated.
> > >
> > > Can anyone shed any light on this? I would be happy to allow a remote
> > > desktop connection - just send me an email to
> > > Chris.Conner@.REMOVETHISgisinfosystems.com
> > >
> > >
> >
> >
>|||Hi,
I've tried the silent install and other recommendations (e.g., copying
the CD to a local directory), and I still can't get past the
installation of the support files. Does anyone have any other
suggestions that I might try?
Thanks,
-Melissasql

Placing a lock on a table

Is there any way to place a lock on a table for the duration of a certain
process (to ensure it does not get updated by anybody else), short of placin
g
the entire process in a single transaction? The process in question performe
s
data import and can run for up to 15 minutes.
Any comments are greatly appreciated.
VladTo hold a lock from a process then the process has to be in a transaction or
the lock will be dropped.
There are other ways though
e.g.
The process could put it's spid in a table. Put a trigger on the table - if
the updating spid is not in the table (and the table isn't empty) then fail
the update.
At the end of he process clear the table.
"Vlad" wrote:

> Is there any way to place a lock on a table for the duration of a certain
> process (to ensure it does not get updated by anybody else), short of plac
ing
> the entire process in a single transaction? The process in question perfor
mes
> data import and can run for up to 15 minutes.
> Any comments are greatly appreciated.
> Vlad