column to Row in sql 2005

In Sql Server 2000, it was very hard converting column based values to transpose into row based values and vice versa.
PIVOT and UNPIVOT did the trick in Sql server 2005.
Below is the sample that transpose values from column to rows in sql server using UNPIVOT relational operator.
Sample input table
view plaincopy to clipboardprint?
create table #temptable(rowid int,colorname varchar(25),Hexa varchar(7)
,R tinyint,G tinyint,B tinyint)
GO
insert into #temptable values(1,'Violet','#8B00FF',139,0,255);
insert into #temptable values(2,'Indigo','#4B0082',75,0,130);
insert into #temptable values(3,'Blue','#0000FF',0,0,255);
insert into #temptable values(4,'Green','#00FF00',0,255,0);
insert into #temptable values(5,'Yellow','#FFFF00',255,255,0);
insert into #temptable values(6,'Orange','#FFA500',255,165,0);
insert into #temptable values(7,'Red','#FF0000',255,0,0);
GO
select * from #temptable
GO

The sample table contains colorname with "R","G" & "B" column with specific values.

Our goal is to convert "R","G" & "B" as rows with specific values in single column.

Main requirement of transposing columns to rows is to have identical datatypes of converting columns.
In the sample the datatype of "R", "G" & "B" being tinyint.
The T-SQL query to convert columns to rows is
view plaincopy to clipboardprint?
SELECT rowid,colorname,hexa,rgb,rgbvalue
FROM
(SELECT rowid,colorname,hexa,r,g,b
FROM #temptable) p
UNPIVOT
(rgbvalue FOR rgb IN (r,g,b))
AS unpvt;
The output would be

In the above sample "rowid,colorname,hexa" columns remains unchanged. "R", "G" & "B" columns are converted to rows with new column "rgb" and its specific values are added to new column "rgbvalue".
syntax for understanding:
view plaincopy to clipboardprint?
select unchanged columns ,new column,new column for its values
from
(
select unchanged columns,columns to be converted to rows from tablename
) alias name1
UNPIVOT
(
new column for its values FOR
new column> IN columns to be converted to rows
)
AS alias name2
Thats it, hope it helps.

Avoid Outlook Mails without Subject

1. Open your outlook
2. Press Alt+F11. This opens the Visual Basic editor
3. On the Left Pane, one can see “Microsoft Outlook Objects”, expand this. Now one can see the “ThisOutLookSession”.
4. double Click on “ThisOutLookSession”.
5. Copy and Paste the following code in the right pane.

It’s a common blunder that people send out mails with out the “Subject”.To prevent this, all you need to do is add a macro to your outlook.
Follow the following….Steps:

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim strSubject As String
strSubject = Item.Subject
If Len(Trim(strSubject)) = 0 Then
Prompt$ = "Subject is Empty. Are you sure you want to send the Mail?"
If MsgBox(Prompt$, vbYesNo + vbQuestion + vbMsgBoxSetForeground, "Check for Subject") = vbNo Then
Cancel = True
End If
End If
End Sub

Send Mail