Both queries aren't equivalent. The first is a single value and the second one will show one value per LoanID. In both queries, there's no reason to use a subquery.

And...

I'm guessing that it could be an expensive sort if the index columns are not in the same order. Possible blocking on any of the 3 tables.

Could you post the...

Suth (10/16/2015)

---

Spoke to one of our network guys and he said he will need to map the drive for it to be access. Which is causing my error.

My last...

You mean like this?

Select Region,

Amount / 12 AS Jan2015,

Amount / 12 AS Feb2015,

--...

Amount /...

My wild guess would be something like this:

CREATE FUNCTION [dbo].[eufn_e5_eSM_SE_GetCurrentContentForContainer]

(

@containerSqlId SMALLINT,

@containerIncId INT

)

RETURNS TABLE

AS

RETURN

SELECTCC.contentSqlId,

CC.contentIncId,

CC.contentMetaTableSqlId,

CC.contentMetaTableIncId

FROM [dbo].[ContainersContents] CC

WHERECC.containerSqlId = @containerSqlId AND

CC.containerIncId = @containerIncId AND

CC.isDeleted = 0

UNION ALL

SELECT ccc.*

FROM [dbo].[ContainersContents] CC

CROSS APPLY [dbo].[eufn_e5_eSM_SE_GetCurrentContentForContainer](CC.contentSqlId, ...

As Sean said, this is an awful design. These should be columns instead of rows. All of these columns are totals and should be treated like that. The formulas can...

I feel like I was obligated to get it right since I wrote the second article in the references. 😀

Quick option: Use cross tabs.

select

SUM( CASE WHEN category = 'cat1' THEN salesprice ELSE 0 END) AS cat1_salesprice,

SUM( CASE WHEN category =...

Yes, 32-bit has several limitations listed in here: https://msdn.microsoft.com/en-us/library/ms143432(v=sql.120).aspx

However, a 64 bit version...

You could use the DelimitedSplit8k found in here: http://www.sqlservercentral.com/articles/Tally+Table/72993/

SELECT

J.DT_ID

,J.InvNo

,sc.Item AS SalesCode

,a.Item AS Amount

FROM @TEST_DATA J

CROSS APPLY...

I wouldn't use nulls to represent a zero value. But I could see a valid option if there's an unknown value that might be defined later. You could also...

I wouldn't allow nulls on data type money for the simple reason that I wouldn't allow the money data type.

Regarding the real question, I guess it depends more on the...

Phil Parkin (10/15/2015)

---

Where is the...

For the row counts, you can use the following:

SELECT OBJECT_NAME( object_id) AS TableName,

SUM( row_count) AS Row_Count

FROM sys.dm_db_partition_stats

WHERE index_id IN(1,0)

GROUP BY object_id

For statistics and index maintenance, you...

You can use either the SQL Server Express Edition which is free. It has several limitations, but for simple use, it should be fine.