This is a multi-part message in MIME format.
--=_NextPart_000_0011_01C5191B.23066440
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all.
I've got a SQL Server 2k sp3 on Win 2003.
It has the Performance Counters listed for SQL Server, but when I select = any of the counters, they don't show any activity.
Any ideas?
Thanks,
Rick
--=_NextPart_000_0011_01C5191B.23066440
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi all.
I've got a SQL Server 2k sp3 on Win = 2003.
It has the Performance Counters listed for SQL = Server, but when I select any of the counters, they don't show any activity.
Any ideas?
Thanks,
Rick
--=_NextPart_000_0011_01C5191B.23066440--Hi
You may want to check your event logs to see if anything is being
logged.
Check sysperfinfo to see what information is there.
Rebuild the performance counters:
http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
John|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1109147319.860891.81450@.f14g2000cwb.googlegroups.com...
> Hi
> You may want to check your event logs to see if anything is being
> logged.
> Check sysperfinfo to see what information is there.
> Rebuild the performance counters:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;300956
> John
>
Okay... nothing in the sysperinfo table. That would explain why the
counters are reading 0. I'm still trying to track down the problems
though. I will try the rebuild later today and see what happens.
Ricksql
Showing posts with label charset. Show all posts
Showing posts with label charset. Show all posts
Friday, March 23, 2012
Monday, February 20, 2012
Percentage of total
This is a multi-part message in MIME format.
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
I want to create such a report:
Dep. Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 10 10% 2%
Department2 40 40% 8%
Department3 50 50% 10%
---
Total A 100 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20% Department5 300 75% 60%
---
Total A 400 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Total 500 100%
What is the right way to calculate the Percentage for each Department?
Should I calculate it in the SQL or could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I want to create such a report:
Dep. = Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 = 10 10% 2%
Department2 = 40 40% 8%
Department3 = 50 50% 10%
---
Total A 100 &nb= sp; 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20%
Department5 300 75% 60%
---
Total A 400 &nb= sp; 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
Total = 500 100%
What is the right way to calculate the = Percentage for each Department?
Should I calculate it in the SQL or = could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0--On Feb 23, 1:24 pm, "Geri Reshef" <gershon_res...@.recanati-
alum.tau.ac.il> wrote:
> I want to create such a report:
> Dep. Sales %T1 %T2
> Division A
> =======> Department1 10 10% 2%
> Department2 40 40% 8%
> Department3 50 50% 10%
> ---
> Total A 100 100% 20%
> Division B
> =======> Department4 100 25% 20%
> Department5 300 75% 60%
> ---
> Total A 400 100% 80%
> ========================> Total 500 100%
> What is the right way to calculate the Percentage for each Department?
> Should I calculate it in the SQL or could I use the abilities of SSRS?
You can do it either way. In SSRS, you could use an expression similar
to this to get the percentages per department.
=(Fields!Sales.Value/Sum(Fields!Sales.Value)) * 100
And then in the format section of the table column properties for the
T1 column, set the format to: #.00%
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant'
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
I want to create such a report:
Dep. Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 10 10% 2%
Department2 40 40% 8%
Department3 50 50% 10%
---
Total A 100 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20% Department5 300 75% 60%
---
Total A 400 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Total 500 100%
What is the right way to calculate the Percentage for each Department?
Should I calculate it in the SQL or could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I want to create such a report:
Dep. = Sales %T1 %T2
Division A
=3D=3D=3D=3D=3D=3D=3D
Department1 = 10 10% 2%
Department2 = 40 40% 8%
Department3 = 50 50% 10%
---
Total A 100 &nb= sp; 100% 20%
Division B
=3D=3D=3D=3D=3D=3D=3D
Department4 100 25% 20%
Department5 300 75% 60%
---
Total A 400 &nb= sp; 100% 80%
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D
Total = 500 100%
What is the right way to calculate the = Percentage for each Department?
Should I calculate it in the SQL or = could I use the abilities of SSRS?
--=_NextPart_000_0181_01C87662.85ABCAC0--On Feb 23, 1:24 pm, "Geri Reshef" <gershon_res...@.recanati-
alum.tau.ac.il> wrote:
> I want to create such a report:
> Dep. Sales %T1 %T2
> Division A
> =======> Department1 10 10% 2%
> Department2 40 40% 8%
> Department3 50 50% 10%
> ---
> Total A 100 100% 20%
> Division B
> =======> Department4 100 25% 20%
> Department5 300 75% 60%
> ---
> Total A 400 100% 80%
> ========================> Total 500 100%
> What is the right way to calculate the Percentage for each Department?
> Should I calculate it in the SQL or could I use the abilities of SSRS?
You can do it either way. In SSRS, you could use an expression similar
to this to get the percentages per department.
=(Fields!Sales.Value/Sum(Fields!Sales.Value)) * 100
And then in the format section of the table column properties for the
T1 column, set the format to: #.00%
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant'
Subscribe to:
Posts (Atom)