Viewing 15 posts - 976 through 990 (of 1,124 total)
Lowell (10/29/2007)
WHEREN <= LEN( T2.DefinitionAsHTML )AND SUBSTRING(...
October 29, 2007 at 6:56 am
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...
October 29, 2007 at 6:32 am
Go to Management Studio > Object Explorer > Server Explorer > Management > Legacy > Database Maintainance Plans
Right click on the package & select schedule package....
October 29, 2007 at 6:09 am
Cross post...continue discussions [highlight=""]here[/highlight]
October 29, 2007 at 6:05 am
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;
October 29, 2007 at 6:02 am
Now, I 'm confused and have 2 questions here:
1. If i substitute SCHOOLID, 'Elementary' As Elementary, 'SBA' As SBA, 'Secondary' As Secondary instead of *, why am i getting error?
You...
October 29, 2007 at 6:00 am
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...
October 29, 2007 at 5:39 am
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...
October 29, 2007 at 5:30 am
Before applying the patch, are you able to connect to the instance?
October 29, 2007 at 5:15 am
The pivoted values should always be enclosed with square braces..
PIVOT ( SUM(AMOUNT) FOR FUNDINGSOURCE IN ([Elementary], [SBA], [Secondary] ) ) AS X
October 29, 2007 at 5:09 am
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...
October 29, 2007 at 5:03 am
Jeff Moden (10/26/2007)
Greg Snidow (10/26/2007)
Well, I can't replicate it, but I know I had an issue with it before. Maybe I'm just crazy.
No, not crazy... both of...
October 29, 2007 at 3:05 am
jdwebwolf (10/27/2007)
'Language' is not acutally a field in the table and the URLs are oddly formated as they...
October 29, 2007 at 12:24 am
pricejt (10/27/2007)
One more question. What im trying to do is compare a column from serer B to Server error and return the rows...
October 27, 2007 at 10:24 am
Viewing 15 posts - 976 through 990 (of 1,124 total)