I can't stand living in Chicago anymore so, yes! If I have to live in the Midwest, Chicago is the place to be but I don't want to live in...

phingers (4/4/2016)

---

Hi,

I have an SSIS package which emails data in XML file format to an external company on a regular basis.

They have requested that we allow them access to our...

ben.brugman (4/4/2016)

---

Referenced sites and threads:

Any other advises here about extending the 8K version ?

...Remark, I started this new thread because I think this subject of enlarging the capacity of the...

DesNorton (3/31/2016)

---

Alan.B (3/30/2016)

---

This is the kind of thing that you can do with a Translate function (which T-SQL does not have). I generally don't like scalar UDFs but this guy...

Ed Wagner (3/31/2016)

---

Alan.B (3/30/2016)

---

This is the kind of thing that you can do with a Translate function (which T-SQL does not have). I generally don't like scalar UDFs but this...

ScottPletcher (3/31/2016)

---

Alan.B (3/30/2016)

---

Alan.B (3/30/2016)

---

ScottPletcher (3/30/2016)

---

Alan.B (3/30/2016)

---

ScottPletcher (3/30/2016)

---

Alan.B (3/29/2016)

Lastly, ditto the last Thursday of the month:

SET STATISTICS IO ON;

PRINT 'Old way:';

SELECT DISTINCT MAX([Date]) OVER (PARTITION BY [Year],[MonthName],[WeekdayName]) AS [Date]

FROM ...

Did you look at the Translate8K solution?

DECLARE @RandomString varchar(100) = '0123456789000';

SELECT dbo.Translate8K(@RandomString,'1234567890','ABCDEFGHI$');

-- Returns: $ABCDEFGHI$$$

If you are just pulling out the email addresses this is certainly something that can be resolved with a simple splitter, CHARINDEX, PATINDEX and a couple other simple tricks. I'll...

Sergiy (3/30/2016)

---

Solution is suprisingly simple.

1. Create a "translation" table:

CREATE TABLE #Mapping (

FromChar NCHAR(1) PRIMARY KEY,

ToChar NCHAR(1)

)

INSERT INTO #Mapping ( FromChar, ToChar )

SELECT 1, 'A'

UNION ALL

SELECT 2, 'B'

UNION ALL

SELECT...

Powershell is cool. I only worked with it once for about 10 weeks scripting out a SQL Server Install in the Google cloud using the Google SDK. As some people...

This is the kind of thing that you can do with a Translate function (which T-SQL does not have). I generally don't like scalar UDFs but this guy is faster...

Alan.B (3/30/2016)

---

ScottPletcher (3/30/2016)

---

Alan.B (3/30/2016)

---

ScottPletcher (3/30/2016)

---

Alan.B (3/29/2016)

Lastly, ditto the last Thursday of the month:

SET STATISTICS IO ON;

PRINT 'Old way:';

SELECT DISTINCT MAX([Date]) OVER (PARTITION BY [Year],[MonthName],[WeekdayName]) AS [Date]

FROM ...

ScottPletcher (3/30/2016)

---

Alan.B (3/30/2016)

---

ScottPletcher (3/30/2016)

---

Alan.B (3/29/2016)

Lastly, ditto the last Thursday of the month:

SET STATISTICS IO ON;

PRINT 'Old way:';

SELECT DISTINCT MAX([Date]) OVER (PARTITION BY [Year],[MonthName],[WeekdayName]) AS [Date]

FROM dbo.itvf_CALENDAR('01/01/2014','12/31/2014')

WHERE...

ScottPletcher (3/30/2016)

---

Alan.B (3/29/2016)

Lastly, ditto the last Thursday of the month:

SET STATISTICS IO ON;

PRINT 'Old way:';

SELECT DISTINCT MAX([Date]) OVER (PARTITION BY [Year],[MonthName],[WeekdayName]) AS [Date]

FROM dbo.itvf_CALENDAR('01/01/2014','12/31/2014')

WHERE ...

girl_bj (3/29/2016)

---

It will be continuous. I am just testing for 1 month on how it works. The weekly data will be send as an output file.

Is there any way that...