Viewing 15 posts - 1,186 through 1,200 (of 8,731 total)
June 20, 2017 at 6:47 am
That's great Eirikur.
I wasn't in the mood of creating a new string to hex function (not much use on my side), so I used what was available.
June 20, 2017 at 6:19 am
Here's a reduced version of your query. It should be equivalent, but test it as I might have made a mistake due to the lack of sample data.
[code...
June 19, 2017 at 2:28 pm
I don't like the use of a scalar function, but this might help.
DECLARE @m NVARCHAR(max)= N'\u0633\u0644\u0627\u0645';
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
June 19, 2017 at 1:22 pm
I stumbled across some SQL code which seems to transpose record data into a single...
June 19, 2017 at 9:51 am
No need to add subqueries when you have the information available by reading the table once.
SELECT
A.Custom2 as State,
BCNT = COUNT(CASE WHEN A.Defecttype...
June 19, 2017 at 9:19 am
June 19, 2017 at 8:07 am
June 19, 2017 at 7:08 am
sks_989 - Friday, June 16, 2017 1:45 PMthere will be leading 0 like this way 0930 or 0700
Then it's easy. Here's an...
June 16, 2017 at 2:21 pm
June 16, 2017 at 1:50 pm
I have 2 column first column in this Format YYYYMMDD and second column as HHMM...
June 16, 2017 at 1:41 pm
As you're only approaching to the nearest 16th, I'm using a bit of hard-coding. I've also changed the function into an In-Line Table-Valued Function. These functions are extremely fast and...
June 16, 2017 at 12:55 pm
I'd commonly use the option described by Jacob. However, if the conditions are too complex, I use a CTE or subquery.
--Option 1
SELECT m.StockCode,
June 16, 2017 at 7:02 am
jasona.work - Thursday, June 15, 2017 1:29 PMNo wonder I'm not making more money...
I'm indenting wrong:
https://arstechnica.com/information-technology/2017/06/according-to-statistics-programming-with-spaces-instead-of-tabs-makes-you-rich/
I wonder how does using tabs...
June 15, 2017 at 1:46 pm
June 15, 2017 at 1:42 pm
Viewing 15 posts - 1,186 through 1,200 (of 8,731 total)