Read this first:
1. This has no real time usage. So try this out only when you are free :)
2. This script was just done for fun and nothing more.
3. Before executing this script change your result display mode to 'Text' (Ctrl + T)
4. There are easier way of doing the same thing. Just to make it look complex I have done this way :)
Code snippet Starts here:
Set nocount on
Declare @TblLayout table([ID] int Identity, Canvas Char(75))
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
--- Vz employees House ...
Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x7C5F5F5F5F5F5F5F5F5F5F5F5F5F5F7C5F5F5F5F5F7C))Where ID = 5
Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x7C2020205B20205D20205B20205D207C20202020207C)) Where ID = 4
Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F5C5C5C5C5C5C)) Where ID = 3
Update @TblLayout Set Canvas = Stuff(Canvas, 43, 23 , Convert(Varchar, 0x2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F5C5C5C5C)) Where ID = 2
Update @TblLayout Set Canvas = Stuff(Canvas, 44, 21, Convert(Varchar, 0x5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F)) Where ID = 1
-- Picture of a Guy ...
Update @TblLayout Set Canvas = Stuff(Canvas, 10,10, Convert(Varchar, 0x285F5F5F5B5F5F5F29)) Where ID = 27
Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C5F5F7C5F5F7C)) Where ID = 26
Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C20207C20207C)) Where ID = 25
Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C20207C20207C)) Where ID = 24
Update @TblLayout Set Canvas = Stuff(Canvas, 10,9, Convert(Varchar, 0x5C7C5F5F5F5F2F202F)) Where ID = 23
Update @TblLayout Set Canvas = Stuff(Canvas, 9,11, Convert(Varchar, 0x5C207C20416553202F202F)) Where ID = 22
Update @TblLayout Set Canvas = Stuff(Canvas, 9,11, Convert(Varchar, 0x2F5F2F20415453205C5F5C)) Where ID = 21
Update @TblLayout Set Canvas = Stuff(Canvas, 10,9, Convert(Varchar, 0x2F202060606020205C)) Where ID = 20
Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x5F5C5F755F2F5F)) Where ID = 19
Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x5C20302030202F)) Where ID = 18
Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x2F2F2F2F2F2F2F)) Where ID = 17
--Time to travel
Update @TblLayout Set Canvas = Stuff(Canvas, 11,3, Convert(Varchar, 0x282029)) Where ID = 6
Update @TblLayout Set Canvas = Stuff(Canvas, 10,3, Convert(Varchar, 0x282029)) Where ID = 7
Update @TblLayout Set Canvas = Stuff(Canvas, 7,27, Convert(Varchar, 0x5F5F2F202F5F5F5F5F5F20202020205F5F5F5F5F5F5F5F5F)) Where ID = 8
Update @TblLayout Set Canvas = Stuff(Canvas, 5,27, Convert(Varchar, 0x287C202020202020202020207C2020207C2020202020202020207C)) Where ID = 9
Update @TblLayout Set Canvas = Stuff(Canvas, 6,26, Convert(Varchar, 0x7C205B5D205B5D205B5D207C292D287C205B5D205B5D205B5D7C)) Where ID = 10
Update @TblLayout Set Canvas = Stuff(Canvas, 6,27, Convert(Varchar,
0x7C5F5F5F5F5F5F5F5F5F5F7C2020207C5F5F5F5F5F5F5F5F5F7C)) Where ID = 11
Update @TblLayout Set Canvas = Stuff(Canvas, 7,24, Convert(Varchar, 0x303030303030303030302020202020303030303030303030)) Where ID = 12
-- Art by ....
Update @TblLayout Set Canvas = Stuff(Canvas, 54,14, Convert(Varchar, 0x417274204279205661646976656C))Where ID = 27
Update @TblLayout Set Canvas = Stuff(Canvas, 32,20, Convert(Varchar, 0x5368616D656C6573732070726F6D6F74696F6E3A))Where ID = 28
Update @TblLayout Set Canvas = Stuff(Canvas, 52,23, Convert(Varchar, 0x7661646976656C2E626C6F6773706F742E636F6D203A29))Where ID = 28
Select Canvas [ ] FROM @TblLayout
Closeing Notes: I actually got this idea after going through Roji's post here
Technorati tags: SQL Server, SQL Server 2005
1. This has no real time usage. So try this out only when you are free :)
2. This script was just done for fun and nothing more.
3. Before executing this script change your result display mode to 'Text' (Ctrl + T)
4. There are easier way of doing the same thing. Just to make it look complex I have done this way :)
Code snippet Starts here:
Set nocount on
Declare @TblLayout table([ID] int Identity, Canvas Char(75))
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
Insert into @TblLayout Select Replicate (Convert(Varchar, 0x7E), 75)
--- Vz employees House ...
Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x7C5F5F5F5F5F5F5F5F5F5F5F5F5F5F7C5F5F5F5F5F7C))Where ID = 5
Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x7C2020205B20205D20205B20205D207C20202020207C)) Where ID = 4
Update @TblLayout Set Canvas = Stuff(Canvas, 42, 24 , Convert(Varchar, 0x2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F5C5C5C5C5C5C)) Where ID = 3
Update @TblLayout Set Canvas = Stuff(Canvas, 43, 23 , Convert(Varchar, 0x2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F2F5C5C5C5C)) Where ID = 2
Update @TblLayout Set Canvas = Stuff(Canvas, 44, 21, Convert(Varchar, 0x5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F5F)) Where ID = 1
-- Picture of a Guy ...
Update @TblLayout Set Canvas = Stuff(Canvas, 10,10, Convert(Varchar, 0x285F5F5F5B5F5F5F29)) Where ID = 27
Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C5F5F7C5F5F7C)) Where ID = 26
Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C20207C20207C)) Where ID = 25
Update @TblLayout Set Canvas = Stuff(Canvas, 11,8, Convert(Varchar, 0x7C20207C20207C)) Where ID = 24
Update @TblLayout Set Canvas = Stuff(Canvas, 10,9, Convert(Varchar, 0x5C7C5F5F5F5F2F202F)) Where ID = 23
Update @TblLayout Set Canvas = Stuff(Canvas, 9,11, Convert(Varchar, 0x5C207C20416553202F202F)) Where ID = 22
Update @TblLayout Set Canvas = Stuff(Canvas, 9,11, Convert(Varchar, 0x2F5F2F20415453205C5F5C)) Where ID = 21
Update @TblLayout Set Canvas = Stuff(Canvas, 10,9, Convert(Varchar, 0x2F202060606020205C)) Where ID = 20
Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x5F5C5F755F2F5F)) Where ID = 19
Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x5C20302030202F)) Where ID = 18
Update @TblLayout Set Canvas = Stuff(Canvas, 11,7, Convert(Varchar, 0x2F2F2F2F2F2F2F)) Where ID = 17
--Time to travel
Update @TblLayout Set Canvas = Stuff(Canvas, 11,3, Convert(Varchar, 0x282029)) Where ID = 6
Update @TblLayout Set Canvas = Stuff(Canvas, 10,3, Convert(Varchar, 0x282029)) Where ID = 7
Update @TblLayout Set Canvas = Stuff(Canvas, 7,27, Convert(Varchar, 0x5F5F2F202F5F5F5F5F5F20202020205F5F5F5F5F5F5F5F5F)) Where ID = 8
Update @TblLayout Set Canvas = Stuff(Canvas, 5,27, Convert(Varchar, 0x287C202020202020202020207C2020207C2020202020202020207C)) Where ID = 9
Update @TblLayout Set Canvas = Stuff(Canvas, 6,26, Convert(Varchar, 0x7C205B5D205B5D205B5D207C292D287C205B5D205B5D205B5D7C)) Where ID = 10
Update @TblLayout Set Canvas = Stuff(Canvas, 6,27, Convert(Varchar,
0x7C5F5F5F5F5F5F5F5F5F5F7C2020207C5F5F5F5F5F5F5F5F5F7C)) Where ID = 11
Update @TblLayout Set Canvas = Stuff(Canvas, 7,24, Convert(Varchar, 0x303030303030303030302020202020303030303030303030)) Where ID = 12
-- Art by ....
Update @TblLayout Set Canvas = Stuff(Canvas, 54,14, Convert(Varchar, 0x417274204279205661646976656C))Where ID = 27
Update @TblLayout Set Canvas = Stuff(Canvas, 32,20, Convert(Varchar, 0x5368616D656C6573732070726F6D6F74696F6E3A))Where ID = 28
Update @TblLayout Set Canvas = Stuff(Canvas, 52,23, Convert(Varchar, 0x7661646976656C2E626C6F6773706F742E636F6D203A29))Where ID = 28
Select Canvas [ ] FROM @TblLayout
Closeing Notes: I actually got this idea after going through Roji's post here
Technorati tags: SQL Server, SQL Server 2005
Comments