Luis Cazares (12/15/2016)

---

TomThomson (12/15/2016)

---

The quasi-BNF for inline TVFs at the CREATE FUNCTION (Transact-SQL) page is quite amusing: it gives you four options for the parentheses: have both, have neither, have...

Luis Cazares (12/15/2016)

---

ChrisM@Work (12/15/2016)

---

Luis Cazares (12/15/2016)

---

I've never written an iTVF using parenthesis around the query. However, the other answers were completely wrong and the correct answer states that it can...

Luis Cazares (12/15/2016)

---

I've never written an iTVF using parenthesis around the query. However, the other answers were completely wrong and the correct answer states that it can not that it...

sgmunson (12/15/2016)

---

ChrisM@Work (12/15/2016)

---

yuvipoy (12/15/2016)

---

Hi

Error converting data type nvarchar to float is returning

Select Convert(mycolumn as float) from mytable;

mycolumn is nvarchar(100)

but my destination table is float , so i am...

yuvipoy (12/15/2016)

---

Hi

Error converting data type nvarchar to float is returning

Select Convert(mycolumn as float) from mytable;

mycolumn is nvarchar(100)

but my destination table is float , so i am converting to...

Indianrock (12/14/2016)

---

Yes ORM-generated sql. Ours is a version called Domain Objects written by a former developer here. Others include Entity Framework and Hibernate. That sql code...

Shekhu (12/15/2016)

---

Your query is spending maximum time in Sorting the data. I checked your view and I see it uses "TOP 100 PERCENT " ... If you are getting 100...

ffarouqi (12/14/2016)

---

Hi all,

I've been looking into this query and trying to see if there is any better way to write or enhance performance on these queries. Client states that these...

The "correct answer" (This can return a table from a query inside of a RETURN statement surrounded by parenthesis) is sneaky. Using ssc's most popular inline function as an example,...

Also:

SELECT

ra.AgreementSerial,

0-SUM( -- check that your brackets are unambiguous

(A.[Plastics Turnover value] * x.Plastics)

- (A.[Heating Spares Turnover Value] * x.HeatingSpares)

- (A.[Boiler Turnover Value] * x.Boilers)

- (A.[Copper Turnover Value]...

SELECT

ra.AgreementSerial,

SUM(- (((((PlasticsTV - HeatingSparesTV) - BoilerTV) - CopperTV) - OtherTV) - RadiatorsTV) - RenewablesTV) AS QualifyingSpend,

SUM(A.[Boiler Turnover Value]) AS BoilerTurnover, SUM(A.[Boilers Margin £]) AS BoilerMargin,

SUM(A.[Copper Turnover...

Sensible formatting throws up a difference:

SELECT

ra.AgreementSerial,

SUM(- (((((A.[Plastics Turnover value] * ISNULL(ra.Plastics, 0) -- [*]

- A.[Heating Spares Turnover Value] * ISNULL(ra.HeatingSpares, 0)) - A.[Boiler Turnover Value] * ISNULL(ra.Boilers,...

Actually it won't, it's the same problem. Read...

Comment out the left join, it's completely redundant - as you can see from the plan, it's optimised out anyway.

Can we please have actual rather than estimated...

tcronin 95651 (12/13/2016)

---

Appreciate all the input, it did get rid of the scan, however below are the stats, top set is with index scan below is the seek.

(71 row(s) affected)

Table...