Lors de l'exécution de [select cdta.id_Classement as sH_IdClassement,     case when isnull(cdta.state,'')='' then cast(cdta.pos as varchar)+'.' else cdta.state end as [sR_#POS] ,	cdta.dossard as [sI_#NR] ,	cdta.licence as [sC_#LICENCE] ,case when isnull(privacy,0)&8192!=0 then 'ANONYMOUS' else	isnull(nom,'')+' '+isnull(prenom,'') end as [sB_#NAME] ,	case when year(cdta.naissance)>1900 then cast(2012-year(cdta.naissance) as varchar) else '' end  as [sC_#AGE] ,	isnull(cdta.nationalite,cdta.pays) as [sC_#NAT] , left(cdta.club_open,15) as [#OPEN] ,	cdta.tours as [sR_##]	,d0.temps as gDetails_t_t1,d1.temps as gDetails_t_t2,d2.temps as gDetails_t_t3,d3.temps as gDetails_t_t4 ,	cdta.officiel as [sB_t_#OFFICIEL] ,	cdta.categ as [g#CATEGORIE_#NOMCATEG] , cdta.ville as [sI_#LOCALITE] from classement_data cdta  left join classement_detail_data d0 on (d0.id_classement_data=cdta.id and d0.id_config=965)  left join classement_detail_data d1 on (d1.id_classement_data=cdta.id and d1.id_config=966)  left join classement_detail_data d2 on (d2.id_classement_data=cdta.id and d2.id_config=967)  left join classement_detail_data d3 on (d3.id_classement_data=cdta.id and d3.id_config=968)  where isnull(cdta.state,'')<>'DNS' and cdta.id_Classement=7801 and ('0' is null or cdta.idx-1>='0') and ('499' is null or cdta.idx-1<='499')  and (null is null or cdta.ville like null)  and (null is null or cdta.club_ligue like null)  and (null is null or cdta.club_open like null)  and (null is null or cdta.categ = null)  and (null is null or (cdta.dossard=null)            or (isnull(cdta.nom,cdta.prenom) like null)      )  order by cdta.idx ]: System.Data.SqlClient.SqlException (0x80131904): Ambiguous column name 'nom'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at ChronoRace.Common.Sql.SqlTools.<>c__DisplayClass34_0.<GetDataSet>b__1() in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 579
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.<ExecuteAction>b__0()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry, DataSet ds) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 572
ClientConnectionId:9b751f3f-7d18-4d45-b429-d50f00f4b4ed
Error Number:209,State:1,Class:16
ClientConnectionId before routing:141e10dc-6d4e-40ca-8236-251ef3159bc4
Routing Destination:b2c289c1c6f9.tr22.northeurope1-a.worker.database.windows.net,11022
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at ChronoRace.Common.Sql.SqlTools.<>c__DisplayClass34_0.<GetDataSet>b__1() in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 579
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.<ExecuteAction>b__0()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry, DataSet ds) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 572<br/><blockquote>   at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry, DataSet ds) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 601
<br>   at ChronoRace.Common.Sql.SqlTools.GetDataSet(DbConnectionProvider provider, IDbConnection conn, String qry) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\SqlTools.cs:line 612
<br>   at ChronoRace.Common.Sql.DataSetCache.GetDataSet(DbConnectionProvider provider, String qry) in D:\ChronoRace\git\chronorace-git\Modules\Infrastructure\Legacy\ChronoRace.Utilities.Sql\DataSetCache.cs:line 53
<br>   at ChronoRace.Print.Report.PagingData.PerformPaging(ReportGeneratorConfig cfg, PagingConfig paging, CCQuery ccq, Boolean pageable, Int32 firstPage, Int32 lastPage) in D:\ChronoRace\git\chronorace-git\Modules\Legacy\ChronoRace.Print\Report\PagingTools.cs:line 107
<br>   at ReportGeneratorGadget.get_PagingList() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Controls\ReportGeneratorControl.ascx.cs:line 59
<br>   at ReportGeneratorGadget.get_MasterRenderer() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Controls\ReportGeneratorControl.ascx.cs:line 34
<br>   at ClassementsClassement.GenereRapport() in D:\ChronoRace\git\chronorace-git\Web\Registration\ChronoRace.WEB.Azure\Classements\Classement.aspx.cs:line 975<br/><br/>Query: select cdta.id_Classement as sH_IdClassement,     case when isnull(cdta.state,'')='' then cast(cdta.pos as varchar)+'.' else cdta.state end as [sR_#POS] ,	cdta.dossard as [sI_#NR] ,	cdta.licence as [sC_#LICENCE] ,case when isnull(privacy,0)&8192!=0 then 'ANONYMOUS' else	isnull(nom,'')+' '+isnull(prenom,'') end as [sB_#NAME] ,	case when year(cdta.naissance)>1900 then cast(2012-year(cdta.naissance) as varchar) else '' end  as [sC_#AGE] ,	isnull(cdta.nationalite,cdta.pays) as [sC_#NAT] , left(cdta.club_open,15) as [#OPEN] ,	cdta.tours as [sR_##]	,d0.temps as gDetails_t_t1,d1.temps as gDetails_t_t2,d2.temps as gDetails_t_t3,d3.temps as gDetails_t_t4 ,	cdta.officiel as [sB_t_#OFFICIEL] ,	cdta.categ as [g#CATEGORIE_#NOMCATEG] , cdta.ville as [sI_#LOCALITE] from classement_data cdta  left join classement_detail_data d0 on (d0.id_classement_data=cdta.id and d0.id_config=965)  left join classement_detail_data d1 on (d1.id_classement_data=cdta.id and d1.id_config=966)  left join classement_detail_data d2 on (d2.id_classement_data=cdta.id and d2.id_config=967)  left join classement_detail_data d3 on (d3.id_classement_data=cdta.id and d3.id_config=968)  where isnull(cdta.state,'')<>'DNS' and cdta.id_Classement=7801 and ($first is null or cdta.idx-1>=$first) and ($last is null or cdta.idx-1<=$last)  and ($Localite is null or cdta.ville like $LocaliteLike)  and ($Ligue is null or cdta.club_ligue like $LigueLike)  and ($Open is null or cdta.club_open like $OpenLike)  and ($Categ is null or cdta.categ = $Categ)  and ($All is null or (cdta.dossard=$All)            or (isnull(cdta.nom,cdta.prenom) like $AllLike)      )  order by cdta.idx