Development tasks
create service application
create service application endpoint(WCF)
create service application installers
create service application proxy
create service application proxy installers
create service application consumers
Steps to Configure BCS in sharepoint2010
========================================
1. Configure the site in sharepoint designer2010
2. select external content type from site objects
3. press add connection button and set up the external data source and select whatever the operation types which related to the datatable
4. press save button to upload content to the sharepoint server
5. from the site select external list under the list collection
Backup & Restore site collection
================================
Backup ->
Can use -> Perform a site collection backup under Granular Backup or SharePoint 2010 management shell
Restore ->
SharePoint2010 management shell Only.
Cmd:
restore-spsite -identity "http://win-b9m88cn17s2" -path "C:\_backUPs\siteCollection.bak" -force
*** Can't nest aggregate function - error
Select Y,Q, Max(Sum) as MaxSum
FROM ( -- Calculate Sums
SELECT Category, Year(SalesDate) as Y, DatePart(q,SalesDate) as Q, max(Sum(Amount)) as Sum
FROM RawData
GROUP BY Category, Year(SalesDate), DatePart(q,SalesDate)
) sq
GROUP BY Y,Q
ORDER BY Y,Q
*** -- Solution: Including Detail description
SELECT MaxQuery.Y, MaxQuery.Q, AllQuery.Category, MaxQuery.MaxSum as sales
FROM (-- Find Max Sum Per Year/Quarter
Select Y,Q, Max(Sum) as MaxSum
FROM ( -- Calculate Sums
SELECT Category, Year(SalesDate) as Y, DatePart(q,SalesDate) as Q, Sum(Amount) as Sum
FROM RawData
GROUP BY Category, Year(SalesDate), DatePart(q,SalesDate)
) sq
GROUP BY Y,Q
) MaxQuery
JOIN (-- All Amount Query
SELECT Category, Year(SalesDate) as Y, DatePart(q,SalesDate) as Q, Sum(Amount) as Sum
FROM RawData
GROUP BY Category, Year(SalesDate), DatePart(q,SalesDate)
)AllQuery
ON MaxQuery.Y = AllQuery.Y
AND MaxQuery.Q = AllQuery.Q
AND MaxQuery.MaxSum = AllQuery.Sum
ORDER BY MaxQuery.Y, MaxQuery.Q
