SQL 2000 view debug help
I have the following (admittedly convoluted) view that I cannot get right for some reason that I cannot see. Consider the following: SELECT     s.s_SAMPLEID AS LimsSampleId, s.U_CLIENT_SAM_NO AS ADASampleId, MAX(s.SAMPLEDESC) AS SampleDescription,                       MAX(CASE d.paramlistid WHEN i.paramid THEN d.paramlistid WHEN ’1.Purity I’ THEN pm.paramdesc WHEN ’2.Purity Analysis’ THEN ‘Purity Analysis’ WHEN                        ’5.Germination’ THEN pm.paramdesc [...]

Answer Question   |  February 1, 2011  6:23 PM
SQL 2000, SQL Server 2000, SQL Server 2000 administration, SQL Server 2000 queries

How to write text into word doc using SQL 2000 query analyzer
how to write text into word doc using sql 2000 query analyzer. Thanks in advance.

Answer Question   |  November 19, 2010  7:02 AM
SQL 2000, SQL Query, SQL Query Analyzer, SQL Server 2000, SQL Server 2000 queries

What is a linear recursive query in SQL?
What is a linear recursive query in SQL?give me an example.Is there any nonlinear recursive query??

Answer Question   |  August 24, 2010  5:28 PM
SQL Query, SQL Server 2000, SQL Server 2000 queries, SQL Server Query

What are the query optimization techniques used in SQL 2000?
What are the query optimization techniques used in SQL?

Answer Question   |  August 28, 2010  5:22 PM
SQL Server 2000, SQL Server 2000 queries, SQL Server Query, SQL Server query optimization

How to check the existence of a Column in SQL Server 2000?
- using SQL Server 2000 , Would like to know how to check any specific column exist in a database. Any method to search through the list of tables in a database. Thanks.

Answer Question   |  January 12, 2009  9:30 AM
SQL queries, SQL Server 2000, SQL Server 2000 queries