Somebody has to mention that you should never end up in this situation in the first place because nested views are a performance timebomb.

Phil Parkin (11/11/2016)

---

I'm not sure for how many more years...

spam reported

coool_sweet (11/9/2016)

---

hi

i have 1 table like this

table A

Product_ID name desc

123 ...

Jeff Moden (11/6/2016)

---

jasona.work (11/2/2016)

---

Luis Cazares (11/2/2016)

---

I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

That...

Please don't cross post. It just confuses things.

the original question is here. http://www.sqlservercentral.com/Forums/Topic1831422-3739-1.aspx

Grant Fritchey (11/2/2016)

---

jasona.work (11/2/2016)

---

Luis Cazares (11/2/2016)

---

I'm not looking for a job, but I take a look at offers from LinkedIn every now and then just to see what's being offered/requested.

That...

This kind of query is going to return so many false positives I would think it would be more efficient to simply make a list of every procedure, view, function...

ps_vbdev (11/1/2016)

---

I have a FactOrder table that shows orders at order line grain. Our website allows users to favourite products before they are added to an order and then purchased....

jasona.work (10/31/2016)

---

Ed Wagner (10/31/2016)

---

Sean Lange (10/31/2016)

---

jasona.work (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Wryan138 (10/30/2016)

---

So in lieu of some marvelous SQL wizardry, I'm just trying to help out...

jasona.work (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Welcome aboard. I...

Luis Cazares (10/31/2016)

---

I believe that Sean means something like this:

SELECT TOP 1 *

FROM(

SELECT TOP 1

CONCAT(i.BatchId,+'_'+ i.Company+'_',ltrim(rtrim(i.[Accounting Period]))+'_nondlo.saf')

, 1

...

Here is one way you can force it to always return a single row.

select top 1

CONCAT(i.BatchId,+'_'+ i.Company+'_',ltrim(rtrim(i.[Accounting Period]))+'_nondlo.saf')

, 1 as SortOrder

FROM [Havebury].[RepairInvoice].[RepairInvoiceNONDLO] i

UNION ALL

select 'None'

, 2

order by SortOrder

TSQL Tryer (10/31/2016)

---

Hi,

I have the following -

SELECT

CASE

WHEN EXISTS ( SELECT CONCAT(i.BatchId,+'_'+ i.Company+'_',ltrim(rtrim(i.[Accounting Period]))+'_nondlo.saf')

...

ChrisM@Work (10/31/2016)

---

Sean Lange (10/31/2016)

---

Ed Wagner (10/31/2016)

---

ThomasRushton (10/31/2016)

---

Welcome aboard. I must admit, I do...