perfect thanks MickyT

David - perfect thank you so very much for this!

Hopefully this is what you are after?

is this what you are after?

drop table testdata

Create table testdata (

Caseid [Varchar](30) NULL,

weeknum [float] NULL,

[monthName][nvarchar](255)...

No problems its on its way, thanks!

Hi Vinu,

the excel sheet has both the data output and the expected result from what I am trying to achieve. There are 2 sheets on the excel document. Is this...

Ok was able to get this done now:

Here is the table structures

CREATE TABLE [dbo].[HMD](

[WeekNum] [float] NULL,

[MonthName] [nvarchar](255) NULL,

[Response1_Num] [float] NULL,

[Response2_Num] [float] NULL,

[Response3_Num] [float] NULL,

[Response4_Num] [float] NULL,

[Customer Id] [nvarchar](255) NULL,

[Email_Queue_Name] [nvarchar](255)...

Point taken will do over the weekend - thanks guys.

Thanks Lynn I can appreciate what your saying but the reason I gave you that dummy data is because the data is confidential, I can not simply throw it up.

I...

No So what I mean by comments is the comments field in the SQL.

So all of this data I have is created by customers, and because of that there is...

Thanks all, I really should have been clearer. The data is very much dynamic I can't predict what to expect from the comments. I was giving you a sample of...

Phil I used as xxx, that did the trick.

In relation to the convert, it actually did work. I thought this would work as my perception of running a linked server...

Perfect - now getting

Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "name" is a duplicate.

Owh the joys of mySQL and...

Thanks for your continued help Roddy.

just a FYI, updated to the lastest CU3 for 2008 r2 sp2, still no improvement. I will review your last post and come back to...

Yeah I am in AU, SYD - its only 4:00PM here.

Cheers

Hi Roddy,

thats helpful. While the CPU usage is low on the query it does jump up a little. If this server were loaded it actually might have a serious impact....