Assuming the shift pausetimes don't overlap, this should give the worktimes

DECLARE @tblSchema TABLE (Shift INT, Code INT, dtBegin DATETIME, dtEnd DATETIME)

INSERT INTO @tblSchema(Shift,Code,dtBegin,dtEnd)

VALUES

(1, 1, '20130611 06:00:00', '20130611 14:21:00'),

(1, 11, '20130611...

You might want to try this sort of query instead

SELECTid, oracle_id, field1, field2, field3, field4,

COUNT(*) OVER(PARTITION BY field1,...

I suspect you could use sp_getapplock / sp_releaseapplock here

... and identical solutions too!

DECLARE @Graph_Range TABLE(Start_Range FLOAT, End_Range FLOAT);

INSERT INTO @Graph_Range(Start_Range, End_Range)

VALUES (0.10, 0.20), (0.20, 0.30), (0.30, 0.40);

DECLARE @Graph_data TABLE(Asset_Value INT, factor FLOAT, [Case] INT);

INSERT INTO @Graph_data(Asset_Value, factor, [Case])

VALUES (500, 0.12, 1),(270, 0.13,...

Another way

with cte as (

select [State], County, Sex, class,

case when Agegroup in ('15-17 yrs', '18-20 yrs', '21-24 yrs') then '15-24 yrs' else Agegroup...

Try this

DECLARE @t TABLE(ID INT, X XML)

INSERT INTO @T(ID,X)

VALUES(1,'<root>

<name1 row = "1" value ="1" />

<name2 row = "1" value ="2" />

<name1 row = "2" value ="3" />

<name2 row = "2"...

Try changing

'20130401' + 90

to

CAST('20130401' AS DATETIME) + 90

Here's a SQL Server 2012 version

WITH CTE AS (

SELECT number,

am_sw,

MAX(cc_sw) OVER (PARTITION BY number

...

SELECT

context_id

,a.alias.value('(KeyValueId/text())[1]','Varchar(20)') AS 'KeyID'

,a.alias.value('(Value/text())[1]','Varchar(20)') AS 'Value'

,a.alias.query('.') AS 'Node'

FROM (

.

.

.

Very inefficient but gives correct results

SELECT Students AS Name,

CASE WHEN COUNT(*) > 1 THEN 'Y' ELSE 'N' END AS IsASequence,

...

mister.magoo (5/28/2013)

---

Sean Lange (5/28/2013)

---

dwilliscp (5/28/2013)

---

If you have a record, where there are 12 columns, one for each of the last 12 months, and you want to use STDEVP, how would...

Without DDL, sample data and expected results this is just a guess....

select right(convert(varchar, CCD.startDateTime , 106), 8) as startmonth,

sum(case when CCD.contactDisposition=1 then 1 else 0 end) as...

Change

partition by fk_stationid

to

partition by fk_stationid , AdDate

SELECT AdDate, AdTime, FK_StationId, CAST(rank() over(partition by fk_stationid order by addate,adtime) AS VARCHAR(10)) + ' of ' +

...