More grouping Woes!

I have a result set of consisting of names and addresses. each person at a
particular address (1-n people) gets an identical groupid to group them in a
"Family".
My report lists each column, groupid, name, address, with one row for each
person. I would like for it to group on the groupid, then list each person in
a subgroup sorted by name.
When I set a "group" row on my report and group on the groupid, all i get is
the first row of the family, and the rest of the data is dropped. how do i
get the group to show all the data? I am using RS2005 with VS2005.
thank you in advance for your help!!I ran into a similar problem a little while ago. I had numerical data based
on the # of hours worked and then a description of what was done in those
hours. I grouped on the person and date and then summed the hours they
worked for that span of time so my output looked something like:
John Doe
11/12/2006
Regular OT Description
On-Site 8 0 Worked on
server.
Remote 0 2
However the description for the remote would not print out, even though the
output was =fields!onsitenotes.value & fields!remotenotes.value, because they
were in the same group
What I wound up doing was setting a different group underneath the name/date
for each row of data(on-site, remote) I'm not sure if you will be able to do
exactly that but I basically had to assign some flags based on the work-type
(on-site, remote, etc) in the query and then group on those flags.
So it wound up being something like:
Group1(
John Doe
11/12/2006
Regular OT
Description
Group2 ( On-Site 8 0 Worked
on server.)
Group3 ( Remote 0 2 Helped on
the phone.)
)
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200612/1

Month Days

How can you find the days in a particular month in crystal reports v10.
(e.g. as in vb.net MYDAYS_MONTH = DateTime.DaysInMonth({?Year}, {?Month}))Try Day(Datefield)

Monitoring sql statement ran against a table

I need to know if there is a way to either record all queries ran again
a particular table or to fire off a trigger if a particualr row is
selected from that table in sql server 2005. The main issue I am
having is "select" statements. The reason I am attempting to do this is
its full fill part of some requirements for a project. I was hoping to
do this with sql server and not a third party solution if possible.
Thanks for any help,
Marty
--[vbcol=seagreen]
A free community forum for resolving all of your high tech issues.maznblue@.gmail.com wrote:

> I need to know if there is a way to either record all queries ran again
> a particular table or to fire off a trigger if a particualr row is
> selected from that table in sql server 2005. The main issue I am
> having is "select" statements. The reason I am attempting to do this is
> its full fill part of some requirements for a project. I was hoping to
> do this with sql server and not a third party solution if possible.
> Thanks for any help,
> Marty
> --
> A free community forum for resolving all of your high tech issues.
Use profiler
You can filter data as per your requirement.
use sp:stmtcompleted , sp:completed events and objecttype , objectname
column, which will show you details about triggers when event will be
triggered
Regards
Amish Shah|||Marty,
Try using SQL Profiler and put a filter on TextData column like
'SELECT%XXXX%' where XXXXis the table which you are looking for..
Jayesh
<maznblue@.gmail.com> wrote in message
news:1149817748.504429.74260@.i40g2000cwc.googlegroups.com...
>I need to know if there is a way to either record all queries ran again
> a particular table or to fire off a trigger if a particualr row is
> selected from that table in sql server 2005. The main issue I am
> having is "select" statements. The reason I am attempting to do this is
> its full fill part of some requirements for a project. I was hoping to
> do this with sql server and not a third party solution if possible.
> Thanks for any help,
> Marty
> --
> A free community forum for resolving all of your high tech issues.
>|||Jayesh -
Thanks for the info, it worked like a champ.
Marty
Jayesh Antony Jose wrote:[vbcol=seagreen]
> Marty,
> Try using SQL Profiler and put a filter on TextData column like
> 'SELECT%XXXX%' where XXXXis the table which you are looking for..
> Jayesh
>
> <maznblue@.gmail.com> wrote in message
> news:1149817748.504429.74260@.i40g2000cwc.googlegroups.com...

Monitoring sql statement ran against a table

I need to know if there is a way to either record all queries ran again
a particular table or to fire off a trigger if a particualr row is
selected from that table in sql server 2005. The main issue I am
having is "select" statements. The reason I am attempting to do this is
its full fill part of some requirements for a project. I was hoping to
do this with sql server and not a third party solution if possible.
Thanks for any help,
Marty
--
>> www.techmentors.net <<<<<
A free community forum for resolving all of your high tech issues.maznblue@.gmail.com wrote:
> I need to know if there is a way to either record all queries ran again
> a particular table or to fire off a trigger if a particualr row is
> selected from that table in sql server 2005. The main issue I am
> having is "select" statements. The reason I am attempting to do this is
> its full fill part of some requirements for a project. I was hoping to
> do this with sql server and not a third party solution if possible.
> Thanks for any help,
> Marty
> --
> >> www.techmentors.net <<<<<
> A free community forum for resolving all of your high tech issues.
Use profiler
You can filter data as per your requirement.
use sp:stmtcompleted , sp:completed events and objecttype , objectname
column, which will show you details about triggers when event will be
triggered
Regards
Amish Shah|||Marty,
Try using SQL Profiler and put a filter on TextData column like
'SELECT%XXXX%' where XXXXis the table which you are looking for..
Jayesh
<maznblue@.gmail.com> wrote in message
news:1149817748.504429.74260@.i40g2000cwc.googlegroups.com...
>I need to know if there is a way to either record all queries ran again
> a particular table or to fire off a trigger if a particualr row is
> selected from that table in sql server 2005. The main issue I am
> having is "select" statements. The reason I am attempting to do this is
> its full fill part of some requirements for a project. I was hoping to
> do this with sql server and not a third party solution if possible.
> Thanks for any help,
> Marty
> --
>> www.techmentors.net <<<<<
> A free community forum for resolving all of your high tech issues.
>|||Jayesh -
Thanks for the info, it worked like a champ.
Marty
Jayesh Antony Jose wrote:
> Marty,
> Try using SQL Profiler and put a filter on TextData column like
> 'SELECT%XXXX%' where XXXXis the table which you are looking for..
> Jayesh
>
> <maznblue@.gmail.com> wrote in message
> news:1149817748.504429.74260@.i40g2000cwc.googlegroups.com...
> >I need to know if there is a way to either record all queries ran again
> > a particular table or to fire off a trigger if a particualr row is
> > selected from that table in sql server 2005. The main issue I am
> > having is "select" statements. The reason I am attempting to do this is
> > its full fill part of some requirements for a project. I was hoping to
> > do this with sql server and not a third party solution if possible.
> >
> > Thanks for any help,
> >
> > Marty
> >
> > --
> >> www.techmentors.net <<<<<
> > A free community forum for resolving all of your high tech issues.
> >

monitoring memory usage of particular database

We would like to individually monitor the memory usage of all the different
databases on a server. In Current Activity in Enterprise Manager I see Memor
y Usage for the databases - is there a way to log that information? I didn't
see Memory Usage as a data
column in the Trace Properties in the Profiler. Thank you.Could the Perfmon be of any help? You ahve database counters there, depends
on what information you need.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

monitoring memory usage of particular database

We would like to individually monitor the memory usage of all the different databases on a server. In Current Activity in Enterprise Manager I see Memory Usage for the databases - is there a way to log that information? I didn't see Memory Usage as a data
column in the Trace Properties in the Profiler. Thank you.
Could the Perfmon be of any help? You ahve database counters there, depends
on what information you need.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Monitor

Is there a way to find running queries and it's details on
a particular db....
I need executin time,CPU time etc...
Try Profiler.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message news:1080101c43fc0$a0384710$a101280a@.phx.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...
|||As Tibor points out Profiler is the correct tool for what you ask but here
are some links that may be of interest:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring

Andrew J. Kelly
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:1080101c43fc0$a0384710$a101280a@.phx.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...
|||Tnaks all...
>--Original Message--
>As Tibor points out Profiler is the correct tool for what
you ask but here
>are some links that may be of interest:
>
>http://www.microsoft.com/sql/techinf...stration/2000/
perftuning.asp
>Performance WP's
>http://www.swynk.com/friends/vandenberg/perfmonitor.asp
Perfmon counters
>http://www.sql-server-
performance.com/sql_server_performance_audit.asp
>Hardware Performance CheckList
>http://www.sql-server-
performance.com/best_sql_server_performance_tips.asp
>SQL 2000 Performance tuning tips
>http://www.support.microsoft.com/?id=q224587
Troubleshooting App
>Performance
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_perfmon_24u1.asp[vbcol=seagreen]
>Disk Monitoring
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:1080101c43fc0$a0384710$a101280a@.phx.gbl...
on
>
>.
>

Monitor

Is there a way to find running queries and it's details on
a particular db....
I need executin time,CPU time etc...Try Profiler.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message news:1080101c43fc0$a0384710$a101280a@.
phx.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...|||As Tibor points out Profiler is the correct tool for what you ask but here
are some links that may be of interest:
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
on_24u1.asp" target="_blank">http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:1080101c43fc0$a0384710$a101280a@.phx
.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...|||Tnaks all...
>--Original Message--
>As Tibor points out Profiler is the correct tool for what
you ask but here
>are some links that may be of interest:
>
>http://www.microsoft.com/sql/techin...istration/2000/
perftuning.asp
>Performance WP's
>http://www.swynk.com/friends/vandenberg/perfmonitor.asp
Perfmon counters
>http://www.sql-server-
performance.com/sql_server_performance_audit.asp
>Hardware Performance CheckList
>http://www.sql-server-
performance.com/best_sql_server_performance_tips.asp
>SQL 2000 Performance tuning tips
>http://www.support.microsoft.com/?id=q224587
Troubleshooting App
>Performance
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_perfmon_24u1.asp
>Disk Monitoring
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
><anonymous@.discussions.microsoft.com> wrote in message
> news:1080101c43fc0$a0384710$a101280a@.phx
.gbl...
on[vbcol=seagreen]
>
>.
>

Monitor

Is there a way to find running queries and it's details on
a particular db....
I need executin time,CPU time etc...Try Profiler.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message news:1080101c43fc0$a0384710$a101280a@.phx.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...|||As Tibor points out Profiler is the correct tool for what you ask but here
are some links that may be of interest:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:1080101c43fc0$a0384710$a101280a@.phx.gbl...
> Is there a way to find running queries and it's details on
> a particular db....
> I need executin time,CPU time etc...|||Tnaks all...
>--Original Message--
>As Tibor points out Profiler is the correct tool for what
you ask but here
>are some links that may be of interest:
>
>http://www.microsoft.com/sql/techinfo/administration/2000/
perftuning.asp
>Performance WP's
>http://www.swynk.com/friends/vandenberg/perfmonitor.asp
Perfmon counters
>http://www.sql-server-
performance.com/sql_server_performance_audit.asp
>Hardware Performance CheckList
>http://www.sql-server-
performance.com/best_sql_server_performance_tips.asp
>SQL 2000 Performance tuning tips
>http://www.support.microsoft.com/?id=q224587
Troubleshooting App
>Performance
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_perfmon_24u1.asp
>Disk Monitoring
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:1080101c43fc0$a0384710$a101280a@.phx.gbl...
>> Is there a way to find running queries and it's details
on
>> a particular db....
>> I need executin time,CPU time etc...
>
>.
>