Just add the ORDER BY clause to the CTE...

With downline (ConsultantID,ConsultantName,SponsorID,SponsorName,DownLineLevel)

AS

(

SELECT A.ConsultantID

,A.FirstName + ' ' + A.LastName as ConsultantName

,A.SponsorID

,(SELECT [FirstName] + ' ' + [LastName] FROM Consultant WHERE ConsultantID =...

You just need...

Alen,

Without changing the design, i don't think we can find ways to index that computed column.

You can try the alternative approaches...

I guess its because of truncation (as there must be enough rows to fill the limit)...

You need to modify the query...

1. Need to select distinct dates from the resultset

2. CAST(Quality_Date...

I don't think this is going to work....

Then, just remove the TOP clause from the select statement...

Are you using Indexed Views or Indexed computed columns in your procedure? If yes, try setting the ARITHABORT option set to ON at procedure level.

You first need to setup linked servers, and then access the linked server in the same fashion...

SELECT * FROM ServerA.SomeDB.SomeOwner.SomeTable

I've been in the same situation when I first installed SQL 2005 EE. I've tried installing it multiple times but i failed to successfully install SSMS. After a...

Just add one more column in your select.....

SELECT 'Customer' AS Table, count(Customer_id) FROM Customer WHERE CountryCode='vn'

UNION ALL

SELECT 'SalesOp' AS Table, COUNT(salesOp_id) FROM SalesOp WHERE programCode='lt' and SalesOfficeCode like 'vn%'

You can define indexes on computed columns as long as the following requirements are met:

1. Ownership requirements

2. Determinism requirements (which in your case is violated by using TOP)

3. Precision...

What errors you are getting while executing?

Is it overflow or divide by zero errors? If this is the case, then you need to check the settings of...

Excerpt taken for BOL:

Microsoft Internet Explorer 6.0 SP1 or later is required for all installations of SQL Server 2005, as it is required for Microsoft Management Console (MMC) and HTML...

Could be elaborate on what exactly you want?

I still couldn't get you what you are pointing to.:cool:

Do you want only those rows where the said columns are not...

Here is the query, would give which indexes are stored on which filegroups...

SELECTOBJECT_NAME( i.id ) AS TableName, i.name AS IndexName, fg.groupname AS [FileGroup]

FROMsysindexes i

INNER JOIN sysfilegroups fg ON i.groupid =...