does anyone know the answer?

i have two Running Total Fields
Total NWN and Total Keyed
how can i add these two Running Total Fields?
and how can i connect mysql to crystal report?
thanks1) Just add them in a formula
{#Total NWN} + {#Total Keyed}

2) Don't know|||i have two Running Total Fields
Total NWN and Total Keyed

how can i add these two Running Total Fields?
At the end of outer group which calculates total of these fields,
add like this: {Total Keyed} + {Total NWN}.
Please try since i didn't test this syntax.

and how can i connect mysql to crystal report?

thanks
Did you read the answer in your previous started thread? ("http://www.dev-archive.com/forum/showthread.php?t=437244) :mad:

Documented t-sql for file space ?

Hi There

I would like to write sql to check that space used by any given data file in SS2000.

sp_spaceused only returns the total space used by the DB or object in the DB, not for a specific data file.

DBCC SHOWFILESTATS does give me this information , but it is not documented in BOL, i would prefer not to use an undocumented command to ensure future use in later versions. Is DBCC SHOWFILESTATS an undocumented T-SQL command ? If so what documented t-sql command will provide me with this information ?

I could query system table's and work this out , but as mentioned this may not not work in future versions of SS.

Thanx

Dont worry, seems FILEPROPERTY function will do this for me , thanx

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
Thanks for the help,
RDA
http://www.aspfaq.com/2209
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA
|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
> Thanks for the help,
> RDA
|||Consider WT3 - one of the SQL Server Tools applications...
http://www.sqlservertools.us
It may do what you are asking for, as well as a lot more.

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others
Thanks for the help
RDAhttp://www.aspfaq.com/2209
--
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone know of others?
> Thanks for the help,
> RDA|||Consider WT3 - one of the SQL Server Tools applications..
http://www.sqlservertools.u
It may do what you are asking for, as well as a lot more

Documentation Tool

I was wondering if anyone has a good SQL Server Documentation tool. I have b
een looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone kn
ow of others?
Thanks for the help,
RDAhttp://www.aspfaq.com/2209
http://www.aspfaq.com/
(Reverse address to reply.)
"RDA" <anonymous@.discussions.microsoft.com> wrote in message
news:48620959-3C4E-4520-A9B0-CAD19CE70530@.microsoft.com...
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||RDA,
I like ER/Studio from Embarcadero.
http://www.embarcadero.com/products/erstudio/index.html
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
RDA wrote:
> I was wondering if anyone has a good SQL Server Documentation tool. I have
been looking at FMS - Total SQL Analyzer and AGS - SQL Scribe. Does anyone
know of others?
> Thanks for the help,
> RDA|||Consider WT3 - one of the SQL Server Tools applications...
http://www.sqlservertools.us
It may do what you are asking for, as well as a lot more.