Am I overthinking?

EDIT: No, I'm undertesting.

DECLARE@Searchedchar(1),

@newchar(1)

SET @Searched = 'L'

SET @new = 'M'

DECLARE @test-2TABLE(

stringvarchar(1000))

INSERT @test-2

SELECT 'L@*K@*H@/324' AS string

UNION ALL SELECT '(AF#-AR#)*(Y#+BB#)'

UNION ALL SELECT 'TT#*(L#+D@)*L@'

UNION ALL SELECT '((AE#-AR#)*(Y#+A#))/Y#';

WITH cteTally(n) AS ( SELECT...

@Lowell

Shouldn't the splitting be done on the plus sign(+)? These look as adding formulas.

Another suggestion.

SELECT STUFF( REPLACE( '+' + string, '+A#', '+C#'), 1, 1, '')

FROM(SELECT 'A#+AB#+BA#+B#' AS string) A

I don't find any reference from Microsoft. Maybe you could find more if looking for Entity-Attribute-Value model.

There are several threads, the last one was this: http://www.sqlservercentral.com/Forums/Topic1348537-373-1.aspx

It's weird that is part...

For those running windows under Apple products.

How do you right click?

You might find this useful.

SELECTCAST( GETDATE() AS DATE),

DATEADD( DD,DATEDIFF(DD, 0, GETDATE()),0)

If you just need dates with no time, you should store them that way and even with the correct...

Lynn Pettis (9/7/2012)

What is to re-read? The...

Have you run the Upgrade Advisor? It might do what you need.

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

I'm not sure if some of the RedGate tools would help.

No, you put it outside the WITH statement.

Here's the reference to the syntax:

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

And here's is the example:

http://msdn.microsoft.com/en-us/library/dd776381(v=sql.105).aspx#OtherTables

Does this thread helps you?

http://www.sqlservercentral.com/Forums/Topic1355365-391-1.aspx

You never mentioned the subjects.

You have to add them to the query that constructs the basedata (the selects with union all).

with basedata (

name,

...

paul.knibbs (9/7/2012)

Steve Jones - SSC Editor (9/7/2012)

Terry Pratchett would disagree--I saw a TV program which showed his main work...

To understand the WITH basedata, you should read this:

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

and this:

http://msdn.microsoft.com/en-us/library/ms190766(v=SQL.105).aspx

My dream machine needs a balance between portability and horsepower.

With portability comes a long lasting battery. I've had some Dell laptops (Inspiron) with a battery that won't even last 2hours...

What are you trying to do?

Are you trying to store a date in an int column? Please, don't do it.

If you try to use the query you posted, it won't...