SELECT '0' as zu_id, id, lbid+' '+lg+ulg+' '+stichwort as vtext , '' as link FROM lbh.dbo.view_LB_pos where ebene='ulg' and lg='01' and replace(lbid, 'LBHB', '')='LBHB17' and lg+ulg in (select left(code17,4) from haiden_kalkulation) order by ulg
select zu_id, id, lg+ulg+posnr+' '+stichwort as vtext, '' as link from lbh.dbo.view_LB_pos where replace(lbid, 'LBHB', '')='LBHB17' and ebene='grundpos' and lg='01' order by ulg
Ebene: 2...
select id, zu_id, lg+ulg+posnr+fp+' '+stichwort as vtext, '' as link from lbh.dbo.view_LB_pos where ebene='pos' and lg='01' and replace(lbid, 'LBHB', '')='LBHB17' and lg+ulg+posnr+fp in (select codeLBHB17 from haiden_kalkulation) order by ulg
System.Data.SqlClient.SqlException (0x80131904): Ungültiger Spaltenname 'codeLBHB17'.
bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
bei System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
bei System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
bei System.Data.SqlClient.SqlDataReader.get_MetaData()
bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader()
bei ASP.doc_tableeditor.doc_tableeditor(String lsMandantenCode, String lsParameter, String lsRequest, String lsTemplateNum) in g:\inetpub2\wwwroot\dotnet\icontent\usercontrols\doc_tableeditor.ascx:Zeile 3639.
ClientConnectionId:ea8b0f6f-9977-4957-aad0-e78440493474
Fehlernummer (Error Number):207,Status (State):1,Klasse (Class):16
...
select id, zu_id, lg+ulg+posnr+fp+' '+stichwort as vtext, '' as link from lbh.dbo.view_LB_pos where ebene='pos' and lg='01' and replace(lbid, 'LBHB', '')='LBHB17' and lg+ulg+posnr+fp in (select codeLBHB17 from haiden_kalkulation) order by ulg
...1...-9999