1 2
| SELECT IIf(IsNull([1]),[CodeG],[1]) AS 0, IIf(IsNull([2]),[CodeG],[2]) AS deux, IIf(IsNull([3]),[CodeG],[3]) AS 3_, IIf(IsNull([4]),[CodeG],[4]) AS 4_, IIf(IsNull([5]),[CodeG],[5]) AS 5_, IIf(IsNull([6]),[CodeG],[6]) AS six, IIf(IsNull([7]),[CodeG],[7]) AS 7_, IIf(IsNull([8]),[CodeG],[8]) AS 8_, IIf(IsNull([9]),[CodeG],[9]) AS 9_, IIf(IsNull([10]),[CodeG],[10]) AS 10_, IIf(IsNull([11]),[CodeG],[11]) AS 11_, IIf(IsNull([12]),[CodeG],[12]) AS 12_, IIf(IsNull([13]),[CodeG],[13]) AS 13_, IIf(IsNull([14]),[CodeG],[14]) AS 14_, IIf(IsNull([15]),[CodeG],[15]) AS 15_, IIf(IsNull([16]),[CodeG],[16]) AS 16_, IIf(IsNull([17]),[CodeG],[17]) AS 17_, IIf(IsNull([18]),[CodeG],[18]) AS 18_, IIf(IsNull([19]),[CodeG],[19]) AS 19_, IIf(IsNull([20]),[CodeG],[20]) AS 20_, IIf(IsNull([21]),[CodeG],[21]) AS 21_, IIf(IsNull([22]),[CodeG],[22]) AS 22_, IIf(IsNull([23]),[CodeG],[23]) AS 23_, IIf(IsNull([24]),[CodeG],[24]) AS 24_, IIf(IsNull([25]),[CodeG],[25]) AS 25_, IIf(IsNull([26]),[CodeG],[26]) AS 26_, IIf(IsNull([27]),[CodeG],[27]) AS 27_, IIf(IsNull([28]),[CodeG],[28]) AS 28_, IIf(IsNull([29]),[CodeG],[29]) AS 29_, IIf(IsNull([30]),[CodeG],[30]) AS 30_, IIf(IsNull([31]),[CodeG],[31]) AS 31_
FROM [Copie de R_Planning_Analyse croisée(1)]; |
Partager