Kamen Rider Decade eps 22 to Final episode

Hi all, here are the complete Kamen Rider Decade complete episode subbed, from eps 22 to final episode.

http://www.tvnihon.com/tracker/torrents-details.php?id=963
http://www.tvnihon.com/tracker/torrents-details.php?id=968
http://www.indowebster.com/TNKamen_Rider_Decade_24SD7EA81C4D.html
http://www.indowebster.com/TNKamen_Rider_Decade_25SDD5FC3602avi.html
http://www.tvnihon.com/tracker/torrents-details.php?id=1013
http://www.tvnihon.com/tracker/torrents-details.php?id=1020
http://www.tvnihon.com/tracker/torrents-details.php?id=1028&hit=1
http://www.tvnihon.com/tracker/torrents-details.php?id=1037&hit=1
http://www.tvnihon.com/tracker/torrents-details.php?id=1048
http://www.tvnihon.com/tracker/torrents-details.php?id=1060&hit=1

have a nice day

Kamen Rider Decade Eps 21 Subbed

For all kamen rider fans, Here are Episode 21 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=946

have a nice day

Kamen Rider Decade Eps 20 Subbed

For all kamen rider fans, Here are Episode 20 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=939

have a nice day

Kamen Rider Decade Eps 19 Subbed

For all kamen rider fans, Here are Episode 19 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=922

have a nice day

Kamen Rider Decade Eps 18 Subbed

For all kamen rider fans, Here are Episode 18 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=915

have a nice day

Kamen Rider Decade Eps 17 Subbed

For all kamen rider fans, Here are Episode 17 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=905

have a nice day

Kamen Rider Decade Eps 16 Subbed

For all kamen rider fans, Here are Episode 16 which has been subbed!!

SD= http://www.tvnihon.com/tracker/torrents-details.php?id=895
HD= http://www.tvnihon.com/tracker/torrents-details.php?id=894

have a nice day

Kamen Rider Decade Eps 15 Subbed

For all kamen rider fans, Here are Episode 15 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=890

have a nice day

Kamen Rider Decade Eps 14 Subbed

For all kamen rider fans, Here are Episode 14 which has been subbed!!

http://www.nyaatorrents.org/?page=torrentinfo&tid=61435

have a nice day

Kamen Rider Decade Eps 13 Subbed

For all kamen rider fans, Here are Episode 13 which has been subbed!!

http://www.nyaatorrents.org/?page=torrentinfo&tid=60286

have a nice day

Kamen Rider Decade Eps 12 Subbed

For all kamen rider fans, Here are Episode 12 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=857


have a nice day

Kamen Rider Decade Eps 11 Subbed

For all kamen rider fans, Here are Episode 11 which has been subbed!!

http://www.megaupload.com/?d=P4143UGD

or watch in website,
http://www.youtube.com/watch?v=NgGsW0IVhmo
http://www.youtube.com/watch?v=6pkdfqj_fHI&feature=related
http://www.youtube.com/watch?v=ZSrXVqSN8ho

have a nice day

Kamen Rider Decade Eps 10 Subbed

For all kamen rider fans, Here are Episode 10 which has been subbed!!

http://tvnihon.com/tracker/torrents-details.php?id=840

have a nice day

Kamen Rider Decade Eps 09 Subbed

For all kamen rider fans, Here are Episode 9 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=826

have a nice day

Kamen Rider Decade Eps 08 Subbed

For all kamen rider fans, Here are Episode 8 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=812

have a nice day

Kamen Rider Decade Eps 07 Subbed

For all kamen rider fans, Here are Episode 7 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=794

have a nice day

Kamen Rider Decade Eps 06 Subbed

For all kamen rider fans, Here are Episode 6 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=785

have a nice day

Kamen Rider Decade Eps 05 Subbed

For all kamen rider fans, Here are Episode 5 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=778

Kamen Rider Decade eps 04 Subbed

For all kamen rider fans, Here are Episode 4 which has been subbed!!

http://tvnihon.com/tracker/download.php?id=766&name=[T-N]Kamen_Rider_Decade_04[B91A4800].avi.torrent

have a nice day

New Sql Server 2008 Query environment

There's something new in sql server 2008 query environment.

See the pic below


it's just like you make a code at Visual studio environment. If you specify which table you will select than the columns name in the table will be display. No need to worry that you will write wrong columns name.

Only want to share this one for the moment. wait for my next explore of Sql server 2008.

Have a nice day.

Kamen Rider Decade eps - 03

For all kamen rider fans, Here are Episode 3 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=759

have a nice day

Kamen Rider Decade Eps 02 Subbed

For all kamen rider fans, Here are Episode 2 which has been subbed!!

http://www.tvnihon.com/tracker/torrents-details.php?id=743

have a nice day

Kamen Rider Decade eps - 01

For kamen rider fans, this is the link to download the subs for eps 1

Order of Zeronos - Kamen Rider Decade - 01
http://www.nyaatorrents.org/?page=download&tid=48378

#TV-Nihon - Kamen Rider Decade - 01
http://www.tvnihon.com/tracker/download.php?id=730&name=%5BT-N%5DKamen_Rider_Decade_01%5BB2A3D889%5D.avi.torrent

row_number function

a new function in sql server 2005. It's function returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.

syntax :

ROW_NUMBER ( ) OVER ( [<partition_by_clause>] <order_by_clause> )

example :

SELECT c.FirstName, c.LastName, ROW_NUMBER() OVER(ORDER BY SalesYTD DESC) AS 'Row Number', s.SalesYTD, a.PostalCode
FROM Sales.SalesPerson s JOIN Person.Contact c on s.SalesPersonID = c.ContactID
JOIN Person.Address a ON a.AddressID = c.ContactID
WHERE TerritoryID IS NOT NULL AND SalesYTD <> 0

(source : Sql server documentation )

great, doesn't it ?

have a try.

Have a nice day.

Pivot Table in Sql Server 2005 ( Part 2 )

Here my logic to make the field more fleksible. So you don't have to fix the field. Of course this method used when you need to make your report fleksible and don't need to add the new field if there's a new data inserted into master table.

declare @field varchar(max)
declare @select varchar(max)
declare @employeeid int

set @field = ''

declare cr cursor for
select employeeid
from HumanResources.Employee

open cr

fetch next from cr into @employeeid

while @@fetch_status = 0
begin
if @field <> ''
begin
set @field = @field + ','
end

set @field = @field + '[' + convert(varchar(max),@employeeid ) + ']'

fetch next from cr into @employeeid
end

close cr
deallocate cr

set @select =
'SELECT VendorID, ' + @field + '
FROM
(SELECT PurchaseOrderID, EmployeeID, VendorID
FROM Purchasing.PurchaseOrderHeader) p
PIVOT
(
COUNT (PurchaseOrderID)
FOR EmployeeID IN
( ' + @field + ' )
) AS pvt ORDER BY VendorID;'

exec (@select)

Have a try. Ask if you still confuse.

Have a nice day.

Pivot Table in Sql Server 2005

New but not new since sql server 2008 have been launch. I will share a little bit about it.

Here's the sample query from Sql Server 2005 Documentation:

USE AdventureWorks
GO
SELECT VendorID, [164] AS Emp1, [198] AS Emp2, [223] AS Emp3, [231] AS Emp4, [233] AS Emp5
FROM
(SELECT PurchaseOrderID, EmployeeID, VendorID
FROM Purchasing.PurchaseOrderHeader) p
PIVOT
(
COUNT (PurchaseOrderID)
FOR EmployeeID IN
( [164], [198], [223], [231], [233] )
) AS pvt
ORDER BY VendorID;

here is the result :

VendorID Emp1 Emp2 Emp3 Emp4 Emp5
1 4 3 5 4 4
2 4 1 5 5 5
3 4 3 5 4 4
4 4 2 5 5 4
5 5 1 5 5 5

if your database was upgraded from sql 2000 to sql 2005 , then you may set the compatiblel level to 90 to make the feature availeble.

sp_dbcmptlevel [ [ @dbname = ] name ] [ , [ @new_cmptlevel = ] version ]

example : sp_dbcmptlevel 'databasename', '90

remember : if you use pivot features you have to :
1. one column as the value to aggregate
2. one column as the column name . From the example , the column name would be employeeid.
Unfortunately, You have to define it.
I thought i can use

FOR EmployeeID IN
( select employeeid from HumanResources.Employee )

but it doesn't work, that will make my query more fleksible if it's work. I will find other way to make it. May be a little trik for it. I will share it on other post.
3. you are in sql 2005 - > there's must be obsolute.
4. the feature is on. use sp_dbcmplevel to change the level to 90.

How cool isn't it ? Have a try and have a nice day.

Kamen Rider Decade

This year, the Kamen rider name Kamen Rider Decade. Decade, as its title suggests, is the tenth anniversary of the Heisei Rider Series, having begun with Kamen Rider Kuuga in 2000. It will be on air on January 25, 2009 in Japan.

You can find the group to discuss it at http://www.new.facebook.com/topic.php?topic=6418&post=22788&uid=30467778890#/group.php?gid=30467778890

Cann't wait to have it :D.