Luis Cazares (11/12/2015)

---

Jason-299789 (11/12/2015)

---

The best way would be to use the CROSS TAB method, mentioned in this article : http://www.sqlservercentral.com/articles/T-SQL/63681/

Will the number of columns be limited to 3 or will...

This is another way to and its a little more dynamic, and saves the

DECLARE @CustOrder TABLE

(

CustId Int

,SalesValue Money

)

INSERT INTO @CustOrder

(CustId,SalesValue)

Values

(100813, 124)

,(100813, 110)

,(100794, 297)

,(100794, 99)

,(100794, 101);

WITH CTE_data

As

(

SELECT ROW_NUMBER() OVER...

The best way would be to use the CROSS TAB method, mentioned in this article : http://www.sqlservercentral.com/articles/T-SQL/63681/

Will the number of columns be limited to 3 or will it depend on...

I believe the correct syntax is

--EXECUTE master.sys.sp_MSforeachdb 'USE [?]; <SQL CODE>'

--EG

DECLARE @sql VARCHAR(8000)

SET @sql = 'USE [?];IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME =...

As an aside, and I hope you dont mind me asking, but why go for Standard and not Developer edition, which will have significant savings on Standard licensing, while still...

Thanks for all the help its given us a place to start looking deeper at the issues.

To clarify a few points,

1) The SQL Install on the DB server...

Its a SharePoint 2013 install.

I didn't set up the Sharepoint boxes, the SQL server box as far as I can tell is a single box within the farm and...

Its impossible to answer, not only for the reason Gail mentions, but also because the exam is different for everyone.

I will say I passed the 70-461 with room to spare...

This is why I detest cursors for all but a few selective requirements.

I think this is a dependency issue.

Its difficult to see, as we don't know the order the tables are created or the data types of the tables, its is possible...

BoL (books on Line) : taken from the page https://msdn.microsoft.com/en-GB/library/ms180169.aspx

DYNAMIC

Defines a cursor that reflects all data changes made to the rows in...

Is it because its defined as DYANAMIC and BoL states that the data can change within the cursor during the loop.

No Problem, I've been doing a lot with the new window functions especially the ranges for Running totals.

I've also looked at DAX and found its missing some of the useful...

Or you could do something like this

DECLARE @Table TABLE

(

Value int

,Monthly smallint

)

INSERT INTO @Table

(Value,Monthly)

VALUES

(1,1)

,(2,2)

,(3,3)

,(4,4)

,(5,5)

,(6,6)

,(7,7)

,(8,8)

,(9,9)

,(10,10)

,(11,11)

,(12,12)

,(13,13)

,(14,14)

SELECT

*

,SUM(Value)

OVER (ORDER BY Monthly

ROWS BETWEEN 11 PRECEDING AND Current Row) RollingTotal

,SUM(Value)

OVER (ORDER BY...

Effectively step 3 is redundant why delete the rows in the source, and then reinsert them, you're doubling the work load. Its should just be a case of

1) Import...