Not the best for performance because it isn't sargable but this should work.

;with Nums(Num)

as

(

select 100.00 union all

select 200.00 union all

select 350.01 union all

select 235.07 union all

select 38.10 union all

select 4.006...

Then you will need to become familiar with date routines.

Lynn has some great ones here. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/%5B/url%5D

You can use that to figure out your starting date. Then you just need...

sunshine-587009 (6/22/2012)

---

Hi there!

I'm trying to get the last update statement to work and it is not work for me. I receive errors on the join. Any help appreciated!

Results I'm looking...

Koen Verbeeck (6/21/2012)

---

Oh god not him.

He's the most important reason I have such a high post count. Trying to help him...

How about some ddl and an explanation of what you are trying to do?

You should start your own thread instead of jumping onto another one.

Before you start...

The point is that you have a thread trying to resolve this already. If you just start a new thread it fragments the...

But what is the error message?

Take a look at the links in my signature about cross tabs. The first one covers PIVOT and some alternative ways to do the same thing. The second one talks...

SQL_Kills (6/22/2012)

---

Hi,

Thanks for your advice so far and what you have shown me.

The table you created QuestionFieldsNormalized was what the table originally looked like that when pulling the data from...

Do you mean intellisense? There is a version built into SSMS 2008 but...it is less than optimal. Redgate sql prompt is...

OK so once we have this somewhat normalized this type of data manipulation becomes a whole lot more manageable.

Something like this produces the desired results from your sample data.

declare @MappedField...

At the very least you should normalize your EAV pairs. This is worst of the two worst data structures combined into a single table. This just makes we want to...

Lynn Pettis (6/21/2012)

---

Because there are two columns with the value...

You are very welcome. Glad...