Let him enter the field of landmines by using dynamic SQL.

See http://www.sommarskog.se/dynamic_sql.html

Yes. It is called PIVOT or CROSSTAB queries.

There are examples of this in Books Online.

Or have a look at

http://www.sqlservercentral.com/columnists/plarsson/pivottableformicrosoftsqlserver.asp

The modesty doesn't suite you

There are many people listen (read) to what you say (write)

DECLARE

@a TABLE (Col1 INT)

INSERT

@a

SELECT

1 UNION ALL

SELECT

I thought Monday to Wednesday were (2, 3, 4)

===== Jeff ======

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

DBCC execution completed. If DBCC printed error messages, contact your...

USE TEMPDB

CREATE TABLE DBO.AILMENTDETAIL (

  AILMENTDETAILID INT  IDENTITY( 1  , 1  ),

  AILMENTID       INT,

  DATAPOINTID     

I think Jeff soon will post his million record test again

Checking the query plans I might think Jeff's suggestion is faster.

DELETE

     ad

FROM       AilmentDetail AS ad

LEFT JOIN  (

               SELECT   MIN(

Well, with SQL Server 2005, you can do this with ROWNUMBER() function.

From App you wrote?

If you use the ADO library, just put the sorting string to the Sort method.

SELECT d.PRODUCTID, d.Value FROM Table1 AS d

INNER JOIN (SELECT Value  FROM Table1 GROUP BY Value HAVING COUNT(*) > 1) AS t ON t.Value = d.Value

Is week 1 of any year always starting with the monday on January 1 or nearest monday after?

Or do you want simple ISO week calulation? Then remember that there can...

select * from resources where resourcename LIKE '%[' + char(224) + char(225) + char(226) + char(227) + char(228) + char(229) + ']%'

update resources

set resourcename = replace(replace(replace(replace(replace(replace(resourcename, char(224), char(97)),...

You are using SQL Server 2005, are you?

asc desc diff

1   4    3  -- even number of datapoints

2   3    1

3   2   -1

4   1   -3

1   3    2  --...