crackbridge, kindly let us know if our solutions have answered your question.

The 'ID' column in the Generation CTE is an Alias for the Mother and Father fields in the source table. You can also write it like this ...

-- Create the...

EDITED: and going further with Ninja's approach ...

;WITH

ListWithRows

AS (SELECT

(ROW_NUMBER() OVER (ORDER BY id)/5)+1 as rowNumber

...

As Gsquared said. "It depends"

But if you just want to avoid the error message then use NULLIF:

declare @test-2 varchar(30)

Set @test-2 = ''

--Set @test-2 =...

Not sure which CD it's actuall on. Either one should bring up the same install menu. Just select Client Tools and you'll be fine.

Search BOL for the "OVER" clause and "ROW_NUMBER"

All good advice above.

I'd add ....

- Create a database that holds your personal finances, movies or song list.

- Visit this site EVERY DAY, read questions, post questions, etc... The knowledge...

I only post this as it is related to your request and although it may be more complicated, it does allow for more functionality... 🙂

Go HERE ->http://www.sqlservercentral.com/articles/2824/

GilaMonster (5/18/2011)

---

Grant Fritchey (5/18/2011)

---

In general, except for data, most of the time the flow of structural changes is not from production down to a dev or test environment, but the...

Red-Gate SQL Data Compare[/url]

and

Red-Gate SQL Compare[/url]

They work magic! 😀

Please check out the article in my signature and provide us some DDL and sample data. That makes our help that much easier to provide to you for free. 😀

This is the most recent code I have. It may need some tweaking for 2008, I've not tested it on '08.

http://www.sqlservercentral.com/articles/Development/2824/[/url]

Jeff Moden (5/15/2011)

---

vilonel (4/8/2011)

---

thanks WayneS - will read the links - but will a pivot \ crosstab work for my scenario because I am not looking to sum, count etc...

Sorry, this is SSAS and not my cup of tea. (yet)

It almost sounds like you're asking how to write your query to get weekly/monthly data.

Can you post the code you're using for the daily info?