is250sp (8/10/2016)

---

Alan.B (8/10/2016)

---

is250sp (8/10/2016)

---

I have a table with the following records.....

emplid effdt effseqjobcode

00001068 3/27/200500241

00001068...

Does this work for you?

DECLARE @myTable TABLE (empID INT, effdt DATETIME, effseq BIT, jobcode INT)

INSERT INTO @myTable

VALUES (00001068, '20050327', 0, 0241), (00001068, '20050327', 1, 0244), (00001070, '20050327', 0, 0241), (00001070,...

For your second requirement you can achieve that using a window function. If you want an example please provide DDL and sample data. Luis' signature has links on...

dallas13 (8/9/2016)

---

Hello I m trying to achieve something like this without patindex

DECLARE @source_path ...

Here is technically a two line solution (which can be only 1 if you don't use variables)... 😉

DECLARE @startDate DATE = '20160101', @skipWeeks TINYINT = 4, @maxWeeks TINYINT = 54

SELECT...

Hi David,

I think you have a typo in your values...shouldn't that 32 at the end be a 52?

Cheers,

Here's my stab at it...

DECLARE @startdate DATETIME = '20160101'

DECLARE @enddate DATETIME = '20161231'

;WITH Tally (n) AS

(

SELECT TOP (SELECT DATEDIFF(mi, @startdate, @enddate)) ROW_NUMBER() OVER (ORDER BY (SELECT...

TomThomson (8/4/2016)

---

I think the question should have specified SQL Server 2014 SP2 and noted that it applies in no other release.

There's a connect item asking for the...

Side

Ball

My MongoDB training starts today...there goes the neighborhood! :crazy:

Always a good thing to learn new skills but at my age I seem to forget more things than I take in....

Just a stab here but does this work?

select

CONVERT(TIME, DATEADD(ms, DATEDIFF(ms, last_request_start_time, GETDATE()), 0), 114) AS Duration,

*

from sys.dm_exec_sessions

where (status <> 'sleeping' or open_transaction_count > 0)

order by last_request_end_time...

Big Bang

Efficient

ajspencer (7/27/2016)

---

Hi Luis, Thanks for responding so quickly. I tried using top 1 however it didn't return the results expected. I've attached a *.png file to show what the data...