You probably want to use a substitution table,

Like this:

--====== Create a substitution table:

Create Table #SSNSubs(

SSN int,

Subs int,

CONSTRAINT PK_SSNSubs_1

PRIMARY KEY CLUSTERED (SSN))

GO

--====== Get...

OK, I think I know what this one is...

Try this:

Select distinct CAST(TextCol as Varchar(MAX))

Can you provide us with an example so that we can see what work-arounds might be applicable?

Oops, almost forgot: Dynamic execution also provides Turing-completeness.

magarity kerns (8/12/2008)

---

Whoa there! SQL would not be Turing complete without GOTO -...

Wow. This obtuse defense of cursors and RBAR has more hand-waving than a Michael Jackson concert. Practically every other post here has statements to the the effect that...

Yeah, I knew that Gus. Sorry if it looked like I was responding to you, I think...

What does profiler say about the Insert code?

Milu (8/11/2008)

---

your code...

Create View vwRecursiveAW AS

WITH DirectReports(ManagerID, EmployeeID, EmployeeLevel) AS

(

SELECT ManagerID, EmployeeID, 0 AS EmployeeLevel

FROM AdventureWorks.HumanResources.Employee

WHERE ManagerID...

Jack Corbett (8/11/2008)

---

In SSMS right-click on the database and select All Tasks - Generate Scripts. First you should go to Tools -> Options -> Scripting and make sure all...

You can pretty much take any CTE example out of BOL (Books On-Line) and just put a "CREATE VIEW..." in front of it.

Here is a recursive example:

Create View vwRecursiveAW AS

WITH...

Not like that, no. A recursive CTE has to follow a format that has a...

Of course a View itself can contain a CTE also.

chandima_panditha (8/11/2008)

---

For example, there's a stored procedure (which calls some views and UDFs) which takes only few seconds to run in SQL server 2000, but it takes more than 3...

Maybe it would be easier for you to list all of the characters that are acceptable?