Example :

inv acc date

-------------------

inv1 acc1 10/12/2007

inv2 acc1 11/12/2007

inv3 acc1...

Inner Join will be faster.

1) Query optimization.

2) There might be a problem due to index i.e check whether index is used in the correct order(i.e index seek etc.,).

you can see the performance thr' execution...

whether index scan reads the data from index or table? if it reads from the table then there is no advantage of this index scan because , it is reading...

Thanks!!!

Could you able to explain the above points (table scan, BookMark etc.,) or is there any URL?

My suggestions:-

1) check the index in the table i.e your query should perform index seek and scan while executing the query.

I think the above example misleads you....I will re-format the example. pls find below:-

col1 col2

a 1

b ...

Jeff,

I got the solution. ....

Thanks.

I need to generate a cummulative calculation in the query. For example:

there are 2 columns and one column should do the cummulative addition from the query

col1 ...

Replace single quotes with double singlequotes.

Hi ,

I'm using sql server 2000. Do you have any query or site to view the solution. I need to generate the serial number in the query,so that the query...

can you able to send the URL for learning SQL Profiler where the performance of UDF only can monitored?