Beginner--Create SQL Query

Jan 19, 2008

I'm an Absolute beginner to SQL

I have a table of baseballTeams with columns baseballTeamName and a baseballTeamID

A have another table (baseballGames) which consists of baseball games which includes a homeTeamID and a visitingTeamID.
Both of these columns are linked to the baseballTeamID from the baseballTeams table

I have been successful at joining the two tables and Selecting the baseballTeamName from the baseballTeams table for either the hometeam or
visiting team as shown below:

SELECT gameID, homeTeamID, baseballTeamID,baseballTeamName
FROM baseballGames, baseballTeams
WHERE baseballGames.homeTeamID=baseballTeams.baseballTeamID


...but I cannot figure out how to select BOTH the homeTeam name and the visitingTeam name from the baseballTeam table

Any help would be greatly appreciated

Thanks in advance

Larry

View 6 Replies


ADVERTISEMENT

Help Me!beginner Create Database Password

Oct 27, 2006

I've learn DotNetNuke.I don't know how to create passID and userID for database sqlserver2005 express.someone help me.Thanks!thanks!

View 4 Replies View Related

Beginner Question: Find Or Create Function

Jan 18, 2007

I have a table with two columns: siteID (int primary key) and siteName(varchar(50) unique constraint).I am completely new to databases and UDFs and would like to write afunction that looks for a particular siteName and returns the siteID.If the siteName is not found then it would create a record and returnthat record's siteID.I am pretty sure there is a standard way of doing it and have beenlooking for examples, but have yet to find anything on Google.If anyone could point me in the right direction I would be verygrateful - I am still looking and will reply if I find anything.Many thanksJon

View 6 Replies View Related

Beginner Query Question

Apr 11, 2003

I have a query returning the Average of an Integer with a precision of zero. However because of this in my query and export I am only returning whole numbers for my Average.

Is there anyway in the query to modify the field for what I want to view so that it will return decimals?

Thanks in advance.

Don

View 1 Replies View Related

Beginner Question - SQL Query

Feb 15, 2008

Hello there,

Say I have the following table:


ID Type Name
--- -------- ---------------
1 1 Michael
2 1 Julian
3 2 Catherine
4 2 Julia
5 2 Silvia
6 3 John

What SQL query should I use in order to get the following output:

Type Name1 Name2 Name3
------- ----------- ------------ ------------
1 Michal Julian NULL
2 Catherine Julia Silvia
3 John NULL NULL

I believe this is a very basic question, but I can't seem to find the answer anywhere.

View 5 Replies View Related

Beginner's Question: How To Write This Query

Jul 14, 2007

Hi -
I feel stupied b/c I can't figure this out but I hope it's just a few seconds for some of the more senior posters of this forum:
I have a table that looks like this:
Table:RequestID: bigint... (a bunch of table specific columns)User_Status_ID: bigint (holds the bigint ID of the status table, below; always holds the ID to the most recent ID, if several)Provider_Status_ID: bigint (holds the bigint ID of the status table, below;  always holds the ID to the most recent ID, if several)
and then there is a second table that looks like this:
Table: StatusID: bigintRequestID: bigint (the request ID, so I can see all status messages for the request)Time: TimestampCode: byte (there are only a few status messages)
The status table holds both the status for users and providers, as they use exactly the same status code. What I'd like to get is a table/view that looks like this:
RequestID:bigint (the request that this status belongs to)User_Code: byte (the code of th most recent user status)Provider_Code: byte (the code of the most recent provider status)
Somehow, I am blanking how to create a query that returns both user and provider codes in one row. Any help greatly appreciated!!!!
 
Oliver

View 2 Replies View Related

[absolute Beginner] Help For SQL Basic Query Exercise

Apr 29, 2008

hi

i am learning SQL basic commands ( like , where, having, group by, order by , join ,and simple sub-query) and I got one exersice I cannot solve

table RECIPE has 3 columns , ( pizza ,ingredient,amount)
each pizza could use 1 / many ingredient, each ingredient could be used by 0 / 1/ many pizza, amount means the quantity of that ingredient used in certain pizza

question:
(List the ingredients, and for each ingredient, also list the pizza that contains the largest amount of this ingredient.)

============================
Raw data :

recipe
======
pizza ingredient amount
--------------------------------
margarita spice 5
margarita cheese 120
ham ham 150
ham spice 5
napolitana anchovies 100
napolitana olives 75
napolitana spice 10
hawaiian ham 100
hawaiian pineapple 100
hawaiian spice 5
cabanossi cabanossi 150
cabanossi spice 10
siciliano onion 50
siciliano capsicum 75
siciliano olives 50
siciliano anchovies 50
siciliano spice 15
americano salami 120
americano pepperoni 75
americano spice 10
mexicano onion 75
mexicano capsicum 75
mexicano mushroom 50
mexicano chilli 25
mexicano spice 20
seafood seafood 200
seafood spice 5
garlic garlic 25
garlic spice 10
vegetarian onion 50
vegetarian capsicum 50
vegetarian mushroom 50
vegetarian peas 50
vegetarian tomato 50
vegetarian spice 5
mushroom mushroom 100
mushroom spice 5
special cheese 25
special tomato 25
special ham 25
special anchovies 25
special olives 25
special mushroom 25
special bacon 25
special egg 25
special pineapple 25
special cabanossi 25
special salami 25
special capsicum 25
special onion 25
special peas 25
special seafood 25
special spice 10
stagiony ham 75
stagiony mushroom 50
stagiony olives 50
stagiony anchovies 25
stagiony spice 10


====================================================

Query Results needed:


ingredient pizza amount
------------------------------
anchovies napolitana 100
bacon special 25
cabanossi cabanossi 150
capsicum mexicano 75
capsicum siciliano 75
cheese margarita 120
chilli mexicano 25
egg special 25
garlic garlic 25
ham ham 150
mushroom mushroom 100
olives napolitana 75
onion mexicano 75
peas vegetarian 50
pepperoni americano 75
pineapple hawaiian 100
salami americano 120
seafood seafood 200
spice mexicano 20
tomato vegetarian 50

=============================================

Thanks

View 10 Replies View Related

Query Execution Failed For Dataset (Beginner)

Jun 26, 2007

I got this Error, Query Execution for Dataset 'Source'.



When i try to run a report that is actually a drillthrough from another report. It runs fine in Report Designer, and when i deploy to my Local server. But when i deploy it to my virtual Report Server, I get this error messege. Why is it doing this? and where can i see errors for this type of stuff, so i can figure this out. This uses the same Datasource as the report linked from it. That report works fine, why wont this one? any ideas?

View 8 Replies View Related

How To Create A Make-Table Query With A Union Query

Oct 30, 2006

I have successfully execute a union query. How can i create a make-table query to accomodate the resultset of the union query?

View 2 Replies View Related

Sql Beginner

Aug 4, 2000

I am just a sql beginner. I wonder if it is possible to jump to table B to continue searching while I am still doing search on table A. Thanks

J

View 4 Replies View Related

DTS - Beginner

Oct 9, 2000

Can anyone tell me where I can learn more about DTS.
As I have to export data from a .CSV(comma separated file) into SQL Server.

View 5 Replies View Related

Beginner

Sep 12, 2007

I have MS SQL 2000 and 2005 Express install on my computer. I would like to know where I can get some good beginner's training and I also need to know how to run sql scripts and import database to both.

This is so easy to do in mysql.

Thanks

View 1 Replies View Related

Beginner Please Help

Aug 19, 2005

I have a SQL server that my web host has provided but I don't know who to set it up! I'm currently have an MS Access database on my web site and I want to change it to MSSQL using the Access upsizing wizards, can anyone talk me through it?

View 2 Replies View Related

Beginner Needs Help With SP

Dec 8, 2006

hi there. this is my first post on this forum. im new to SQLServer so please go easy on me. :)

i am trying desperately to call a stored procedure from within another stored procedure. if i post my code below could somebody tell me where i am going wrong. the SP i have written is executing OK but the OUTPUT parameter Id_User is coming back as null, whereas it should be giving my a value there. i have tried changing the line 'EXEC sp_User_I' for 'INSERT INTO @User_Id EXEC sp_User_I' but this wont compile.


CREATE PROCEDURE sp_Account_I]
@Username varchar(16),
@Password varchar(88),
@Surname varchar(32),
@DateBirth datetime,
@Email varchar(64),
@Id_Account int OUTPUT,
@Id_User int OUTPUT

AS

DECLARE @ErrorCode int;

BEGIN

SET NOCOUNT ON;

EXEC sp_User_I
@Username,
@Password,
@FirstName,
@Surname,
@DateBirth,
@Email,
@Id_Country,
@Id_User

...do some other stuff here for the account...

END

View 4 Replies View Related

Beginner SQL Help

Mar 19, 2008

Hi all,

I've been banging my head against this issue, and I haven't managed to find a solution. I was hoping that maybe somebody here has done something similar.

I am trying to get the latest available pricing from a Rate table, which is based on the customer ID and the provided date from another table (Table1).

This is what the code looks like, essentially:

select
table1.*
,table2.*
,table3.Rate

from table1
left outer join table2 on table1.Id = table2.Id
left outer join (
Select Top 1 Rate from RateTable
Where RateTable.date < table1.date
order by RateTable.date desc
) as table3 on table3.custId = table1.custId

I understood that table1.date can't be explicitly passed into the nested join within table3, but does anybody know a work around that can achieve the above example (the environment is SQL server 2000 and inside a view not on in a stored proc)?

Thanks in advance for any tips or workaround.

View 1 Replies View Related

BCP Beginner - Please Help

Jul 23, 2005

Hi,I am completely new to the BCP utility and fairly new to SQL ServerI am learning from a book and I am trying the following example (the serverI'm learning on is called contractor and a password has not been give to thesa)bcp pubs..authors out authors.txt -C -r -t, -U sa -P -S contractorWhen I run this in Query Analyser i get the error message..Server: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '.'.I have tried puuting quotes around the database and the table name asfollows-bcp "pubs..authors" out authors.txt -C -r -t, -U sa -P -S contractorand get the errorServer: Msg 179, Level 15, State 1, Line 1Cannot use the OUTPUT option when passing a constant to a stored procedure.Please can anybody help me to get this first bit working?Thanks in anticipation.

View 2 Replies View Related

SQL Beginner

Nov 15, 2005

What is the best way to go about learning SQL?  Where should I start?

View 20 Replies View Related

As A Beginner

Sep 4, 2006

How do i learn SQL server 2000...I'm new to development, and need to get my basics right before i proceed further.

Do give me your feedback / learning tips.

View 1 Replies View Related

SQL Beginner

Apr 19, 2008

Hi

is there any SQL server book or online meterial for beginners?? i've checked msdn its seems not helpful at beginner level.like issues for installing and first time configuring SQL Server. and installing its clients etc.

View 1 Replies View Related

How To Make The SSMSE To Return Whole Records Without Any Close Query Form And Re-create Query Form Operation?

Dec 25, 2007

Hi,
I got a problem.
I installed Microsoft SQL Server Management Studio Express 2005 version.
And I created a Compact database.
I created an connection in SSMSE to connect the database and opened a query form.
then, i run the following sql:

Select * from Table1

It returned 3 records to me.
After that, I used program to insert record into this table.
Then i ran this sql again, it still show me 3 records.
I closed the query form, and re-created a new query form, then run the sql, it returned 4 records to me.

Why? It's very strange and difficult to operate, right?
Is there anyone know how to make the SSMSE to return whole records without any close query form and re-create query form operation?

Thanks a lot!

And Merry X'max!!!

View 4 Replies View Related

Some Questions From Beginner

Jan 23, 2006

hello all i'm new in dot net and as every one beginning in something i have some problems hope u guys can help me my first question is really easy i'm feeling silly to ask such a question i made database in sql server 2005 and i made a table and columns but i cant insert data into the table i dont know how to fill the table with data? my second question is can i convert sql server 2000 database to 2005 if i can how i cando that? that's all for now hope u can really help me thanks in advance

View 4 Replies View Related

Beginner Seeks Help

Aug 31, 2006

My company needs a database. My first thought was to do it in Access, because it's available! But I wanted to check that that was smart, what its limitations are, when it's better to move to bigger / more expensive software, etc.

It's probably going to have several hundred thousand records in and will grow by more than a hundred thousand every year. Is there a size limit?

Not that many fields, though - it's not that complicated a database.

Many thanks in advance for any help :beer:

View 4 Replies View Related

Beginner && DB Creating

Feb 7, 2007

Hi!

I'm trying to make a dictionary.

WordEng(#id,word);
WordIta(#id, word);

tables with words in Italian and English.
Connect1(#id,id1,id2); connecting word form Eng with Ita translation.
Connect2(#id,id1,id2); same for Italian.

Is this correct? 3. normalisation? Will this work?

View 5 Replies View Related

Another Beginner SP Question

Dec 8, 2006

if i am creating an SP then i only specify output parameters if the SP is to return a single set of values. is that correct? if my SP is returning multiple rows from a SELECT statement then i would not specify any parameters on the SP. can somebody clarify this for me. thanks!

View 2 Replies View Related

Help Im A Beginner... Insert

Aug 17, 2007

Hi guys,

I am new to database programming... i know the answer is somewhere in the past forums and i unfortunately i can't locate it... I have this problem i hope you can help me.

I am trying to insert values into table hosp_wareitem and one of it is the itemid where in i would like to get the item id of an existing medicine... (i hope you can understand me guys) here is my query.. right now im puzzled and i know the answer is already there.. i just cant see it...


set xact_abort on
declare @id as integer
begin transaction
select @id (select medicines_id from
hosp_medicines where medicines_id = medicines_id)
insert into Hosp_WareItem
(ItemID,
Department_ID,
SalesGL_Code,
COSGL_Code,
InventoryGL_Code,
ExpenseGL_Code,
ReadersFeeGL_Code,
CreateBy,
UpdateBy,
DeleteBy,
CreateDate,
UpdateDate,
DeleteDate)
values
(@ID,
'1',
'AAA-111',
'AAA-000',
'AAA-112',
'',
'',
'0',
'',
'',
'1/1/1900 12:00:00 AM',
'1/1/1900 12:00:00 AM',
'')
Update Hosp_Counter set Counter_ID = @ID
where Table_Description = 'wareitem'
commit transaction

it returns an error

(1 row(s) affected)


(24 row(s) affected)

Server: Msg 515, Level 16, State 2, Line 6
Cannot insert the value NULL into column 'ItemID', table 'Medix_Hospital.dbo.Hosp_wareitem'; column does not allow nulls. INSERT fails.

it tries to insert a null value in itemid because it cant get the value of the medicine_id.

any help is much appreciated!

puzzled
joel

View 2 Replies View Related

Beginner Questions

Oct 16, 2007

Hi all,

This looks like a great place for SQL Server support. I hope you don't mind a few n00b questions.

I'm a sysop whose main experience is with Windows XP and SBS 2003. I'm also reasonably familiar with Access 97/2000, having programmed a few small databases. I've recently acquired a client who is running the premium version of SBS, which includes SQL Server 2005. This means I have to manage this thing. This *huge* thing. So my first question is: Where can I find information to get me started, first from a sysop perspective, and later from a Access programmer perspective. What is your experience?

Then two current issues. One is that for some reason SQL Server 2005 is using about 2 gigabytes of memory out of the box. Is this normal? Second, I can't for the life of me find the backup system. I can see backups being made of the AdventureWorks database (at 3:00), but even after 2 hours of searching I can't change the schedule. I knew how to do this in SQL Server 2000, but this version is very different.

I'd much rather figure these things out on my own, but this product is just too complicated to learn in a few days, and the memory usage issue is critical.

I'd be much obliged for any help you can offer.

View 3 Replies View Related

Beginner To SQL Server

Jan 9, 2008

Please add me for real-time ask for help.
My MSN: ices_ailee@hotmail.com
My Yahoo: ices_ailee@yahoo.com.sg

Please add my msn or yahoo account, easy for me to enquiry straight forward ...thx yo. I am a junior and beginner with SQL Server.


thx yo!

chia ling

View 3 Replies View Related

Beginner Student PL/SQL To T-SQL

Jul 23, 2005

Hi,I'm finishing up a beginning SQL class where we learned on an Oracledatabase and the transition to working on SQL Server is easy. The next moreadvanced course will be in PL/SQL, but I know I will be working on SQLServer in the workplace, so my question is if I should take this course.Will I benefit from the basic philosophies that will be covered, or will itjust make a transition for me more difficult? Will it be partly a waste oftime and money and I'd be better served getting a book and self teachingmyself? I know that in a greater sense learning something isn't necessarilya waste, but I mean from the perspective of my goal of being able to use SqlServer, will this course be useful?thanks.

View 10 Replies View Related

Beginner's Question

May 22, 2007

I just installed SQL Server 2005, Office 2007, and the add-in, but when I check services.msc, I don't see the SQL Server Analysis Services. Does anyone know how I can get this to load? Also, when I run the server configuration utility in the DM add-in folder, do you know what I should put in the server name to get it to run off my hard disk and not a server? local host doesn't seem to work. Thanks in advance!

View 11 Replies View Related

SQL SERVER Beginner

May 8, 2007

Hi! Everybody,

i am totally new to the environment of MS, (.Net, SQL Server...)

i was working previously with Oracle 9i. I have downloaded MS SQL Server Express 2005, MS SQL Mgmt Studio Express, ..

i want to build a database, and import my data to it. How to do so?

View 1 Replies View Related

SQL Beginner Question

Apr 7, 2008

Hi all....

I'm not good t adatabases and never had to install one before, but I have an easy question....

I need to install a big application that needs a database server in the back end to run, I have a box with SQL2005 installed on it and I need to let the server be the database server for this application that will be installed on a seperate box....

How would I be able to point this application to the database server? do I need to install a SQL client on this server and point it to the SQL2005 server in the back?

Do I need to create a "new database" on the SQL sever and give it a name and credentials then point the application to that database? if that is the case, how would I do it?

Thanks.

View 6 Replies View Related

Drillthrough (beginner)

Jan 5, 2007

I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening?

The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this:

Years

Counties Total Crashes Fatalities

Cook 85 98

Manchester 2850 258

Sagamon 987 526



So when a user clicks a county, such as "Cook", this is displayed

Years

Age Gender Total Crashes Fatalities

0-8 Female 25 8

Male 55 15

9-15 Female 850 258

Male 185 35

16-22 Female 87 526

Male 10 35



But I am getting this in :

Years

Age Gender Total Crashes Fatalities

0-8 Female

Male

9-15 Female

Male

16-22 Female

Male



Whats going on? Can anyone make any suggestions? Just to let you know its based off of an Analysis Services Cube and not relational tables.

View 2 Replies View Related

Beginner Help With Insert

Dec 9, 2007



Hello,



First off, I'm completly new to SQL.
I'm trying to create an insert command that uses a select command as a value.


INSERT INTO Activation.dbo.Selected (PID) SELECT PID FROM ElecDB.dbo.PTT WHERE Vendor = 'guy'

What I get from this is 5 rows updated which is what I wanted.
Although, I would like to insert a UserID from C# code or for now just 1151 for example.
I'm assuming that it would look something like this:


INSERT INTO Activation.dbo.Selected (PID,UserID) SELECT PID FROM ElecDB.dbo.PTT WHERE Vendor = 'guy' , 1151


but I am not even close.
Please help me with this.

Thanks,
Guy

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved