On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
SET NOCOUNT ON; declare @cmd varchar(max) declare @columns varchar(max) set @columns = '' select @columns = @columns + '['+CAST(MeetingDate AS CHAR(10))+'],' from morning_call_dates WHERE Display = 1 order by MeetingDate asc select @columns = substring(@columns, 0, len(@columns)) SET @cmd = ' SELECT * FROM vw_morning_call PIVOT(MAX(Entry) FOR MeetingDate IN ('+@columns+')) AS MeetingDate' exec (@cmd)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Need to replicate a Log table||4||41|
|SQL Server for XML PATH giving wrong results.||6||61|
|SQL 2008 - Disappearing Temp Table in Stored Procedure||24||64|
|first parameter x of the decimal (x, y)||1||27|
Join the community of 500,000 technology professionals and ask your questions.