Thanks Camilo

I will work through it and let you know what my outcome is.

Thanks alot!!

Anchelin

Hi John

Not really, but I'm on google now. Is there perhaps another site that can give me a broader explanation on PIVOT function? Please?

Here's my script for my table:

CREATE TABLE...

I can't do summary on Server A, thats our MOM Reporting Server...

And the 'summary' is taking forever to query...

The SMC_Instance_ID starts at 10088422.... all have unique ID's like 2084920 or...

OK...

I have to retrieve this data fom another server into a table on another server, then I have to summarise this data; its for Performance purposes...

'SMC_InstaceID' is the unique key (primary...

I don't have a unique key, because all the rows I retrieve are something like 'ComputerName', InstanceName', etc... I can add another column to get the results, like 'CounterDetail_FK'

But how...

I did exectly as you said and when I did the import gave me an error:

TransformCopy 'DirectCopyXform' conversion error: Conversion invalid for datatypes on column pair6 (source column 'Col006'(DBTYPE_STR) destination...

So... make my first five columns varchar and my other columns???

Also what length should I give my columns?

Thanks for your help so far!

Anchelin

Hi

No... I created a table with 256 columns, the same as CSV file...

Hi

the rows:

I created the table, right click on table, all tasks, import, and followed the steps....

Hi

Thanks...

I used the wizard to completes this task. When I ran the package, it gave me the error:

Too many fields defined.

It copies the data(256 cols) from the Excell spreadsheet and populate...

Hi

Thanks for the reply... I do have found another way of importing my spreadsheet; via DTS...

The problem I have is that my spreadsheet has 256 columns and the max...

Can you perhaps show me how to do this? I'm new with T-SQL.

Please

Anchelin

Hi

Yes, I have a datetime column in my table

Anchelin

Hi All

I manage to get this done, but have another problem though. I have the following:

Declare @FromDate datetime

Declare @TodayDate datetime