Lowell (10/29/2007)

---

Ramesh that was spot on... the only thing that was missing from your sample was a single character due to my poorly named variables:

WHEREN <= LEN( T2.DefinitionAsHTML )AND SUBSTRING(...

The message clears states that you don't have an index on source table which is there in target table....

Taken for BOL

Table and Index Structure Requirements

Both the source table and the...

Go to Management Studio > Object Explorer > Server Explorer > Management > Legacy > Database Maintainance Plans

Right click on the package & select schedule package....

Cross post...continue discussions [highlight=""]here[/highlight]

Well, then you've to remove the additional columns added in group by...

SELECT Count(tblSicknessEpisode.PersonnelNumber) AS CountOfPersonnelNumber, tblSicknessEpisode.PersonnelNumber

FROM tblSicknessEpisode

GROUP BY tblSicknessEpisode.PersonnelNumber

HAVING (((tblSicknessEpisode.SickCategory)="NWR") AND CountOfPersonnelNumber >= 4 )

ORDER BY tblSicknessEpisode.PersonnelNumber;

You...

KHI,

You need to allow remote connections to connect to the instance...

...just follow the steps that Kishor has suggested...

Last week 1 of my assistant dba deleted the built in admin group,so...

I don't know whether the below queries would run in Access or not...(and i'm sure the last one would work)...

SELECT Count(tblSicknessEpisode.PersonnelNumber) AS CountOfPersonnelNumber, tblSicknessEpisode.PersonnelNumber, tblSicknessEpisode.SickEpisodeID, tblSicknessEpisode.FirstDate, tblSicknessEpisode.LastDate, tblSicknessEpisode.SickCategory

FROM tblSicknessEpisode

GROUP...

Before applying the patch, are you able to connect to the instance?

The pivoted values should always be enclosed with square braces..

PIVOT ( SUM(AMOUNT) FOR FUNDINGSOURCE IN ([Elementary], [SBA], [Secondary] ) ) AS X

Lowell,

I just tried the below query and its giving what exactly you require....

SELECTT1.N, T2.NumDef,

SUBSTRING( T2.DefinitionAsHTML, ( CASE T1.N WHEN 1 THEN 1 ELSE T1.N + @pr END ),

( CASE...

Jeff Moden (10/26/2007)

---

No, not crazy... both of...

jdwebwolf (10/27/2007)

---

I am wondering if that will do what I am trying to do

'Language' is not acutally a field in the table and the URLs are oddly formated as they...

Thanks tom....

pricejt (10/27/2007)

---

alright i was able to get it working.

One more question. What im trying to do is compare a column from serer B to Server error and return the rows...