Home ›
All Tags » query » "T-SQL" (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
Page 1 of 1 (3 items)

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