Did you start with a "select * " to see what's the cause of this error ?

just another thought ...

avoid FREETEXT !

Freetext <> like !

Maybe a like predicate serves you better.

Check BOL !

WHERE A.City_Name like '%New York%' and A.state = 'NY')

AND ( B.Business_Name...

Just my 2 ct.

I'd first convert the where ... in (select .. ) or ... in ( select ...)

to correlated subqueries lik :

WHERE A.City_Name like '%New York%'

and...

have a look at the new pivot methode:

Pivot table for Microsoft SQL Server

http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/

http://www.sqlservercentral.com/articles/Development/2734/

http://www.sqlservercentral.com/redirect/articles/2791/

you could also use the new "intersect" and "except" clauses to get mutual of different rows in a set ( unjoined ).

http://msdn2.microsoft.com/en-us/library/ms188055.aspx

this would take a tripple join

select ...

from computers C

inner join computers_to_components_relations CCR

on C.ID = CCR.COMPUTER_ID

inner join components Cmp

on CCR.COMPONENT_ID =...

Let us know if it got an A+:w00t:

HTH

regarding the unavailable files .... if you encounter invalid urls, contact the webmaster. The site has been restyled and suffers some issues of this kind.:ermm:

I've just contaced the webmaster. Normaly...

Oops SQL7-2000 forum ..... offcouse CTE's will not be available for you, nor will outerapply :blush:

CREATE FUNCTION utvf_getDateList_2000 ( @startDate datetime, @endDate DATETIME)

RETURNS @tvfResult TABLE ( effective_date DATETIME NOT NULL...

IMO one should always work with deterministic data, meaning always specify an end date (even if it is way up in the future).

It avoids handling a NULL enddate and urges...

KISS principle :

CREATE PROC spc_Currencyconvertor

@FromCurrencyCode CHAR(3),

@ToCurrencyCode CHAR(3),

@Amount MONEY ,

@CurrencyRateDate DATETIME ,

@ConvertedValue MONEY OUTPUT

AS

BEGIN

SET NOCOUNT ON

IF @CurrencyRateDate IS NULL

BEGIN

SET...

Recursive Queries in SQL:1999 and SQL Server 2005

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/recursivequeriesinsql1999andsqlserver2005/1846/

With nice tests ...

CTE Performance

http://www.sqlservercentral.com/articles/2926/

Nice example.

... 2) The maximum number of levels is 100. This is the limitation of T-SQL. ...

This is not correct! It is the default recursion limit.

Values: 0 - 32767

You can...

I think you can set the front end field property to accept 0 decimals. :hehe:

This way it will not allow decimals.

- http://www.davidemauri.it/DasBlog/CategoryView,category,Sql%20Server%202005.aspx

CREATE view [V_partitioned_objects]

as

select distinct

p.[object_id],

index_name = i.[name],

index_type_desc = i.type_desc,

partition_scheme = ps.[name],

data_space_id = ps.data_space_id,

...