Advertisement
servantis Login Name
54 Questions Asked
0 Questions Open
51 Questions Graded
3 Questions Deleted
Date Points Title Status Zone
1 10/22/2007 125 Create insert/update trigger to perform the fun… PAQ MS SQL Server
2 06/29/2007 125 Update duplicate datetime records to ensure PK… PAQ MS SQL Server
3 06/20/2007 125 Disable/drop constraints to truncate table and … PAQ MS SQL Server
4 01/11/2007 125 Query to display referencing tables and column… PAQ Oracle
5 08/30/2006 125 Loop through recordset without using a cursor … PAQ Databases
6 07/18/2006 125 Assign IDs based on distinct text descriptions. PAQ Databases
7 06/15/2006 0 Create a self join view from mapping table Deleted Databases
8 05/22/2006 125 Update cursor in stored procedure PAQ Oracle
9 05/17/2006 125 Replace indexes with partitioned indexes on a … PAQ Oracle
10 04/17/2006 250 Create a view that joins self join and non-self j… PAQ Databases
11 02/15/2006 125 Execute multiple scripts using SQLPLUS via a b… PAQ Oracle
12 01/31/2006 250 Update query with multiple inner joins PAQ Oracle
13 01/29/2006 125 Update statement using inner join PAQ Oracle
14 01/18/2006 125 Show distinct values in columns that appear in … PAQ Oracle
15 01/12/2006 125 Dynamic SQL cursor to generate sample data PAQ MS SQL Server
16 12/07/2005 125 Differentiate text field to make column unique PAQ MS SQL Server
17 12/05/2005 125 Update statement using self join PAQ MS SQL Server
18 11/30/2005 125 update a randomly chosen percentage of rows… PAQ Oracle
19 10/12/2005 125 Left outer join two tables on two different colu… PAQ MS SQL Server
20 10/03/2005 250 Pre insert trigger that raises an error when val… PAQ MS SQL Server
 
Question History Results: 1 - 20 of 54