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. 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?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?
Answer Question | August 28, 2010 5:22 PM
SQL Server 2000, SQL Server 2000 queries, SQL Server Query, SQL Server query optimization
- 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