SQL Server 2000 script
Hi , How can we use SQL 2000 script to call 2nd maximum date? case : Item A has few price with different effective_date, Ihow can i call an item’s price with second max(effective_date). Thanks in advance.

Answer Question   |  December 11, 2008  10:31 AM
Conditional SQL statements, SQL, SQL Query, SQL Server 2000, SQL Server 2000 Scripts, SQL Server Scripts

SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I’m trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the column names in [...]

Answer Question   |  November 3, 2009  8:13 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL