_watching (12/1/2015)

---

Having come across this, as a follow up if anyone's interested in benchmark comparisons, here's an easy to read posting:

http://cc.davelozinski.com/sql/like-vs-substring-vs-leftright-vs-charindex

which shows the speed differences between LEFT, RIGHT, LIKE, SUBSTRING,...

This code sample might help too:

DECLARE

@data VARCHAR(20) = 'Cap',

@DataToReplace VARCHAR(100) = 'cp',

@ReplacedWithData VARCHAR(100) = 'xy'

;WITH Itally AS (SELECT * FROM (VALUES (1),(2),(3),(4),(5),(6),(7)) d (n))

SELECT @data = REPLACE(@Data,SUBSTRING(@DataToReplace,n,1),SUBSTRING(@ReplacedWithData,n,1))

FROM iTally

WHERE n <=...

jkramprakash (11/24/2015)

---

I checked this query with my data.it is returning the following output.

SELECT last_sign_in_at,

CAST(DATEDIFF(yy, last_sign_in_at, GETDATE()) AS NVARCHAR(4)) + ' years, ' +

CAST(DATEDIFF(m, last_sign_in_at, GETDATE()) AS...

PHXHoward (11/24/2015)

---

Absolutely the query should be rewritten but it is TG week and the person is out of the office all week.

It would be useful for me to...

Not really, he was warned of this...

As others have...

PHXHoward (11/23/2015)

---

They are using it to create an export of the column to a text file. The _ + primary key is how they want to label the file...

michal.lisinski (11/24/2015)

---

Hi

Please clarify, you want to return digits "1 year" or "one year"?

Beside of question above ,small example:

SELECT name,

CAST(DATEDIFF(yy, create_date, GETDATE()) AS NVARCHAR(4)) + ' years, ' ...

jkramprakash (11/24/2015)

---

I have the table name of User_Details.It contains the column of User_Last_Login_Date.

User_Last_Login_Date

-------------------------

2015-10-01

2015-11-20

2014-01-12

So i want to calculate the date difference with today date in the form of years,...

Jason-299789 (11/19/2015)

---

Jeff,

Thank you for the feedback on the TOP 100 Percent, I do try and avoid it whenever possible, but I know ORDER BY is not allowed in CTE's without...

Always test:

DROP TABLE #SampleData

SELECT *

INTO #SampleData

FROM (VALUES

(1, 'Name_A', CAST('des_kakà' AS NVARCHAR(20))),

(2, 'Name_B', CAST('des_kaka'...

Shamelessly nicking Jeff's sample data:

--===== If it exists, drop the test table to make reruns easier in SSMS.

-- This is NOT a part of the solution.

IF OBJECT_ID('tempdb..#TestTable','U') IS NOT NULL...

Use UNICODE() instead of ASCII():

DECLARE @C NVARCHAR(10),@R NVARCHAR(10)

SELECT @C=N'12'

SELECT @R=N'12'

SELECT @C, UNICODE(@C), @R, UNICODE(@R)

-- don't forget that you are only comparing the first character of each string.

Is t1 a #temp table?

Huh?