Browse by Tags

Home ›

All Tags » sql » queries (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
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 =
SQL Columns Will not appera in my Grid. ???

Hi, Most times I load my gridview with data from a database trough a Stored Procedure. This is my procedure: 1 Select SUM (korting) as Totaal_korting, ( SUM (korting)-( SUM (bedrag))) as totaal_betalen, 2 CASE 3 WHEN ( SUM (korting)-( SUM (bedrag)))=0 THEN 'Te Ontvangen' 4 WHEN ( SUM (korting...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by bakoven on 08-12-2008, 12:00 AM
Filed under: SQL, SQL 2005 ASP.NET, sql queries, sql Query, sql stored procedure, "store result" " variable on Stored Procedure" "Stored Procedure", asp .NET 2.0 SQL data sqldataadapter, help, gridview, queries, ".NET 2", "ASP.NET and SQL Server"
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
Combine Two SQL Queries With Separate Where Statements

I have two SQL queries that I would like to combine. Each query is dependent on the same table, and the same rows, but they each have their own WHERE statements. I've thought about using some JOIN statements (left outer join in particular) but then I run into the problem of not having two separate...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by sliprix on 06-18-2008, 12:00 AM
Filed under: separate, SQL, statement, combine, where, queries, two, alias
Top 10 most costly queries by user?

The websites I write use ad-hoc queries instead of stored procedures. So when I run the following query: SELECT TOP 10 [Average CPU used] = total_worker_time / qs.execution_count ,[Total CPU used] = total_worker_time ,[Execution count] = qs.execution_count ,[Individual Query] = SUBSTRING (qt.text,qs...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by PhatboySlim on 01-08-2008, 12:00 AM
Filed under: SQL, queries, Performance
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
Tricky SQL query

Hi I have the following query: SELECT ClientName, BackupTypeID, StatusID, BackupDate FROM tblBackup INNER JOIN tblClient ON tblBackup.ClientID = tblClient.ClientID tblBackup - BackupID, BackupTypeID, ClientID, BackupDate, StatusID tblClient - ClientID, ClientName I would like to display the data like...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Jonesy26 on 07-03-2009, 12:00 AM
Filed under: SQL, queries, vb.net, Sql SerV ER 2008

Page 1 of 2 (12 items) 1 2 Next >

Browse by Tags

Related Posts