Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
declare @cols nvarchar(2000) select @cols = stuff(( select distinct top 100 percent '],[' + convert(varchar,t2.Calldate,105) from [Source table] as t2 order by '],[' + convert(varchar,t2.Calldate,105) for xml path('')), 1, 2, '') + ']' declare @query nvarchar(4000) set @query = 'select [Mobile no],' + @cols + 'from (select [Mobile no],convert(varchar,CallDate,105) CallDate,Disposition from [Source table]) t1 pivot (max(Disposition) for Calldate in (' + @cols + ')) as p' exec (@query)
Join the community of 500,000 technology professionals and ask your questions.