Hi

Thanks for this simple and effective code.

Is there a similar easy way to get the year of that week we are looking for? Or the "ISO-year"?

Lets say I put in...

SimonLiew (8/12/2013)

gfey (8/12/2013)

... On the other hand the resultset of first solution depends on the option ANSI_NULLS. If the option is set to ON the query returns only rows where...

Thx for the article. Very interesting.

Hi

Great article and this looks very interesting. How about performance, have you looked into that?

Given a table that has the history of changes to some value, and the changedate for the new value :

CREATE TABLE [dbo].[AnleggMeasurementTypeHistory](

[AnleggsId] [decimal](18, 0) NOT NULL,

[FromDate] [date] NOT NULL,

[MeasurementType] [int]...

jacroberts (8/10/2009)

ronmoses (8/10/2009)

10. WHERE clauses - In a WHERE clause, the various operators used directly affect how fast a query can run. Here are the conditional operators used in the...