alter table tblplaylog alter column chip nvarchar(50) 

update   TelsaCo.dbo.OfflineRecordServers set TelsaCo.dbo.OfflineRecordServers.IsActive='2'

delete from OfflineCallInfo 
where OfflineCallInfo.RecordServerID in(select ServerID from OfflineRecordServers 
                                        where OfflineRecordServers.ServerIP is null
                                        or OfflineRecordServers.ServerIP='') 