1,694 Topics
| |
I want to combine the following select statements so I can have 1 export file rather than 2. This code selects student information along with their HomeRoom teacher. [code]SELECT students.last_name, students.first_name, students.grade_level, teachers.last_name, students.student_number FROM students JOIN CC ON students.id = cc.studentid JOIN teachers ON teachers.id = cc.teacherid WHERE (cc.course_number … | |
Hi guys; I need your assistance. I am extracting some info from my database and I need difference between two fields of money values. Lets call the fields as Field1,Field2,& Field3. Field1 = Current Balance Field2 = Starting Balance Field3 = Field1 - Field2 From my query, I get Field3 … | |
Hello all, I'm pretty new to PHP & SQL. I am having some trouble with a web voting page I'm creating. I have a PHP loop which is displaying data from SQL table A. Beside it, a small text box linked to SQL table B to allow users assign numeric … | |
OK...guys... I'm about to have a cow here. It sounds real simple but I just can't seem to get it. Here is the deal: I have a normalized database made up of four tables (Primary Key in bold) Player ([B]PlayerID[/B], PlayerName) NHLTeam ([B]NHLTeamID[/B], PoolTeamName) PoolTeam ([B]PoolTeamID[/B], PoolTeamName) PlayerStats (PlayerID, NHLTeamID, … | |
I'm working on a Java program that is calling sqlcmd. It works perfectly on a computer with SQL server installed, but not at all on a computer that doesn't. I want to include the necessary exe and dll files to run this command in my jar. Anyone know which ones … | |
Hi All, I have a table in mysql in which there is a column which have following kind of data $Category=>Income;$NAV=>10.2181;$Repurchase;Price=>0;$Sale;Price=>0;$Date=>26-Feb-2008; I want to Bifurcate the data in that column into 5 separate columns in the same table in this way $Category=>Income in this thing "Income" in column "category". $NAV=>10.2181 … | |
Hi All, We want to create a c#/VC++ application by using which we should be able to create sql server database SNAPSHOTs in our own file format (in online manner). And later we should be able to get data from those snapshots files in offline manner using our application ( … | |
Hi All, Is there any way to convert the Sql Server 'Snapshot' files (*.ss files) to some other format...like 'xml','xls' or 'txt'...etc. Thanks. | |
i m using sql 2000, vs 2003, asp.net, c# i want to create a serch for my web site i m doing using sql full text serch but the way i know is to show the result in a data grid . but i m looking a way to show … | |
hi, i m trying to run a query on an MSAccess table, but it does not give me any count but only 0. There are 3 null values which i should be getting but it does not give me the result. This query works perfectly in MSSql Server 2008. the … | |
Hi all, I have an assignment about analysing the Distributed Information System for a typical International Shipping Company such as Hapag-Lloyd, Sally Line UK etc. The assignment mentioned about some objects such as Ship, Container, Consignment, Port, Voyage, Client, Representative, Contract, Manifest log, also about Crane system, Crane controller, Cranes … | |
Iam writing (or trying to write) a simple join query statement in Query Analyzer. As of right now Im getting the error message Ambiguous column name 'categoryID'. My Statement is ; [code=sql]Select categoryID, Max (StockPrice) as maxStockPrice, MIN(StockPrice) as minStockPrice, AVG(StockPrice) as avgStockPrice From Category, InventoryPart Where Category.CategoryID = InventoryPart.CategoryID;[/code] … | |
Hello. I have searched, and found database tool the [URL="http://www.powerdbtools.com"]PowerDBTools[/URL]. Who knows how can I convert my Access database to SQL 2008 with this tool? Thank you. | |
HI i am planning to create a SQL IDLE using asp.net and C# . in that i am going to implement 4 modules : 1) Student Login module 2) Student Teaching Module (like w3schools.com ) 3) Student Feedback module (personalized feedback ) 4) correction module Now my problem is that … | |
Hey, so I have a form and i want to break down the form into 2 sections when inserting into my database. I have made 2 tables to hold my values. this is my SQL statements. [CODE] $sql_insert1 = "INSERT INTO `agent_users` (`user_name`, `password`, `primary_email`, `secondary_email`, `join_date`, `last_accessed`, `activation_code`, `first_name`, … | |
OK, this may not be possible in SQL, but here goes. I'm writing an app that allows the end user to select a date range and filter by area code, but I want them to be able to select as many area codes as they want. My question is with … | |
i write the procedure for login in this user can give username or emailid for the login. this is my code.... please check is there any change is required for this [code=text] ALTER procedure [dbo].[users_login] (@username varchar(50),@password varchar(50), @emailid varchar(50),@ret int output) as begin select username,password,emailid from users where( username=@username … | |
| Hello All, I apologize for what seems to be a simple thing to solve but I'm not sure why I can't get the correct result below. Here is the code and the problem: I'm using .HTACCESS to password protect a directory. I'm taking the username and storing it in a … |
Hello, I've wound up with a strange problem with my php script. The script goes into a SQL DB and checks the values of two different columns to see if they are equal. If the columns are not equal, then I store all of the possible values in column 1 … | |
Hey guys, I'm working on an SQLite3 wrapper using C programming. I was wondering if you know how can I set database properties such as mode, headers and echo through the C application. For example when running the SQLite shell and you are connected to the database you can do … | |
Hi I need to insert a flat text file into a SQL Server table using C#. The text file lines are 500 characters long and I will need to break it up into columns. Column 1 – 6chars, Column 2 – 1chars, Column 3 – 8chars I’ve managed to read … | |
Hi, I searched all over the net for a clear solution but what solutions i have found just leave me with more questions and answered. I have a multi step form using IF statements such as: [CODE] if(isset($_POST['2'])) { echo "step2 data"; }else if(isset($_POST['3'])) { echo "step3 data with text/ … | |
I purchased a book that included an evaluation version of 2008 enterprise. I had downloaded SQL 2005 express and had tried to download 2008 which said it succeeded and I was left with 2005. I checked the OS list of supported ones. XP professional is on the list. XP home … | |
[code=sql] alter table pets_like_boys drop constraint pets_like; alter table boys_like_girls drop constraint boys_like; alter table girls_like_pets drop constraint girls_like; drop table pets_like_boys; drop table boys_like_girls; drop table girls_like_pets; create table pets_like_boys (pets_name varchar(32), boys_name varchar(32),primary key (pets_name)) ; create table boys_like_girls (boys_name varchar(32), girls_name varchar(32),primary key (boys_name)) ; create table … | |
Hi, it's me agian... I was asked to do reasearch on how to upload a txt file's data into a MS SQL Database (corresponding columns etc.) I've searched a bit on the internet but don't find what i'm looking for... I just want to ask does anyone have an idea … | |
Hello everyone I've been trying to google this and had no luck with this issue So i have this form where it prints a certain record i search, but im trying to do restaurant form and a print form that it will print the last order done. So I Know … | |
Hello, I'd like to get help for a database engine in Python. I know that there are loads of databases out there and I cannot create one which would be even near as good as SQL but I'd like to do it for getting a good understanding of databases and … | |
I was wondering if it was possible to this: example [CODE] if exists(Select * From table) select item from table set returnValue = 1 Else set returnValue = 0 [/CODE] Or if there any other way of doing this this | |
Can anyone please point me towards a good C# SQL tutorial. I've been looking for about 10 minutes, but I can't find a good one that actually works. I would apperciate anyone that helps me! Thanks! Nile |
The End.