When I have to deal with strings being converted to dates and times, I start from the left and work my way right, using Stuff.

Like:

DECLARE @X CHAR(14) = '20110420184518'

SELECT CONVERT(DATETIME,...

"No" to what? I asked an either/or question.

Do you not have any window open at all?

Something like this?

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

GO

USE ProofOfConcept ;

GO

CREATE TABLE #T

(ID INT IDENTITY

...

Do you have a regular connection window open (the text editor), or did you right-click an object and select "Edit" or something like that?

You could use Replace to replace spaces with new lines. Are you familiar with using Replace?

Most people who think they're bad are acting on old data (as Gail mentioned). They can be bad if the underlying tables routinely have schema changes, and you need...

You can't use the new SQL 2008 features in it, like Merge, Table Value Constructors, Table Variable Parameters, et al.

Is the cursor declared as "local"?

What tool are you using? SSMS?

FTS will index all words. The issue with the thesaurus is that if you haven't told it that "AU = Gold = Aurum = Oro", it won't know that....

Leo.Miller (7/25/2011)

---

GSquared (7/25/2011)

---

halifaxdal (7/25/2011)

---

I got this idea from Mark Armer, I agree that in some/or many cases SQL cannot be stopped however I still think his idea is surprised, unexpected...

pwalter83 (7/26/2011)

---

this is really ridiculous, i specifically mentioned above that the...

It would be worth looking into, but he said they have a security policy that only SSIS can modify data on...

M.Kahn (7/26/2011)

---

Welsh Corgi (7/22/2011)

---

Yes, don't ask any...

The thing to keep in mind when comparing Access to SQL Server is that Access has all the same issues, but it hides them and tells you "Pay no attention...