Viewing 15 posts - 301 through 315 (of 3,544 total)
Jeff Moden - Sunday, November 5, 2017 11:46 AMI'll also say that I'd never tell someone that they're "just" a Developer.
Oh...
Far away is close at hand in the images of elsewhere.
Anon.
November 6, 2017 at 2:19 am
:unsure:
Far away is close at hand in the images of elsewhere.
Anon.
November 6, 2017 at 2:10 am
Far away is close at hand in the images of elsewhere.
Anon.
November 2, 2017 at 4:16 am
I don't use configurations (Configuration files) in my packages, I develop and test them on my dev system and change any data source entries in the SQL job steps in...
Far away is close at hand in the images of elsewhere.
Anon.
November 2, 2017 at 3:30 am
Haven't tested it but that looks to be the ticket.
Except it will not handle repeats of 3 or more, this should though
WITH cte AS (
SELECT...
Far away is close at hand in the images of elsewhere.
Anon.
October 31, 2017 at 10:50 am
WITH cte AS (
SELECT t.N,SUBSTRING(@Str,N,1) AS [C],
ROW_NUMBER() OVER (PARTITION BY SUBSTRING(@Str,N,1) ORDER BY t.N DESC) AS [RowNum]
FROM dbo.Tally t
WHERE t.N <= LEN(@Str))
SELECT TOP(1) C
FROM cte
WHERE RowNum...
Far away is close at hand in the images of elsewhere.
Anon.
October 31, 2017 at 9:16 am
Far away is close at hand in the images of elsewhere.
Anon.
October 27, 2017 at 2:50 am
A huge thanks for your reply Jeff.
Sorry for the delay in replying
1.
Approx 75% of current email adresses are between 20 and 30 chars but I will increase the size...
Far away is close at hand in the images of elsewhere.
Anon.
October 25, 2017 at 7:07 am
Far away is close at hand in the images of elsewhere.
Anon.
October 19, 2017 at 9:33 am
I have never used it but according to the spec referenced you are using the wrong quotes, you need to use single quotes as described and two of them within...
Far away is close at hand in the images of elsewhere.
Anon.
October 16, 2017 at 8:27 am
Far away is close at hand in the images of elsewhere.
Anon.
October 16, 2017 at 3:26 am
Far away is close at hand in the images of elsewhere.
Anon.
October 13, 2017 at 1:42 am
Far away is close at hand in the images of elsewhere.
Anon.
October 4, 2017 at 6:51 am
Far away is close at hand in the images of elsewhere.
Anon.
October 3, 2017 at 2:15 am
Far away is close at hand in the images of elsewhere.
Anon.
September 29, 2017 at 1:51 am
Viewing 15 posts - 301 through 315 (of 3,544 total)