Viewing 15 posts - 301 through 315 (of 3,543 total)
:unsure:
November 6, 2017 at 2:10 am
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...
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...
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...
October 31, 2017 at 9:16 am
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...
October 25, 2017 at 7:07 am
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...
October 16, 2017 at 8:27 am
October 16, 2017 at 3:26 am
October 13, 2017 at 1:42 am
October 4, 2017 at 6:51 am
October 3, 2017 at 2:15 am
September 29, 2017 at 1:51 am
Or use Sqlcmd with [-e echo input] and [-o outputfile] options
p.s. Don't forget to batch the commands with GO
September 21, 2017 at 4:00 am
Viewing 15 posts - 301 through 315 (of 3,543 total)