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...

Updating from a column value is equally simple, here is a quick sample, results are equal to the previous method.

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

CREATE...

One of the certainties of live: "There will always be wannabes"

😎

Quick example, should be enough to get you passed this hurdle

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_XML_MODIFICATION

(

XM_ID INT...

ocean3300 (7/20/2016)

---

This table has about 5M records and it takes about 300 milliseconds to execute below query. Just wondering if there are other ways do this for better performance?

SELECT MIN(Date),...

Turning the Azure SQL Databases on and off is not an option but you can throttle it down to a basic tier when not using it. The on/off option applies...

I have seen many of such solutions fail, OP, do you want to answer the questions I have asked or even better improve the scheme as suggested?

😎

Quick thought, foreign key constraint to the table from a pseudo table on a column with a default value constraint will do the trick.

😎

Edit: Typo

Quick suggestion, based on your questions I suggest you research those topics on BOL and come back if you have any further questions.

😎

There are quite few options here and each has it's pros and cons but to recommend any of those I would like to have more information as what may be...

Quick suggestion, add max on the values and group by the ID.

😎

Out of curiosity, why do you want to do...