Posts

Showing posts from September, 2010

Partitioning in SQL Server 2008 - SQLServerCentral

Partitioning in SQL Server 2008 - SQLServerCentral N41 by Nouvolution

Using PIVOT - SQLServerCentral

Using PIVOT - SQLServerCentral N41 by Nouvolution

Fun with business days, calendar tables, and test-driven development - SQLServerCentral

Fun with business days, calendar tables, and test-driven development - SQLServerCentral N41 by Nouvolution

Eliminating Duplicate Rows using The PARTITION BY clause - SQLServerCentral

Eliminating Duplicate Rows using The PARTITION BY clause - SQLServerCentral N41 by Nouvolution

PowerBuilder Delay

카페 : "Fuction wf_delay(integer ai_second) return None //ai_second time lt_start lt_start = now() do while true do while Yield() loop if SecondsAfter ( lt_start, now() ) >= ai_second then exit end if loop" N41 by Nouvolution

The MERGE Statement in SQL Server 2008

The MERGE Statement in SQL Server 2008 N41 by Nouvolution

SQL Server 2005 Try and Catch Exception Handling

SQL Server 2005 Try and Catch Exception Handling N41 by Nouvolution

Map IP Address to a Geographical Location - SQLServerCentral

Map IP Address to a Geographical Location - SQLServerCentral N41 by Nouvolution

Run The Same SQL Command Against All SQL Server Databases

Run The Same SQL Command Against All SQL Server Databases N41 by Nouvolution