The two ways that one could interpret this, Many2Many and One2Many both imply min=0 and max=(inf.)

😎

R2 => Many to many, min=0,max=(inf)

+-----------+ +----+...

Quick solution based on an inline tally driven calendar table, should get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @DATE_FROM DATETIME = '2013-12-10 04:00:00.000';

DECLARE @DATE_TO DATETIME = '2014-12-10...

Thank you for the question Shiva, straight forward even if the wording could have been more precise;-)

Another interesting thing is that the option "ALLOW UPDATES" is depreciated and has in...

locus (12/13/2014)

---

Hi folks,

We have recently imported a database from Informix into 2008 R2, via linked server.

Everything came across perfectly with the exception of Time Interval columns.

Format 00:00:00, hours minutes seconds.

SQL...

Quick thought, (and in-line with other responses), when opening SSMS do "Run as Administrator"

😎

Quick question, what is the output of this query?

😎

EXEC sp_configure 'show advanced options',1;

RECONFIGURE;

EXEC sp_configure 'Ad Hoc Distributed Queries';

EXEC sp_configure 'show advanced options',0;

RECONFIGURE;

sKreetz! (12/11/2014)

---

Thanks for the quick reply, Eirikur! It worked like a charm and I appreciate the help. As Sean mentioned, users may change their mind and remove line certain line...

Ashish Dutt (12/11/2014)

---

Thanks Eirikur for your response.

But I'm greeted with the following error on executing the query you posted.

Msg 102, Level 15, State 1, Line 13

Incorrect syntax near 'b'.

The error...

There are few ways of doing this, here is a quick window function solution for SQL Server 2012/14

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE TABLE dbo.TBL_LABEL

(

...

Quick thought, switch from group by to window function with output de-duplication

😎

use MICE

SELECT

*

into School_Perform_Data_2020

FROM

(

select

ROW_NUMBER() OVER

(

...

My advice is to go for...

Quick thought, looks like somewhere in the dataflow a column or set of columns are defined as unicode (65001), look out for DT_WSTR or DT_NTEXT in the column properties.

😎

Further on Grant't post, here's a code snip for retrieving the execution plan

😎

USE tempdb;

GO

SET NOCOUNT ON;

/*

The query

*/

select

*

from sys.objects

/* get the execution plan */

;WITH XMLNAMESPACES...

Sean Lange (12/11/2014)

---

This looks pretty close to mine. Just before I posted my solution I saw that the OP wanted the closest date that...

Quick and simple row_number solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#TestTable') IS NOT NULL DROP TABLE #TestTable;

SELECT PK, Terminal, MarketDate = CAST(d.MarketDate AS DATETIME)

,d.Prod, d.Cost

INTO #TestTable

FROM (

SELECT 1, 1, '2014-12-01 15:04:00.000','A', 2.23...