Look at PIVOT operator http://technet.microsoft.com/en-us/library/ms177410(v=SQL.105).aspx

SELECT [row group level 2003 April] = [2003].April -[2002].April

FROM [Matrix Report] AS [2003]

JOIN [Matrix Report] AS [2002] ON [2003].[Unnamedcol] = 2003 AND [2002].[Unnamedcol] = [2003].[Unnamedcol] -1

If...

Hope he will not run delete statements without a where clause some day.

I see it's rather department administrator's problem rather then DB admin's problem.

"Besides, null values in the input of UNPIVOT disappear in the output."

Exactly. But it means 2 rows. 😉

Look at inline TVF http://technet.microsoft.com/en-us/library/ms189294(v=sql.105).aspx

Use dates functions, dateadd() namely.

declare @Month varchar = '01'

declare @Year varchar = '2014'

select starDt = CAST(@Year + @Month +'01' as Date), endDt = dateadd(dd,-1,dateadd(mm,1, CAST(@Year + @Month +'01' as...

SELECT Incident, cnt = COUNT(distinct ID)

FROM Sampledata

GROUP BY Incident

HAVING COUNT(distinct ID) > 1

inevercheckthis2002 (10/14/2014)

The latest time for an event in the source table. Basically, I would like to record all of the changes to the source table by creating another...

Don't you need group by / partition by V1 ?

ot 60857, for

INSERT INTO @PersonTime

SELECT 1, 1001, 23, '10/13/2014 8:00:00', '10/13/2014 8:30:00' UNION ALL

SELECT 11, 1011, 23, '10/13/2014 8:30:00', '10/13/2014 9:00:00'

your solution gives

232014-10-13 08:00:00.0002014-10-13...

Provided 15 min is a fixed step

create table #tbl ( V1 int, V2 datetime, V3 float);

insert into #tbl values (1,'2012-12-12 10:15', 12.5);

insert into #tbl values (1,'2012-12-12 10:30', 2.5);

insert into...

So timestamp is allowed to be not 15 minutes aligned? Or is it a misprint?

Try

SET DATEFORMAT mdy;

DECLARE @PersonTime TABLE

(

ID INT,

Person INT,

Room INT,

Coming DATETIME,

Going DATETIME

);

INSERT INTO @PersonTime

SELECT 1, 1001, 23, '10/13/2014 8:00:00', '10/13/2014 9:00:00' UNION ALL

SELECT 2, 1002, 23, '10/13/2014 8:05:00', '10/13/2014...

Eugene Elutin (10/7/2014)

UPDATE t1 SET CustomerLink = 0

FROM @Tmp t1

JOIN @Tmp t2

ON ...

To identify circles

DECLARE @Tmp TABLE (CustomerID INT, CustomerLink INT, PRIMARY KEY(CustomerID))

INSERT @Tmp

VALUES(100001,0)

,(100002,100001)

...