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.