Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
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)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|sql 2016 data tools breakdown..||1||36|
|partitioning database after decade growth||8||80|
|SQL works but want to get the XML node data separately||11||57|
|T-SQL: problem comparing datetime||4||83|
Join the community of 500,000 technology professionals and ask your questions.