Browse by Tags

Home ›

All Tags » sql » query (RSS)

complex dynamic query - best practice/approach?

I'm coding something pretty common - using form input to create a dynamic database query and displaying the results. However, some of the form controls are multi-select boxes, so my query winds up containing a lot of loops and looking pretty messy. Any suggestions/example code on the best approach...

Posted to Getting Started (Forum) by lcountee on 10-31-2006, 12:00 AM
Filed under: SQL, query, loop
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: SQL, query, queries, complex, friends
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: sql, Data Access, DataSet, ADO.NET, C#, Query
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: .NET SQL Server 2000, SQL, sql Query, sql 2000, query, queries, sql join, SQL query SELECT columns, Nested Queries In SQL, sql efficiency, SQL inner join, "SQL Server"
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: SQL, query, Retrieve, month
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: SQL, sql Query, sql 2000, query, queries, sql server
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: SQL, query, queries, query?, sql server
Re: complex dynamic query - best practice/approach?

Did you try our EasyQuery library: http://devtools.korzh.com/eq/dotnet/ It is free for non-commercial use.

Posted to Getting Started (Forum) by korzh on 11-07-2006, 12:00 AM
Filed under: asp.net, SQL, query, query builder

Page 1 of 1 (8 items)

Advertise on ASP.NET

About this Site

Browse by Tags

Related Posts