As you've got no publications or subscriptions to worry about I'd be tempted to disable replication and configure it again.

Sirish,

Something else you could try is

INSERT INTO ##ClusterNode

EXEC XP_CMDSHELL 'SET COMPUTERNAME'

... then substring the result if you get anything sensible back.

Suresh,

It's not particularly pretty but something along these lines might work :

SELECT datepart(hh,[time]), case when datepart(mi,[time]) < 30 then 1 else 2 end, sum([callsoffered])

FROM <table>

GROUP BY datepart(hh,[time]), case when datepart(mi,[time])...