What's next, business holidays and weekends? 😀

Just for the sake of completion:

SELECT Eventdate,Status

INTO #AP_DATA

FROM (VALUES

('2014-01-20 18:00', 0)

,('2014-01-20 18:30', 0)

,('2014-01-20 19:00', 1)

,('2014-01-20 19:30', 0)

,('2014-01-20 20:00', 1)

,('2014-01-20 20:30', 0)

,('2014-01-20 21:00', 0)

,('2014-01-20 21:30',...

ado-712642 (4/5/2014)

---

SSC thank you for your reply. I just tried using this in my table and am a bit confused. If my table structure is like this, what...

J Livingston SQL (4/5/2014)

---

are these just for 2012?

I "thought" that UNBOUNDED PRECEDING/FOLLOWING was introduced in 2012...so not available in 2008?

may well be wrong.

nevertheless it provide a solution...

I wonder what is...

Here is the code 😎

DECLARE @POLIGON GEOMETRY;

/* ms sample from BOL */

SET @POLIGON = geometry::STPolyFromText('POLYGON ((5 5, 10 5, 10 10, 5 5))', 0);

;WITH NN1(N) AS (SELECT NM.N FROM...

Lets do both with the same solution

😎

/* SAMPLE DATA */

SELECT

X.NUM

INTO #MY_NUMBERS

FROM

(

...

Join the two tables and use ISNULL/COALESCE to replace NULLs

😎

DECLARE @TABLE_A TABLE

(

SNO INT ...

AndrewSQLDBA (4/4/2014)

---

Hello Everyone

Happy Friday

I am dealing with what I believe is Oracle that is the source of a SQL View.

I am seeing a data type of Integer in the View,...

This can be done by shifting each point on the line by x and y (@OFFSET_X/Y in the code)

😎

DECLARE @line geometry = 'LINESTRING(1 1, 2 2, 3 3, 4 4,...

Use a CTE or a table with the additional email addresses to be added, cross join to a filtered set with code replacement and union the result to the original...

WayneS (4/3/2014)

---

Eirikur,

This is an excellent modification to an already excellent function. Very well done!!! (And it was such a simple change at that.)

Jeff Moden (3/24/2014)

---

Eirikur asked me to review it...

Ran your example through on

http://xslttest.appspot.com/

noticed the grouping is incorrect, if it is on lccs/lcc/, you will get multiple lines of subtotal.

NaN could be null or empty string.

😎

What about SSDT (Sql Server Data Tools) ?

😎

Luis Cazares (4/3/2014)

---

Isn't that over complicating something that could be achieved like this?

SELECT PONum

,POLineNum

,POSublineNum

...

Straight forward using Window functions

DECLARE @POSTUFF TABLE

(

PONum INT ...

Think of the columns in the group by as buckets, any aggregation is then applied to each bucket;

ColAColB

A1

B2

A2

B3

Group by ColA -> Aggregation on B

A (1,2)

B (2,3)

or in other words, it...