...it's me...eRiCk

can't paste all of them.. u can visit here

make sure to update the Database first use this script in mySQL to update the inserted link UPDATE wp_posts SET guid = REPLACE ( guid, 'http://exampleoldsiteurl.com', 'http://examplenewsiteurl.com'); more in here

i'm using VS 2010 and try to adding old VS 2008 Solution to TFS 2010 (after i upgrade the Solution) always receive an error that said can't access TFS url :( what i've done: -uninstall TFS 2010 -uninstall Windows that host TFS 2010 -reinstall TeamExplorer 2008 SP1 working solution (no need step above :sad: ) create new empty Solution in VS 2010 then add existing project to it then check in been trying this for 1 week :(, glad finally works

he introduction of ranking functions in SQL Server 2005 allowed the generation of listings with generated numbers based on sort orders providing keys such as row numbers and rank. These can be used for the deduplication of data in a simple way. Consider the following simple example of a list of characters: A A B B C D D E Let's put this into a table. This example creates a table variable. declare @AlphaList table (AlphaKey char); insert into @AlphaList(AlphaKey) values ('A'); insert into @AlphaList(AlphaKey) values ('A'); insert into @AlphaList(AlphaKey) values ('B'); insert into @AlphaList(AlphaKey) values ('B'); insert into @AlphaList(AlphaKey) values ('C'); insert into @AlphaList(AlphaKey) values ('D'); insert into @AlphaList(AlphaKey) values ('D'); insert into @AlphaList(AlphaKey) values ('E'); select AlphaKey from @AlphaList order by 1; If we now use the ROW_NUMBER function we can get a listing of @AlphaList table...