Viewing 15 posts - 8,446 through 8,460 (of 8,731 total)
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...
September 7, 2012 at 2:43 pm
Shouldn't the splitting be done on the plus sign(+)? These look as adding formulas.
September 7, 2012 at 1:58 pm
Another suggestion.
SELECT STUFF( REPLACE( '+' + string, '+A#', '+C#'), 1, 1, '')
FROM(SELECT 'A#+AB#+BA#+B#' AS string) A
September 7, 2012 at 1:54 pm
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...
September 7, 2012 at 12:49 pm
For those running windows under Apple products.
How do you right click?
September 7, 2012 at 11:18 am
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...
September 7, 2012 at 11:04 am
Lynn Pettis (9/7/2012)
Andrew-495157 (9/7/2012)
Yes - I understand conversion and castingI wonder if you would re-read my previous post? To confirm what is in it.
What is to re-read? The...
September 7, 2012 at 10:54 am
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.
September 7, 2012 at 10:46 am
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
September 7, 2012 at 10:33 am
Does this thread helps you?
http://www.sqlservercentral.com/Forums/Topic1355365-391-1.aspx
September 7, 2012 at 10:18 am
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,
...
September 7, 2012 at 9:41 am
paul.knibbs (9/7/2012)
Steve Jones - SSC Editor (9/7/2012)
Luis Cazares (9/7/2012)
Four is overkill, but it's nice and symmetric for me.
Terry Pratchett would disagree--I saw a TV program which showed his main work...
September 7, 2012 at 9:26 am
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
September 7, 2012 at 8:28 am
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...
September 7, 2012 at 8:17 am
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...
September 7, 2012 at 7:25 am
Viewing 15 posts - 8,446 through 8,460 (of 8,731 total)