Piotr you're a star, that's what I was looking for! Thanks a lot for your help, much appreciated!

Here is a sample script that should produce the table and populate it:

create table mySales (Unit_ID varchar(20),

Jul numeric(28,9), Aug numeric(28,9), Sep numeric(28,9),

Oct numeric(28,9), Nov numeric(28,9),...

The error I get is:

Msg 102, Level 15, State 1, Line 12

Incorrect syntax near ')'.

I see what you mean about the month exceeding 12 problem.

Hi,

The 2008 bit has only been put in to form a date so that the datepart will return the numerical value of the month only. Not sure I understand what...

Piotr Rodak (5/20/2008)

---

Hi David,

This is CTE - new construct in SQL 2005 that allows for easy browsing of recursive structures. In this case you can't say that data are...

Piotr Rodak (5/20/2008)

---

I gave it a bash, see if this can work for you:

create table monthacc(monthnum int, amount int)

go

insert monthacc(monthnum, amount)

select 1, 10

union all

select 2, 30

union all

select 3,...

Interesting article, thanks for the link

Perfect! Thanks for your help!

Thanks for the link to the article, I've not used either PIVOT or UNPIVOT before so I'm impressed with how easy it is to use. However, my query contains joins...

Thanks for the info, I'll give it a go and see what it reports!

Thanks all for your responses, much appreciated.

Thanks for the replies, I suppose that what I am unsure about is whether querying the table directly performs some sort of lock on the table that maybe a view...

Well, I can say that all appeared to go well but a word of warning to others who may think of doing the same - the process of uninstalling and...

Would it be advisable to restore any other system databases? Also, once I have uninstalled the instance is it safe for me to delete the SQL Server folders before reinstalling?

Thanks

Hi Cory,

Unfortunately I will have to query multiple servers so the update would set the server name field incorrectly.

Thanks

David