tim.oliver (9/11/2013)

---

Yay - thats great Mark! many Thanks, and apologies for not following the right way to set up the questionin the first place - I will definately try and...

Why does it have to be dynamic?

SET DATEFORMAT DMY;

DECLARE @t TABLE(Grp CHAR(2), dt Date);

INSERT INTO @t(Grp,dt)

VALUES

('00' , '28-10-2012'),

('10' , '29-10-2012'),

('10' , '28-10-2012'),

('10' , '28-10-2012'),

('20' , '30-10-2012'),

('20' , '05-11-2012'),

('20' , '10-11-2012'),

('20' , '30-10-2012'),

('30' , '12-11-2012');

SELECT t.Grp,

...

DECLARE @s-2 VARCHAR(20)

SET @s-2 = ' =10 02=5608= '

SELECT LEN(@s) - LEN(LTRIM(@s))

Probably not the best way, but seems to work

SELECT DISTINCT

Grp_A, Grp_B, Grp_C,

SUM(Val_A) OVER(PARTITION BY Grp_A, Grp_B,...

Here's another

WITH CTE AS (

SELECT

r.RequestId

,q.QuoteId

,r.EmailAddress

,q.CreatedAt

,CASE

WHEN...

Sean Lange (9/4/2013)

---

Well this post is my 10,000th point. I guess I have proved I too can waste lots of time answering forums posts instead of doing my actual job....

SELECT t1.CustomerName AS Customer,

STUFF((SELECT ',' + t2.Status AS "text()"

FROM dbo.Customers t2

...

Yep, correct.

and then why is the not...

Try this

WITH Source AS (

SELECT d.id,

CAST (d.DetVal AS XML) AS DetVal,

d.Detid,

...

Try this

DECLARE @x XML = '

<feed xmlns:im="http://itunes.apple.com/rss" xmlns="http://www.w3.org/2005/Atom" xml:lang="en">

<id>https://itunes.apple.com/AU/rss/topalbums/limit=10/xml</id&gt;

<title>iTunes Store: Top Albums</title>

<entry>

<updated>2013-08-28T03:55:45-07:00</updated>

<title>Paradise Valley -...

Is there some significance in 'AA' in Danish/Norwegian? It seems to sort after 'Z'

SELECT X

FROM (VALUES ('A'),('AA'),('B'),('BB'),('C'),('CC'),('Z')) T(X)

ORDER BY X COLLATE Latin1_General_CI_AS

SELECT X

FROM (VALUES ('A'),('AA'),('B'),('BB'),('C'),('CC'),('Z')) T(X)

ORDER BY X COLLATE Danish_Norwegian_CS_AS

SELECT c.AddressID,

c.AddressOptin,

c.CustomerID,

(

SELECT...

WITH CTE AS (

SELECT AgentID, ExcepCodeDetailName, Detail_Start_Time, Detail_End_Time,

ROW_NUMBER() OVER(PARTITION BY AgentID ORDER BY Detail_Start_Time) AS rn

FROM @testing)

SELECT AgentID, ExcepCodeDetailName, Detail_Start_Time, Detail_End_Time

FROM...

Clumsy but appears to work

SELECT t1.Lvl,t1.Level1_pk_id,t1.Level2_pk_id,t1.Level3_pk_id

FROM #Temp t1

WHERE NOT EXISTS(SELECT * FROM #Temp t2

...