Jai Shree Ganesha

I got a good site especially for Lord Ganesha.

The site contains Ganesha Stories, Arti, Names, Meaning of each Name and Photo Gallery of the Hindu God Ganesha.

Click here to Visit the site

Single SignOn (SSO) : Pluggable provider

I was looking for  "How to implement SSO between SharePoint and ASP.NET site".

After spending a little time I found a very useful link for the same:

Abstracts:
By default, Microsoft Office SharePoint Server 2007 provides the
Microsoft Single Sign-On (SSO) service for storage and mapping of
credentials for use in connecting with third-party or back-end systems.
Many companies already have developed an in-house credential storage
system or use a solution other than the Microsoft Single Sign-On
service. As an alternative to maintaining credential mapping in two
places, Office SharePoint Server 2007 provides a mechanism called
pluggable SSO. This feature allows you to specify an alternate SSO
provider to the standard SSO provider in Office SharePoint Server 2007

click here to visit the original site.

PageViewer WebPart > Connect

A good link I found related to Page Viewer Webpart connection.

Normally the OOB page viewer webpart doesn't support the connection to another webpart.
But as per the implementation listed in below link, you can do the connection for that webpart.

Link
http://www.toddbaginski.com/blog/archive/2007/08/16/connected-page-viewer-web-part.aspx

ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

In SQL Server, you may face an error and get the below error message:

Msg 104, Level 16, State 1, Line 4
ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

Below is the solution of your query, make sure you have followed the pattern as below

Select * from
(               
            SELECT   field1, field2 FROM Table1 WHERE  field1 = 'abc'
            UNION
            SELECT   field1, field2 FROM Table2 WHERE  field2 = 'xyz'
) VarTable
                    order by case when field1 is not null then field1 else field2 end desc

Let us know your feedback.

Thank you Hiral Shah for this post!

By AlpesH Shah

Does God Exists?

I watched a good video on YouTube...and would like the same to you all.

Check this out:






If you find the above link useful, let us know your feedback, it will help us to improve our posting(s). or You can send your feedback linkOblast.

Report Broken Link