Connected webparts from two different pages…


Online project management, task software, and free collaboration workspace: AJAXWorkspace
AJAXWorkspace is a free online workspace that offers task tracking software, team collaboration, online calendar, document sharing, and file management for project management and teamwork.

If you have two aspx pages (sharepoint views) and need to pass some value from the parent view (aspx page1) to the child view (aspx page2) based on the user selection and filter the second view based on that parameter. Please check it out here…

http://www.theserverside.net/tt/articles/showarticle.tss?id=WebParts2

Calling another sql file from a sql file


We must use xp_cmdshell and an application which executes the command like sqlcmd or OSQL (and the –I switch). Here’s an example of how to do it:

osql -S%1 -U%2 -P%3 -d%4 -i”.\DataConversion.sql”

where –S,-U etc are the various options…