I have two conditions in which both need to be met in order to be displayed on my datagrid, however, my SQL query is not returning my desired results. I have a bit column named Sailed in my tblTransit table and a StatusID in my tblWaybill table. They are joined together by a transitid. What I am trying...
Posted to
SQL Server, SQL Server Express, and SqlDataSource Control
(Forum)
by
bcoffey
on
10-06-2008, 12:00 AM
Filed under: SQL TSQL duplicate, sql Update, sql wildcard parameter, SQL XML Stored Procedure, sql:executescalar, SQL+Hosting, sql2000, SqlBulkCopy, SqlBulkCopy SqlTransaction, SqlCacheDepenency, SqlCeDatabase, sqlclr, SqlCommand, SqlCommand Error Exception Method not found, sqlcommand parameters, sqlconnection, SqlDataReader, sqldatasourc, sqldataSource, SQLDatasource GUID, SqlDataSource Inheritance, SqlDataSource Parameter, sqldatasource parameter multiple, sqldataSource parameter Type session, sqldatasource query insert, SqlDataSource query select, SqlDataSource Repeater, SQLDataSource TimeStamp sql_variant is incompatible with timestamp, SQLDataSource Update .NET 2.0 negative return, SqlDataSource WHERE-IN, sqldatasource wizard views, sqldatasource.filterexpression, SqlDataSource.SelectCommand, sqLdatasourcecommandeventargs, SqlDataSourcource, sqldatsource selecting, sqlexception database offline, SqlExceptions, sqlhelper, sqLl, SQLL Excel ADO JET SSIS, SQLL SERVER RAM, SQLL setup, SqlNetFramework, sqlParameter class, SQLServer, sqlserver 2000, sqlserver 2005, SQLServer 2005SP2, sqLserver2005, sqlserverver, Sqlserverver 2000, sqlserverver 2000 transaction DTC ws-at atomic transaction Port 135 port135 connectivity sqltransaction system.transaction LWT 134 135 RPC API .NET2, statement, store procedure, Store procedure variable FROM clause, stored procedure case sorting direction, stored procedure for archiving the records in another table, SQL Views, SqlCommand CommandBuilder, sqldataadapter, sqldatasource datalist in datalist, SqlDataSource GridView Count, SQLDataSource parameter Type Table, sqlddatasource, SQLServere2005, SqlStoreDataSource, stored procedure, Sql Where Clause, sqLdataparametercollection, sqldatasource filter, SQLEXPRESS, SqlExpress 2005 Advanced Modifiy Database, sqlscript, standalone application, stored procedure 3