This Script takes any table wich contains rows with names and valus and converts it into a result set with the names as collumn names and the values as values.Just set @TableName,@vcName,@vcValue to the desired values.
2004-03-02
187 reads
As a Consultant, I would typically answer with – it depends! Then a typical...
The Never-Ending Question in IT: Which Approach to Take? As a Consultant, I would...
By DataOnWheels
Hello data friends! Had a blast at my first ever M365 Community Day this...
A colleague of mine has setup SSAS monitoring through Extended Events and these are...
Hi All, We have setup a 3 node SQL Server 2019 (CU30) multi subnet...
What happens when I run this code in SQL Server 2022?
create table Names ( namestring varchar(20)) go insert Names select 'Steve' go select choose(namestring, 'steve', 'andy', 'brian') from NamesSee possible answers