Thank you i noticed that sep12 is on Latin1_General_CI_AS and sem5 is on SQL_Latin1_General_CP1_CI_AS.

however if i can add like below still it gives an error

SELECT SEM_COMPUTER.COMPUTER_NAME ...

Thanks it worked fine

I want to use Select INTO

Thanks i figured it out

Thanks,

I used cast(cast(b.Memorysize as numeric(20,2))/1024/1024/1024 as numeric(13,2)) as Memory,

and it gave me 255 which is correct.I want the answer to show GB eg 255GB

Thanks i figured it out.thats how we learn!

Thank you .Now i know

Thanks Luiz its returning same information as before.

I have a sql agent job that feeds information about clients computers into a table xxxx once a week.I have a report that...

I sorted some of data out to work with.

INSERT INTO [dbo].[PNS_Sect_6_SiteSEPStatusSnapshot](ID,Site,CaptureDate,SEPStatus,NoOfClients,CreatedOn,IsAtEnd)

Values(

(873,'landau','2016-05-26 21:00:01.370','Drop Link',0,'2016-05-26 21:00:01.370',NULL),

(874,'landau','2016-05-26 21:00:01.370','Offline',0,'2016-05-26 21:00:01.370',NULL),

(875,'landau','2016-05-26 21:00:01.370','Total',3,'2016-05-26 21:00:01.370',1),

(876,'landau','2016-05-26 21:00:01.370','Up To Date',3,'2016-05-26 21:00:01.370',NULL),

(865,'kriel','2016-05-26 21:00:01.350','Drop Link',0,'2016-05-26 21:00:01.350',NULL),

(866,'kriel','2016-05-26 21:00:01.350','Offline',0,'2016-05-26 21:00:01.350',NULL),

(867,'kriel','2016-05-26 21:00:01.350','Total',16,'2016-05-26 21:00:01.350'1),

(868,'kriel','2016-05-26 21:00:01.350','Up...

YearDateMonthDateSEPStatusIsAtEndNoOfClients

2016.04Apr-2016Drop LinkNULL 34

2016.04Apr-2016OfflineNULL 368

2016.04Apr-2016Up To DateNULL 931

2016.04Apr-2016Total ...

I am not sure if you will be able to read it.example below

IDSite CaptureDate SEPStatusNoOfClients ...

Hi John,

I am glad you know exactly what i want to archieve.Below is the table defination and the data.Thanks !!

CREATE TABLE [dbo].[PNS_Sect_6_SiteSEPStatusSnapshot](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Site] [nvarchar](100) NULL,

[CaptureDate] [datetime] NULL,

[SEPStatus]...

The query that i am using looks like the one below.

SELECT

Name,

Memory,

Model

FROM [xxxx].[dbo].[Status]

where

active = 1 and

and name not...

Thanks Tom,Infact i have more than those names mentioned above.Almost 30 names.

Hie Do you know Powershell very well?How can i build a credential object to connect to a remote server located on different domain.