In the APPLY block, cast r.id to varchar(n),...

SUM() OVER() would preserve rows.

ChrisM@Work (8/19/2015)

---

serviceaellis (8/18/2015)

---

Please see attached.

The worksheet is the result that needs to be produced with the highlighted row.

in the Access file the two tables are:

1. PersonMembership - with all the...

It wasn't clear.

You should change the datatype to datetime as a matter of priority.

Did you run the...

Datatype of what?

The south east appears to be still quite bouyant after a peak in June/July. There used to be a lot of activity based around Exeter but I haven't seen any...

Your result set shows two different photo id's for the same user id. Try using APPLY to return a single row from the photos table, like this:

SELECT

p.Id [SenderId],

p.Username,...

thenewbee (7/22/2015)

---

Hi All,

I am working on a legacy application and one of the view has degraded performance. I have to fix it,

but the query execution makes me mad as it...

Yes. Create covering indexes for both tables, something like this:

CREATE INDEX...

Eirikur Eiriksson (6/28/2015)

---

ChrisM@home (6/28/2015)

---

This is about the simplest rCTE that I can think of. No 8k pages anywhere yet Statistics IO reports logical reads:

SET STATISTICS IO ON;

WITH rCTE AS (

SELECT...

This is about the simplest rCTE that I can think of. No 8k pages anywhere yet Statistics IO reports logical reads:

SET STATISTICS IO ON;

WITH rCTE AS (

SELECT n = 1

UNION...

Try...

pjn (6/23/2015)

---

Not sure? if this is ever going to be possible, but I'm trying to do a dynamic join on EXECUTE, but the execution string has to come from a...

lmarkum (6/19/2015)

---

I have an UPDATE statement that joins two table by SendId. One table, I'll call it T1, has a clustered index on SendId ASC. The other table...

GilaMonster (6/4/2015)

---

ChrisM@Work (6/4/2015)

---

spectra (6/4/2015)

---

Ok. not an issue. Is it possible to write this in pure SQL way ? (so that I don't face database migration issue later)

My...