Quick suggestion, slightly different but easy to scale on large number of columns

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

declare @sampledata Table

(

ID int

, [Date] Date

...

Quick thought, although not too efficient Jacob's xmlTable function could be what you are looking for.

😎

Or the other way around

😎

SELECT

T1.ID

,T2.XDATE

FROM dbo.TABLE1 T1

RIGHT...

I have only used this method on production 2008 and 2012, used it on testing 2014 it worked fine including the machine I'm writing this answer on.

😎

Simply enable Ole Automation Procedures

😎

--SHOW ADVANCED OPTIONS

EXEC sp_configure 'show advanced options',1;

RECONFIGURE WITH OVERRIDE;

-- ENABLE OLE AUTOMATION PROCS

EXEC sp_configure 'Ole Automation Procedures',1;

RECONFIGURE WITH OVERRIDE;

-- HIDE ADVANCED OPTIONS

EXEC sp_configure 'show advanced options',0;

RECONFIGURE...

Eirikur Eiriksson (7/21/2016)

---

Quick question, if the date is earlier than the 1st of April then should it return the year - 2 or -3?, i.e.

a) 2016-01-01 ==> 2014-04-01...

Quick questions, do you have recent good backups? What did you try before using REPAIR_ALLOW_DATA_LOSS?

😎

This shouldn't be too hard, even calling the web service from SQL Server is straight forward, here is an example function from this thread

😎

CREATE function [dbo].[GetHttp]

(

@url...

Done this or similar to this since 4.2, haven't forgotten it yet;-)

😎

Quick suggestion

😎

/* -- ENABLE XP_CMDSHELL

EXEC SP_CONFIGURE 'show advanced options', 1

RECONFIGURE WITH OVERRIDE;

EXEC SP_CONFIGURE 'xp_cmdshell',1;

RECONFIGURE WITH OVERRIDE;

*/

DECLARE @services TABLE

(

SRV_TXT NVARCHAR(150) ...

Only one modification can be made at a time with the XML modify method, the workaround is to reconstruct the XML and replace the previous value, here is a quick...

Good stuff! Here is a quick example which should get you passed this hurdle

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

IF OBJECT_ID(N'dbo.request_log') IS NOT NULL DROP TABLE dbo.request_log;

CREATE TABLE dbo.request_log(

[id] [int] IDENTITY(1,1) NOT NULL,

[request_id]...

Quick question out of curiosity, why would you move this into the SSIS dataflow when it will most likely be both simpler and faster when done at the SQL Server...

Quick question, if the date is earlier than the 1st of April then should it return the year - 2 or -3?, i.e.

a) 2016-01-01 ==> 2014-04-01 (21 months)

...

zenm (7/21/2016)

---

I have a table used for logging. Let's say this table contains log entries related to requests processing so there is a column 'request_id' identifying request a log entry...