Can you post some sample data with expected result?

Thanks for your feedback and you are welcome 🙂

Where do you want to use the result?

A quick way should be

SELECT date_col from your_table

where right(date_col,2)>31 or substring(date_col,5,2)>13

In SQL Server 2005, you should make use of row_number() function

Also see what you can do with it

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx

Stop that query and try this

update

s

set sol_num=b.number

from

corpus.dbo.solution as s inner join corp.dbo.buckModifications as b

on b.arabic_vocalization = s.sol_arvoc and

b.stem = s.sol_stem and

b.lemmaid = s.sol_lemmaid

Have you tried using a stored procedure?

Note that isdate() is not fully reliable

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/09/24/handle-isdate-with-care.aspx

Also see how single quotes work in SQL Server

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/02/19/understanding-single-quotes.aspx

Something like

select dateadd(month,datediff(month,0,date_col),0),

sum(case when date_col>=dateadd(month,datediff(month,0,date_col),0)

and date_col<dateadd(month,datediff(month,0,date_col),8) then 1 else 0 end) as first_week,

sum(case when date_col>=dateadd(month,datediff(month,0,date_col),8)

and date_col<dateadd(month,datediff(month,0,date_col),15) then 1 else 0 end) as second_week,

sum(case when date_col>=dateadd(month,datediff(month,0,date_col),15)

and date_col<dateadd(month,datediff(month,0,date_col),22) then...

Another way of doing this

http://sqlblogcasts.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx

This is another method that uses OPENROWSET command which doesnot require CLR

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

I think it is better not to depend on a single character. So IMO better use set of junk characters as shown here

http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/06/squeeze-function.aspx

Make sure you read this

www.sommarskog.se/dynamic_sql.html

Where do you want to show your data?