Insert statement

Hi
When I try to insert a row in table(without any index) why does it display
READS count as 1 in profiler trace for every insert statement executed
against tht table?
It also dispalys WRITE count but that is expected but why READ?
Table structure is normal only two int and char columns without any default
or identity defined.
Thanks in advance.
ManuProfiler includes some reading meta-data like verifying permissions and translating object name to
object id. My guess is that this is what you see...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"manu" <manu@.discussions.microsoft.com> wrote in message
news:1E3FC2FF-ED8B-4430-9508-5D84F9654BC0@.microsoft.com...
> Hi
> When I try to insert a row in table(without any index) why does it display
> READS count as 1 in profiler trace for every insert statement executed
> against tht table?
> It also dispalys WRITE count but that is expected but why READ?
> Table structure is normal only two int and char columns without any default
> or identity defined.
> Thanks in advance.
> Manu
>
>|||Hmmm. Perhaps it has to READ the page so that it can put the data in it
before the page WRITEs back.
The reads and writes are, by the way logical reads and writes because the
actual physical reads and writes are managed by caching and buffers.
RLF
"manu" <manu@.discussions.microsoft.com> wrote in message
news:1E3FC2FF-ED8B-4430-9508-5D84F9654BC0@.microsoft.com...
> Hi
> When I try to insert a row in table(without any index) why does it display
> READS count as 1 in profiler trace for every insert statement executed
> against tht table?
> It also dispalys WRITE count but that is expected but why READ?
> Table structure is normal only two int and char columns without any
> default
> or identity defined.
> Thanks in advance.
> Manu
>
>

Insert parameter to retrieve a specific chart type

Hi everyone,
Is is possible to display a specific type of chart depending on an input parameter in my data. For instance, my dataset contains a column for questiontype.
If the questiontype equals 1, I would like to display to results in a barchart. If the questiontype equals 2 I would like to display the result in a pie-chart.

IS there some kind of way to manage this problem?

thanks so far.

regard,
capsync

I am not 100% certain - but close - I do not think this can be accomplished with "out of the box" RS...
As you know - when you design the report the data from the data set populates the chart, bar, pie, etc. I have not come across a method to alternate what type of chart is displayed because you have to design the report with each chart type (bar, pie, etc...) and once these charts are added via the design wizard - they are just there and that is that...
If you get an answer I would like to know as well...
One other thing I have tried to get to happen as well --
Not display the chart based upon a parameter - but once you "design the report" with a chart it appears (as long as there is data).
So I think the answer is no and I have searched everywhere for answers to the questions.
Best Regards,
joe