Here's a live topic on the subject.

If you are using the output of an APPLY block as the input for another then you are likely to find a performance hit after x "levels of nesting". x...

SQLNightOwl (2/11/2016)

---

You may want to consider performance differences between using an IN and an INNER JOIN

select columns

from dbo.sometable

where ItemCode in (select Item from #tempTable)

-- AND --

select columns

from dbo.sometable st

inner

join...

Junglee_George (2/11/2016)

---

The hierarchy is there in the container data.

The result of #content shows the actual container level hierarchy in the container list starting with the top most level container.

If...

Junglee_George (2/11/2016)

---

I am using this particular query for an SSRS report

It has two multivalue parameters Partners and containers

When the user selects 45 partners and 42 corresponding containers, the performance issue...

Can you describe in words exactly what the code is supposed to do? It looks like you have a hierarchy in there - have you explored some of the more...

Orlando Colamatteo (2/10/2016)

---

ChrisM@Work (2/10/2016)

---

If it's only one, then the original scalar function returning the result to a variable would have been just fine - and it would have met Gail's...

Further details will need to be provided! Minimum requirements:

CREATE TABLE scripts for all tables.

INSERT scripts to populate those tables with a few rows of data.

A script to...

GilaMonster (2/10/2016)

---

ChrisM@Work (2/10/2016)

---

GilaMonster (2/10/2016)

---

My comments had nothing to do with what the function returns, rather where to use it (not in...

GilaMonster (2/10/2016)

---

My comments had nothing to do with what the function returns, rather where to use it (not in a DML...

Orlando Colamatteo (2/9/2016)

---

Like this:

CREATE FUNCTION dbo.fnPressGaneyDownload()

RETURNS TABLE AS

RETURN (

SELECT CAST(

...

Eirikur Eiriksson (2/8/2016)

---

Sean Lange (2/8/2016)

---

Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second...

Sean Lange (2/8/2016)

---

Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time in...

Charmer (2/8/2016)

---

OMG,

I am sorry, Chris. The script is still wrong.

Just see the screen shot attached in here. The ID 4, having startdate '2016-01-27' should show '2016-01-26'

instead of '2016-01-27'. because we...

Charmer (2/8/2016)

---

Let me explain the requirement.

I have to show the output with the changes happened to the point of startdate.

If ID 1 has a start date of today, I have...