Home ›
All Tags » query » query? (RSS)

Browse by Tags

Related Posts

  • Union or Join? Can't quite get my query dialed in.

    I will try to make this question as simple as possible. I basically want to display a running balance of credits and debits in my datagrid. Background: We are shipping agents at the Panama Canal and attend vessels that transit. Each transit has various cost items associated with them (canal tolls, line...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bcoffey on 05-26-2009, 12:00 AM
    Filed under: outer join, queries, query, query null value, query optimisation, query?, sql 2000 sql query, sql 2000 sql queryerver management studio express problem, SQL 2005, SQL 2005 SQL, sql express, sql server, SQL Server 2005, sql server 2005 express edition installation, sql server update, sql stored procedure, sql 2000, sql 2000 "sql server express 2005", SQL 2000 2005 from Ms Access 2007, sql 2000 administration security asp.net, Sql 2000 Dates, SQL 2000 Server, SQL 2000 Server Connection, SQL 2000 SQL 2005 migration syntax, SQL 2000 vs SQL 2005, SQL 20005, sql 2005, Sql 2005 .NET, SQL 2005 .NET ExecuteNonQuery, sql 2005 .NET ExecuteNonQuery return id of newly inserted record, SQL 2005 .NET full-text indexing, sql 2005 .NET Select query limits, SQL 2005 .NET SP storedprocedure options split, SQL 2005 ASP.NET Navision aspx.vb, SQL 2005 Design, SQL Distinct, SQL Programming, sql queries, sql queries gridview, sql Query, sql query rows, Sql query/views, "GROUP BY", "sp_executesql", "SQL Select and Update Where ", "SQL Server", "T-SQL", sql script

  • Non-Agregate function PIVOT table needed...I think

    Here is the data that I get back from my SQL query (SQL 2005): ID NIIN WSC 1 015565845 M3A 1 015565845 M4A 2 015576613 M5A 2 015576613 M6A 4 015576709 M5A 4 015576709 M6A 6 015576712 M5A 6 015576712 M6A 7 015623462 IRM 7 015623462 M1A 7 015623462 MYA 7 015623462 MZA Here is my SQL: SELECT RobListOfNIINs...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by BrianFan on 05-12-2009, 12:00 AM
    Filed under: multiple, Multiple queries, multiple result sets, queries, query, query?, SelectCommand, slq 2005, Slq Server, SQL, SQL 2005, sql 2005 server, SQL 2005 SQL, sql 2005, Sql 2005 .NET, SQL 2005 Design, sql 2005 stored procedure full text index, SQL datatable, sql efficiency, SQL inner join, SQL Programming, sql Query, "MSSQL error", "SQL Server", "T-SQL", .net 3.5, data Acces, Dynamic Query, dynamic sql, Dynamic SQL&quot, Select Statements, "ASP.NET and SQL Server", sql script

  • Need foreach functionality in Stored Procedure

    I have a stored proceudre that brings back 6 columns (PART, FSC, NIIN, NAME, TotalQty, ReqID). After the SELECT statement has run, I need to update one of my tables. In the table that I need to update, there is a column named ReqStatus, and this tables PK is ReqID (from above SELECT statement). Fore...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bfancett on 12-05-2008, 12:00 AM
    Filed under: query, query?, slq 2005, Slq Server, SQL, SQL 2005 SQL, sql server, SQL Server 2005, sql server update, sql 2005, SQL Server 2005, Stored procedure sql, Stored Procedure update / insert, stored procedure variables, stored procedure variables WHERE clause, stored proceduredure sql, stored proceduree, Stored procedures, StoredProcedure, StoreProcedure, UPDATE, update column, Update SQL Statement, update statement, "T-SQL", "User Defined Function", 2005, asp.net c# profiles sql server, ASP.NET C# sql, c#, C# SQL, column attributes, column name, column name query, Data, Database, HAVING, "Dynamic SQL", For Each Loops, for loop, queries, SQL 2005, SqL For Each Loops, update records, "SQL Server", .net 3.5, db

  • Find nth Max value in sql

    Hi all, I am using SQL 2005 Express, I have a table like this, Table Name : Employee Eid Name Salary 1 harry 3500 2 jack 2500 3 john 2500 4 xavier 5500 5 steven 7500 6 susana 2400 I would like to select the nth maximum salary in this table, and suppose if there is 100 records in this table, i want to...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by prnkrish on 08-28-2008, 12:00 AM
    Filed under: MSSQL Aanalysis Service, MySQL "MS SQL Server 2005" data import, MySQL server 5, query, query?, Server 2005, serverver 2008 sql 2005 performance, SQL, Sql 2000, sql express, sql express developer CTP windows xp x64 edition, SQL Server 2005, sql server update, sql stored procedure, sql 2000, SQL 2000 Server, SQL 2000 SQL 2005 migration syntax, sql 2005, Sql 2005 .NET, SQL 2005 .NET ExecuteNonQuery, SQL 2005 .NET full-text indexing, sql 2005 .NET Select query limits, SQL 2005 ASP.NET, SQL 2005 ASP.NET Navision aspx.vb, SQL 2005 Server / ADO.NET, sql express, SQL Function, SQLServer, sqlserver 2005, sqLserver2005, MS SQL Server, MS SQL SubQuery, sql server, sql server 2005 concurrency, mySQL, queries, SQL 2005, sql 2000 "sql server express 2005", SQL 20005, sql 2005 express connect error, "SQL Server", SQL Server 2005, MSSQL, MSSQL2000 Analysis Services, Sql server Subquery returned more than 1 value. This is not permitted when the subquery follows =

  • A T-SQL question?

    I have this flat file with the following data 'ga100010020080526'. I took this data and inserted it into a single column called STORE_DATA, and now I want to break it up into sections to be able to insert it back to a new table. For example, I would like to grab the first two characters 'ga'...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by xyz789 on 07-17-2008, 12:00 AM
    Filed under: query, query?, return value, sql server, SQL Server 2005, sql Insert, sql queries, Stored procedure Insert, stored procedure variables, stored proceduree, StoredProcedure, TSQL, sql server, queries, SQL datatable, SQL Server 2005

  • Show the decimal part in query

    Hi, In the following query the calculator gives value 3.3 but the query returns 3.0 I need to get the decimal part also. i.e I need to get 3.3 as answer from the query. select cast(66/20 as decimal(6,2)) Need help. Thanks
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by su.rameshraj on 06-19-2008, 12:00 AM
    Filed under: query, query?, SQL, sql server, queries

  • Getting error while passing values as special chars

    Hi friends, I m facing an error while i m passing the values in query as special characters like (',"). anyone can help me? code will be more preferable. Thank you.
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jaymehta_26 on 03-04-2008, 12:00 AM
    Filed under: query, query?, querystringparameter, selectparameters, queries, "SQL Server", SELECT, SELECT ExecuteNonQuery
Page 1 of 1 (7 items)

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.