Making way for the new CONCAT function in...

This query uses the LAG function;

select t1.ClientID, t1.Rn, t1.EndMonth

,t1.OrderAmt

,LAG(t1.OrderAmt,1,0) OVER

(

PARTITION BY ClientID

ORDER BY EndMonth ASC

) AS ...

Not to mention all the fish 😀

Can you provide any DDL?

Look into STPointN and other Geography/Geometry functions.

Very interesting, wouldn't jump to any conclusions yet, what are the server specs? Disk and mem I/O?

Using Bob's DDL, here's a Window function version

CREATE TABLE #tmp(id int,

dt date);

INSERT INTO #tmp

VALUES(53,'2014-01-01'),...

Jonathan Marshall (3/24/2014)

---

Hey guys,

Looking to pass in the @targetDbName into the Open Query.

The target DB is PostGres and requires 2 single quotes around the dataset name.

Is this...

Thanks Dwain :Wow:

this time the answer is 44 😎

Simple as

select char(39) + column + char(39)

Jeff Moden (3/24/2014)

---

Eirikur asked me to review it (seems like a couple/three months ago) and I'm tickled...

ChrisM@Work (3/24/2014)

---

The article isn't always easy to follow and might be helped by this:

DECLARE @pString VARCHAR(8000), @pDelimiter CHAR(1);

SELECT @pString = 'The,quick,brown,fox', @pDelimiter = ',';

WITH E1(N) AS (

...

touché

Same query as before with the addition of a conditional statement to format the output.

with Groups as (

select 1 as GroupId,'Oracle' as GroupName,0 as IdParentGroup union all

select 2 as GroupId,'Microsoft'...

Or in other words

with Groups as (

select 1 as GroupId,'Oracle' as GroupName,0 as IdParentGroup union all

select 2 as GroupId,'Microsoft' as GroupName,0 as IdParentGroup union all

select 3 as GroupId,'IBM' as GroupName,0...