Welcome ALL

Adding Application pools in IIS http://www.iis.net/configreference/system.applicationhost/applicationpools/add

Update one table from another table :- UPDATE #temp1 SET #temp1.t3=#temp 2.t3,   #temp1.t4 = #temp2.t4   FROM #temp1, #temp2   WHERE #temp1.row = #temp2.row

To get tempary row number SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) AS Row, colnam1, colnam2  FROM table1

To get time in sql Select CONVERT(varchar(50),getdate(),108) getTime

To Display Current Week data in sql :- CREATE FUNCTION dbo.udf_DisplayCurrentWeekDateDays ( @today SMALLDATETIME ) RETURNS @WeekDateDay TABLE ( Sunday SMALLDATETIME , Monday SMALLDATETIME , Tuesday SMALLDATETIME , Wednesday SMALLDATETIME , Thursday SMALLDATETIME , Friday SMALLDATETIME , Saturday SMALLDATETIME ) AS BEGIN DECLARE @day INT SET @today = CAST ( CONVERT ( VARCHAR ( 10 ), @today , 101 ) AS SMALLDATETIME ) SET @day = DATEPART ( dw , @today ) INSERT INTO @WeekDateDay ( Sunday , Monday , Tuesday , Wednesday , Thursday , Friday , Saturday ) SELECT DATEADD ( dd , 1 - @day , @today ) Sunday , DATEADD ( dd , 2 - @day , @today ) Monday , DATEADD ( dd , 3 - @day , @today ) Tuesday , DATEADD ( dd , 4 - @day , @today ) Wednesday , DATEADD ( dd , 5 - @day , @today ) Thursday , DATEADD ( dd , 6 - @day , @today ) Friday , DATEADD ( dd , 7 - @day , @today ) Saturday RETURN END GO for more reference :- http://blog.sqlauthority.com/2007/06/08/sql-server-...

 How to convert table data from horizontal into vertical in sql :- declare @t table (id int, nm varchar(10), typ varchar(10), color varchar(10), qty int, txt varchar(10)) insert @t select 1, 'name1', 'type1', 'color1', 10, 'note1' union all select 2, 'name2', 'type2', 'color2', 20, 'note2' select up.id        ,up.col as sourcecolumn        ,up.val as [value] from   (        select id, nm,typ,color,convert(varchar(10), qty) qty,txt        from @t --YOUR TABLE        ) d unpivot (val for col in ([nm], [typ], [color],[qty],[txt])) up

Tricks to speed up your SQL query:- http://www.dotnetfunda.com/articles/article1949-tricks-to-speed-up-your-sql-query.aspx