Can i attach a .NET assembly into SQL 2000 Server as an extended produce?

and how can it be done?See this KB article:INF: Using Extended Stored Procedures or SP_OA Stored Procedures to Load CLR in SQL Server Is Not Supported It is not recommended or supported. You will have to wait for Yukon.

You might also reada blog entry by Clemens Vasters for his thoughts and further explanation of why it is a problem.

Terri

Can date ranges affect query plans?

Howdy. This seems strange to me, but maybe it is to be expected? I have two
queries that produce the same results.
When I use older date ranges(01/01/04 = 01/31/04), query 1 returns
consistently in 0-1 seconds, and query 2 returns in about 4 seconds.
But then when I use more recnt date ranges(01/01/06 - 01/31/06), I have to
cancel query 1 as it still hasnt completed after 10 minutes, while query 2
returns in about 10 seconds.
How can it be?
TIA, ChrisRWhat do the execution plans for the queries show?
SET SHOWPLAN_TEXT ON
--run your queries
Guess: Query1 will show a full table (or clustered index) scan for the date
range 1/1/06 - 1/31/06.
"ChrisR" wrote:

> Howdy. This seems strange to me, but maybe it is to be expected? I have tw
o
> queries that produce the same results.
> When I use older date ranges(01/01/04 = 01/31/04), query 1 returns
> consistently in 0-1 seconds, and query 2 returns in about 4 seconds.
> But then when I use more recnt date ranges(01/01/06 - 01/31/06), I have to
> cancel query 1 as it still hasnt completed after 10 minutes, while query 2
> returns in about 10 seconds.
> How can it be?
> TIA, ChrisR

Can a table, matrix or list produce this?

I am converting a report from a Clipper application and the existing reports
shows States with some additional information in a format I am finding hard
to reproduce. On first glance the report looks like a simple tabular
format. There are something like 10 rows in the table with 3 columns. The
first item of data is placed in row 1 column 1. The second item is in row 1
column 2 and the third item is row 1 column three. The fourth item is in
row 2 and column 1. I can use a matrix and produce the rows going
horizontally but I am not sure how to limit the columns to 3 and start new
rows below that. Below is an example.
AL 12345 AR 12367 CA 19494
CO 38823 CT 43984 GA 39393
IA 39390 ID 39390 IL 39300
Any idea would be greatly appreciated.
Thanks.You may be interested in this blog article:
http://blogs.msdn.com/chrishays/archive/2004/07/23/193292.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lance" <lely@.nospam.com> wrote in message
news:e1xduBf4EHA.1452@.TK2MSFTNGP11.phx.gbl...
> I am converting a report from a Clipper application and the existing
reports
> shows States with some additional information in a format I am finding
hard
> to reproduce. On first glance the report looks like a simple tabular
> format. There are something like 10 rows in the table with 3 columns.
The
> first item of data is placed in row 1 column 1. The second item is in row
1
> column 2 and the third item is row 1 column three. The fourth item is in
> row 2 and column 1. I can use a matrix and produce the rows going
> horizontally but I am not sure how to limit the columns to 3 and start new
> rows below that. Below is an example.
> AL 12345 AR 12367 CA 19494
> CO 38823 CT 43984 GA 39393
> IA 39390 ID 39390 IL 39300
> Any idea would be greatly appreciated.
> Thanks.
>