use BDSMSGYT
go

select top 100 * from BDSMSGYT..Proveedor

select top 1000 * from BDSMSGYT..SingleSMS
order by tmstmp desc

select top 100 * from BDSMSGYT..NS_accesos
where idusuario like 'cobrosconsumo%'


--update BDSMSGYT..TResumen
set Proveedor = 'Movistar'
where ISNULL(Proveedor,'')=''

delete from BDSMSGYT..TBatch
where Carga like 'test%'

select top 1000 * from BDSMSGYT..GruposClaro

select top 1000 * from BDSMSGYT..TResumen
select top 1000 * from BDSMSGYT..TBatch


mmprodat..scantb dsn

select top 100 * from BDSMSGYT..GruposClaro

select top 100 * from MMProDat..DSNData_0179

SELECT	COUNT(1) As TotalCarga from TBatch (nolocK)

SELECT	COUNT(1) As TotalCarga from TBatch (nolocK)

where carga='10er_envio2'