so isn't your real problem getting all of the dateimes into a valid format and changing that column from varchar to datetime.

that would allow you to write decent SQL and...

can you post screenshots of the contents of subplan_1 ?

hmsanghavi (5/9/2012)

---

No. In this query, it will give me error. because there while doing join, it will consider all data including invalid data. And conversion of such data into date...

robert.hall (5/9/2012)

---

Thanks Mike,

Please excuse my ignorance, I am not very experienced with SQL Server, but have been tasked with setting up some Maintenance Plans.

Also, I have to wait for my...

genius - thank you

have you looked at the error message ?

....configured to allow remote connections. (provider: Named Pipes Provider<c/> error: 40 - Could not open a connection to SQL Server)). The......

check in ...

Eugene Elutin (5/8/2012)

---

I'm an atheist. Are...

those are the people that are logging in using "SA" ??? - so your trigger will mark the record as update by "SA" - (i'm not for one minurte advocating...

ggjjbb1983 (5/8/2012)

---

They can be updated manually, using a trigger for example, which fires on the insert. Also, i dont need the catalog updates to be real time.

The issue was,...

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...