mldardy (5/8/2012)

---

Get an 'incorrect syntax ner ')' error. I'm trying to see what the problem is because this is usually matching '()' but not for sure.

SELECT CouncilName, LastYearQtyActualContainers as...

here are the ways full text indexes are updated - typically they get updated on a schedule - therefore your results will not be realtime

http://msdn.microsoft.com/en-us/library/aa214782(v=sql.80).aspx

michael vessey (5/8/2012)

---

full text is stored outside the DB as full text catalogues - they have nothing to to with clustered or nonclustered indexes

see this article to get you started

http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server

full...

Sorry, I hate such questions. They are generic and very personal!

Someone need to remember to make backups, another one should remember to hit save before closing script file and...

ModifiedBy and ModifiedOn do require triggers, but unless there's a reason to just know who changed a row without having any idea what they changed, there's probably not that...

full text is stored outside the DB as full text catalogues - they have nothing to to with clustered or nonclustered indexes

see this article to get you started

http://www.simple-talk.com/sql/learn-sql-server/understanding-full-text-indexing-in-sql-server

full text indexing...

mldardy (5/8/2012)

---

Well I tried something a little different with the difference formula and I get a 'Divide by zero error encountered'. This is on the bolded line below

SELECT CouncilName,...

I'm not sure if reading good suggestions from this forum would prevent many of newbies from being "promptly escorted off the premises" after interview with some of us :w00t:.

But,...

i would wager that this is faster

SELECT drm.requestid, DRM.RunningBoard,DRM.DutyBoard,DRM.DriverId,DRM.PublicServiceCode,DRM.ServiceCode,DRM.DepotCode,DRM.Direction,DRM.EOJMethod,DRM.JourneyNo,

CONVERT(datetime, MW.MessageTimeStamp,2) as MessageTimeStamp

FROM FactETMPositionRequests DRM

JOIN ETMMessage EM ON EM.ETMMessageID= DRM.ETMMessageID

JOIN MessageWrapper MW ON EM.WrapperID= MW.ID

WHERE

CONVERT(datetime, MW.MessageTimeStamp,2)...

so how many times a day is this extra 200k being read from disk? once...

Jeff Moden (5/4/2012)

---

michael vessey (5/4/2012)

---

capn.hector (5/4/2012)

---

Eugene Elutin (5/4/2012)

---

Jeff Moden (5/3/2012)

---

BWAAAA-HAAAA!!!!! Ask that question on the receiving...

Matthew Cushing (5/4/2012)

---

awesome, thanks man.

If I had another condition where a and b = us and c = null, can I just add another statement like this after the initial...

Matthew Cushing (5/4/2012)

---

I have a query that I've written that is pulling data from joined selects. I have a need to look at the results and exclude rows that...

you will need to supply more info on the stored procedure for anyone to be able to really help you - but my first question

is there the same amount...

you'll need to provide more information than that if you want people to be able to help you

first though - have you checked that SQL agent is running an that...