WITH a (NMI,StartDate,ID,[Desc],EndDate,RowNum) AS (

SELECTNMI,StartDate,ID,[Desc],EndDate,ROW_NUMBER() OVER (ORDER BY NMI,StartDate) AS [RowNum]

FROMTempTest

)

SELECT a.NMI,a.StartDate,a.ID,a.[Desc],a.EndDate,a.RowNum,b.StartDate AS [NextStartDate],b.EndDate As [NextEndDate]

FROM a

LEFT JOIN a b ON b.NMI=a.NMI AND b.RowNum=a.RowNum+1

Can you post the data you used?

Yeah and you could go outside and the solution would look...

Meh! By then it will...

OK try replacing WHERE line with

WHERE timestampCompleted >= DATEADD(hour,6,DATEADD(minute,30,@startDate))

Sorry error in Day calc

Try the posted code now.

Try replacing

CAST(timestampCompleted as TIME)

to

CONVERT(char(8),timestampCompleted,108)

Changed the code add FROM clause

Sorry my bad :blush:

Was in a hurry and...

DECLARE @startDate datetime;

SET @startDate = '2011-03-01 00:00:00.000';

DECLARE @endDate datetime;

SET @endDate = '2011-03-03 00:00:00.000';

SELECT [Day],

SUM(CASE WHEN [Type]='T' AND Shift=1 THEN 1 ELSE...

If I understand you correctly then you cannot have a single ID in your third table as a FK to two other tables (predios & fogos) unless the ID exists...

To do this you will have to use dynamic sql, ie

DECLARE @sql varchar(500)

SET @sql = 'select * from OPENQUERY(XHMNDGHFYUHFGHJFFRJF,''select {[Employee].[Dept].[Dept]*[Employee].[Empno].[Empno]} on 1,[Measures].[Salary] on 0 from [Employee] where [Employee].[Empname].&'+@name+''')'

EXEC (@sql)

You're welcome 🙂

The patindex is checking for two chars _ and space

charindex('_', @a) will return position of first _ char

patindex('%[ _]%', @a) will return position of EITHER _ or space

charindex('_', @a) and...

Depending on how and where the data is retrieved you could use sql CASE statement, ie

UPDATE ...

SET col15 = CASE

WHEN col2 >= 'V000' AND col2 < 'Y99 ' THEN col2

WHEN...