Pages

Monday, February 11, 2013

Create Temp Tables in SQL Server


Create PROCEDURE [dbo].[GetTempData]
(
   @RegionID varchar(max) = 0
)
AS
CREATE TABLE #tbl_2
(
PropertyID VARCHAR(250),
FTValue int,
FinalValue VARCHAR(250)
)
CREATE TABLE #tbl_3
(
PropertyID VARCHAR(250),
FTValue int,
FinalValue VARCHAR(250)
)

Insert Into #tbl_2 (PropertyID,FTValue,FinalValue) Values('141',5000,'1/4')
Insert Into #tbl_2 (PropertyID,FTValue,FinalValue) Values('142',4000,'2/4')
Insert Into #tbl_2 (PropertyID,FTValue,FinalValue) Values('143',4000,'3/4')
Insert Into #tbl_2 (PropertyID,FTValue,FinalValue) Values('144',3000,'4/4')

INSERT #tbl_3 SELECT PropertyID,FTValue,FinalValue from #tbl_2

select * from #tbl_3
DROP TABLE #tbl_2
DROP TABLE #tbl_3
END

Thursday, November 1, 2012

Opening WebPart Maintenance Page

Shortcut to open Instead of going to the Edit Properties form of the page, we can easily open the WebPart Maitenance page by just adding the following query string to the page URL
?contents=1
 So, if your page URL is 'http://kar/pages/default.aspx' then after appending the query string it should look like ' http://rams/pages/default.aspx?contents=1'

Using this approach, we can open the webpart maintenance page for all the forms pages (like /pages/forms/allitems.aspx?contents=1).

But its not safe to remove or add any webparts in these pages, as they may effect the normal funcitonality.

This approach works on both MOSS 2007 and SPS 2010.

Tuesday, October 30, 2012

Copy from One database table data to anoother database table data MS SQL Query

insert into StarDB.dbo.Associate1 select * from StarDB_Production.dbo.Associate1