Home ›
All Tags » query » queries (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

  • Correct my query please

    I have written a query: --------------------------------------------------------------------------------------------------------------------------------------------------- select distinct sc.trgid as 'Trg ID', req.trainingname as 'Training Name', convert(varchar, sc.plannedenddate, 105...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by su.rameshraj on 06-30-2008, 12:00 AM
    Filed under: query, SQL, sql server, sql 2000, sql Query, queries

  • Is this query possible ?

    Hi, In the Employee table I have their e-mail Ids. All the id's are already stored. Some are left blank. Now through a query I need to change only the part after @ symbol Example: If it is myname@abc.com then I wnat to make myname@abc.co.in OR myname@xyz.co.in In both cases the first part need to...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by su.rameshraj on 06-11-2008, 12:00 AM
    Filed under: query, sql 2000, SQL 2000 Server, sql queries, "Dynamic SQL", queries

  • Need help on Getting Result from row to column

    Hi I need help to build the below data to my requirement i have table having the following data's NoofLive Action Sold Ratio EffDt 10-49 43 0 0 1/1/2008 50-99 62 0 0 1/1/2008 100-199 73 0 0 1/1/2008 200-299 17 1 0.059 1/1/2008 300-499 25 0 0 1/1/2008 500-999 21 0 0 1/1/2008 1000+ 45 0 0 1/1/2008...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by sthanika on 01-17-2008, 12:00 AM
    Filed under: Pivot Table, query, sql Query, queries, "SQL Server"

  • Multitable query

    Hi there, I have what seemed to look a simple qeury but I get double results or not enough. There are 3 tables Toolboxes Tools ToolsInBoxes * ToolboxID * ToolID * ToolboxID * AllowedSizeID * SizeID * ToolID * Name * Name * Price1WhenPutInToolBox * #toolsInBox * PriceTool1 * Price2WhenPutInToolBox * PriceBox1...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Bonaparte on 11-11-2007, 12:00 AM
    Filed under: Nested Queries In SQL, query, SQL, sql 2000, SQL inner join, sql join, sql Query, .NET SQL Server 2000, queries, sql efficiency, "SQL Server", SQL query SELECT columns

  • complex SQL select query

    Hi all I im trying to write a SELECT query to display a set of my logged in user's 'Friends'. Although the way that i have designed my tables means that its very complex, and im hoping someone out there can tackle it! To start ill show you how i contruct friends: Friends FriendshipID Incrementing PK...
    Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by french_duke on 04-29-2007, 12:00 AM
    Filed under: queries, query, SQL, complex, friends
Page 1 of 2 (13 items) 1 2 Next >

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.