Browse by Tags

Home ›

All Tags » query » SQL (RSS)

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
First Web & Web 2.0 oriented database is released

The first release of Eloquera, the fusion database, is out. Eloquera's architecture and technology specifically targets at the Web developer. It provides the desired objectives of speedier development and maintenance. At the same time, it provides the seemingly contradictory benefit of startlingly...

Posted to Announcements (Forum) by bablind on 11-21-2008, 12:00 AM
Filed under: object-relational, Productivity, Programming, query, Search, servers, sql, web application, Web applications, web components, .NET 3.0, .NET based CMS, AJAX, asp .NET 2.0 database objects sql, asp.net, ASP.NET 2.0, ASP.NET 3.5, c#, csharp, Data access, dotnet, asp .NET 2.0, API, Find
Help with SQL Queries and If conditions...

Hi, I'm selecting a list of results from a table called 'slots'. In a different table, called bookings, I have 3 important fields, 'booked', day_id, and week_num. Now, what I want to do, using SQL or ASP.NET logic, is get the slots from the table 'slots' where booked is not...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by planemaniac on 10-14-2008, 12:00 AM
Filed under: query, reelation, SQL, Table
Dynamic LINQ Objects

I have spent quite some time Googling and looking around for anything relatively related to my subject, and have found very little. My scenario is this: I want to use LINQ in a web application, BUT I need the ability to dynamically create a Data Context, I believe it's called? The .dbml file that...

Posted to Data Access and ObjectDataSource Control (Forum) by JMoore5268 on 09-17-2008, 12:00 AM
Filed under: Query, sql, Visual Studio 2008, "Linq to Sql" LinqDataSource, .NET 3.5 SP1, asp.NET 3.5, asp.net 3.5 Linq, C#, data Acces, Data Access, Database, dynamic LINQ, LINQ in Action, Linq query, LINQ SQL Dynamic predicate builder, Linq to SQL, LinqDataSource, database connection, Linq, linq ado, LINQ databasecontext dbml, LINQ databasecontext dbml System, 3.5, Data Access connections, Data Access Application block, linq databasecontext
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 =
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
Sql query to retrieve Comments based on Selected Month and Data

hi, i am generating report for my project. my table goes like ID VASID VASSID JanMail JanVisit JanPhone JanComment FebMail FebVisit FebPhone FebComment................. DecPhone 1 25 4 True False False Mail me False True False Visit me My report has 3 check boxes for Mail,Visit,Phone respectively and...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by rahilameen on 01-04-2008, 12:00 AM
Filed under: query, Retrieve, SQL, month
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
Re: Ican't update my dataset

here i post the code that i wrote i take the stage and depId from two textboxs and beging to excute the queries usin tabel adapter and put the desired result in arrayList then because the tableadpter StudentCourses1 can't up date the dataset as contain multiple table so i use table studentCourses...

Posted to Data Access and ObjectDataSource Control (Forum) by semsem0 on 06-08-2007, 12:00 AM
Filed under: Query, sql, C#, Data Access, DataSet, ADO.NET

Page 1 of 3 (21 items) 1 2 3 Next >

Browse by Tags

Related Posts