Hi

SQL is not good at pivoting data , even with the PIVOT operator you have to know your finite list of columns.

Take a look at BOL (Books online) for...

Please post DDL and sample data that shows your issue and i'll take a look

Obviously you did take it the wrong way, pardon me for attempting to find out what your level of knowledge is.

You can still use Min and Max on varchar columns, does that help ?

john.imossi (9/1/2009)

This runs but it returns no data, I'm surprised it will run at all to be hoenst. When I used to create something similar to this in Oracle...

Check out my blog here http://sqlandthelike.blogspot.com/2009/03/blog-post.html for how to build the contiguous range, then its a case of taking the inverse.

Hi Riz,

row_number() is documented in bol and returns an incrementing number.

DayMask is a column in my table 1=Monday , 2=Tuesday , 4 = Wednesday , 8 =Thurs etc....

and as...

Hi ,

getdate() will give you the current datetime then

see BOL (books online) for the Dateadd statement

Try this link

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

This is all you need to know about concatenating strings

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

You cant im afraid.

If its unique its unique

http://msdn.microsoft.com/en-us/library/ms175132(SQL.90).aspx

Maybe the best thing would be to split this column out to another table and reference it back to this table.

Thats the key here, sql is not designed to easily (perhaps more importantly efficiently) do that.

You could try dynamic SQL http://www.sommarskog.se/dynamic_sql.html

or a...

Andy Hogg (8/27/2009)

---

I get my head around clustered vs. non-clustered indexes by thinking of a clustered index as being like a phone book.

In a phone book data is sorted in...

Hi Fred,

did something go wrong with your post ?

The code segments look the same.

Heres a good resource on calendar tables

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Its just a simple query DayMask = 1 Means Mondays ,WeekNo is encoded as YYYYWW

with cteWeeks(dte,WeekNo,RowN)

as

(

Select dte,WeekNo,row_number() over (order by dte)

...