when i connect to Integration SErvices under tht MSDB

i get an error

" Failed to retrive data fro this request.(Micorsoft.Sqlserver.SmoEnum)

Additional information:

Login timeout expired

An error has occured while establishing a connection...

Update Site

SET

Site.CorpOHPer,sp.CorpOHPer=isnull(sp.CorpOHPer,''),

Site.DivOHPer,sp.DivOHPer=isnull(sp.DivOHPer,'')

Site.RegOHPer=sp.RegOHPer,

Site.BurdenPer=sp.BurdenPer

from StagingSiteProfile sp

WHERE Site.SiteID=sp.SiteID

I am using ISNULL so that if there is a null value for that column I want to replace it by blank, buti get...

After changing the settings and tried selecting excel sheet in sql i got this error

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"...

can i use this in sql serevr 2005

sp_configure 'Ad Hoc Distributed Queries', 1

yeah i am trying to do that.

how cud i configure this...

Msg 15281, Level 16, State 1, Line 1

SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries'...

DECLARE @Month int

set @Month=1

;WITH emps(empID)

AS

(

SELECT empID FROM

#tmpemp

)

select @month,hours

from emps inner join hours

on emps.empid=hours.empid

I get...

Hey could any one give me a different approach than CTE's for this.

How do i check isolation level of a database?

is this all we have to do

ALTER DATABASE

SET ALLOW_SNAPSHOT_ISOLATION ON

Just with simple joins this is not working for me, may be i need 2 CTE's in place of 2 cursors as it was earlier.

Its not just CTE's but i...

How about using

select * from ServerA

EXCEPT

select * from ServerB

I may get rows that are not matching in ServerA but how would I update rows in serverA from ServerB which...

I am not supposed to add any columns in there.

This is my original Query

SELECT DatePart(yyyy,CompanySnapShot.Period)as Year,

DatePart(qq,CompanySnapShot.Period)as Quarter,

CompanySnapShot.DivId AS DivisionId,

CASE

WHEN SUM(TotalHoursWorked) > 0

THEN (SUM(ReportableCount)...

that was only little data, i'll put some data for u

2005-09-01 00:00:00 9.25

2005-07-01 00:00:00 ...

here sum(Hours) will sum all the hours, i just need sum for each quarter like

sum(1,2,3) as qtr 1

sum(4,5,6) as qtr 2

How would a CTE version look like?