I Know I'm Stupid .. Please Help Me Correct Me.

Apr 13, 2008

I have two tables:
1) Table that holds all available ports.
2) Table that holds users for each port.

There may be times where one user is getting more than one port at a time.

I've built up an ASP .NET page that will display each user its port/s in one table.
On another table I want to display all the other available ports which the user doesn't posses and can buy to own.

My problem is where I try to build up the query. I just can't get all the other ports in normal display.



For example, this is what I need:

Ports table:
1/1
1/2
1/3
1/4

Users table:
User A , 1/1
User A , 1/2

ASP page display:

------------
User A Holds:
1/1
1/2
------------

Available:
1/3
1/4
------------


Of course the Available option is derived from the User Holds query, and just getting the opposit not equal ports, but I just can't get it !
I've tried all kinds of Joins and nesting SELECT queries with no luck.

I hate SQL. I want to die.

View 4 Replies


ADVERTISEMENT

I Did Something Stupid....

Oct 12, 2001

OK, I did something stupid and now cannot get access to my server...

I was experimenting with the security/login settings and denied access to BUILTINAdministrators. Now I cannot get on my server.

Anyone else ever done this? What can I do to get back on without loosing some of my data?

Any help would be appreciated.

Thanks!

View 1 Replies View Related

Stupid Q No.2

Aug 15, 2006

Still in the world of SAMS Teach Yourself SQL in 24 Hours with SQL 2000. The book says:

CREATE TABLE EMPLOYEE_TBL
(
EMP_IDVARCHAR(9)NOT NULL,
LAST_NAMEVARCHAR(15)NOT NULL,
FIRST_NAMEVARCHAR(15)NOT NULL,
MIDDLE_NAMEVARCHAR(15)NOT NULL,
ADDRESSVARCHAR(30)NOT NULL,
CITYVARCHAR(15)NOT NULL,
STATECHAR(2)NOT NULL,
ZIPINTEGER(5)NOT NULL,
PHONECHAR(10),
PAGERCHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID)
);


Query Analyser says:
Server: Msg 2716, Level 16, State 1, Line 3
Column or parameter #8: Cannot specify a column width on data type int.

If I take the (5) off the end of the INTEGER data type it runs through but how come you can't specify the width of an integer column?

Ta muchly.

View 6 Replies View Related

Impossible SQL, Or Am I Being Stupid?

May 7, 2001

I have a table that has three fields:

CATEGORIES
----------
catID
description
parentCatID


Some categories have sub-categories. Therefore, some entries will have null
for parentID while others will point to another category.

I need to select all of the categories, but have them returned in the
correct parent/child order (parents BEFORE children). I can't seem to get this to work correctly. Is this not possible or am I just being stupid?? :)

Thanks for any assistance.

Mike V.

View 5 Replies View Related

Stupid DTS Question???!!

Sep 10, 2004

Just a simple one I think?!!!!!

Is there any way of copying a DTS from one server to another?

I just need to play with this DTS on our test server but can't copy the thing!!!

Thanx!!!!

View 2 Replies View Related

Stupid Question I'm Sure

Oct 25, 2004

is there a way to format data on the tables. Such as Social security numbers 00/00/0000 or formating of dates 99/99/0000;0;_

is there a way of doing that on a sql table maybe??

View 3 Replies View Related

Okay I Know This Is A Stupid Question!

May 12, 2004

What is the "Microsoft SQL Server 2000 Resource Kit"

I was persuming it was a programme or patch for SQL server, however it's lookign more and more like a book.

Could some please clarify and if it is a programme/patch how can I get hold of it?

View 5 Replies View Related

Stupid Question Of The Day...

Nov 24, 2005

Afternoon everybody...

Here is my noob question of the day, is there a query I can run to display the STRUCTURE of a table? fieldnames, datatypes, sizes etc?

Select * from users where clue > 0

View 4 Replies View Related

The Most Stupid Sum Question

Apr 5, 2006

here is my problem.

i have a table that looks like this

barcode |movetype | qty

as3 | T | 4

as3 | R | 2

as3 | T | 1



here is my problem and i am probably just stupid. i need the total amount Transfered minus the Received per barcode. so here i would need to see a total of 3.

i don't know how to do this.

View 4 Replies View Related

Sorry For Stupid Question.

Aug 23, 2007

I've getting the error message at the time ntbackup starts the backup of the server:

Event Type: Error
Event Source: SQLWRITER
Event Category: None
Event ID: 24579
Date: 22-Aug-07
Time: 20:00:26
User: N/A
Computer: DBS
Description:
Sqllib error: Database DYNAMICS of SQL server instance XXX is stored on multiple volumes, only some of which are being shadowed.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 53 51 4c 53 4e 41 50 43 SQLSNAPC
0008: 33 36 31 00 00 00 00 00 361.....
0010: 53 51 4c 53 4e 41 50 43 SQLSNAPC
0018: 32 34 36 00 00 00 00 00 246.....


Where is the problem?
How to fix this?
Does this mean that I would not be able to restore server in the case of failure?

SQL - version SQL Server 9.0.3054 (2005 SP2)
OS - 5.2.3790 (W2k3 R2 SP2)

MS Dynamics GP 9 is installed on this platform.

Any ideas?

Thanks in advance.

View 7 Replies View Related

Stupid Replication Q

Jun 28, 2005

Hi,

View 11 Replies View Related

This Is Probably A Stupid Question But....endulge Me Please...

Mar 7, 2007

I am trying to insert form data...three form sections into three different tables....i can insert into one table just fine....is this not possible ...or what? If so can someone please send me a small sample... thank you ...by the way i am using visual studio...vb asp.net 2.0 with ajax. Thanks in advance!

View 6 Replies View Related

Stupid DBNull Question

Jan 3, 2006

I haven't tested it, because at the moment I can't access my SQL database
I know this is probably a stupid question, but...How can I test for DBNull when I'm using SqlDataReader.Item(string)?
I use to check it using: if(!reader.IsDBNull(2)) ...But I have found that can not count on a particular ordinal reference because some of the stored procedures select the columns in different orders.
can I do something like: if(reader["Column1"] != DBNull.Value)or with the reader["Column1"] throw an error because it is not found??
I too hate when people ask questions that they could test themselves...but I can't really test it at the moment.  Any input would be greatly appreciated.
 

View 2 Replies View Related

Stupid Backup Question

Jun 8, 2000

I'm trying to backup a database onto a different server
within the same SQL Server Group, but the Enterprise
Manager only offers the drives on the local server as
destination options. Do I have something configured
incorrectly or is there a way to do this manually?
Thanks in advance.

Doug

View 2 Replies View Related

Stupid Security Question

Mar 10, 2001

Ok, I'm trying to understand how the db user corelates to the SqL login. Can one db user have multiple logins attached to it (like dbo with sa and nt admins).

This is in reference to the issue of broken chains of ownership problems that pop up from multiple users creating tables in a single database. I would like to be able to make all the developers be the dbo user of a given database without making them a sysadmin of the entire server. Is this possible?

If not, is there a sp that fixes a db so that all ownership reverts to dbo?

Thanks in advance
fUngUs

View 2 Replies View Related

Where Question (stupid Newbie)

Oct 27, 2003

What does "WHERE 1=1" do?

View 2 Replies View Related

Maybe Is A Stupid Question.. About CASE

Mar 29, 2006

I have a little query in access ..now i must write it in T-Sql

the original...
(MSG.IDLINGUA = IIF( EXISTS
(SELECT * FROM ESMESSAGGI AS MSG WHERE MSG.IDLINGUA = [@idLingua] AND MSG.IDMESSAGGIO = BITS.IDDESCR),
[@idLingua], LDEF.IDLINGUA))


I can't be able to assign a select value at my field... IDLINGUA to perform another select..
Of course I have used the "select case when exists"

Anyone could be help me ?

View 2 Replies View Related

Stupid Question TIME!

Sep 7, 2007

Hi

I want to run SQL Server 2000 at home, on my PC. I dont have a server. My OS is Windows XP. Is this possible? Or do I have to use something like Access. If so then that sucks.

I use SQL Server at work and I want to practice at home.

please help

p.s i have Personal ed and standard ed.

thanks
Paul

View 9 Replies View Related

Stupid Northwind Question

Mar 3, 2004

I have installed MS SQL server eval edition and read through a lot of BOL, just about got my head around users and authentication etc and have a pretty good grounding on db design and architecture.

I now want to mess around with the sample databases a bit to get used to the SQL server interface before I start creating new ones etc but beyond random simple queries that I make up i'm struggling with what to do. I'm sure there are some microsoft tutorials based on the northwind and pubs databases I just cant seem to find any anywhere.

Any suggestions greatfully recieved, Cheers

Dan

View 8 Replies View Related

I Am Suffering With A Stupid Problem.

Jun 18, 2007

Dear Sql server experts
I am suffering with a stupid problem in login into SQL server using SQL authentication method
Well here is the case.
When I start SQL server management studio of sql server 2005
A connect to server dialog comes up with 3 enabled combo box's for server type , server name and authentication
If I connect to server via windows authentication then every thing goes fine but when I use the damn sql authentication so this alert occurred "Login failed for user 'toolbox', The user is not associater with a trusted SQL Server connection."
Even with sa.
Does any body has idea what to do? How to fix it? Please.

this is the alert when i use "sa"
TITLE: Connect to Server
-
Cannot connect to myserver
-
ADDITIONAL INFORMATION:
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

View 3 Replies View Related

Stupid SQL Question On Where Clause

Jul 23, 2005

Is there any difference in the order of parameters in the where clause?Does it add any speed to declare the least refined first or last?

View 3 Replies View Related

Stupid Timing Question

Jan 12, 2007

Hopefully, this is an easy. Does SQL Server use the Windows system dateand time? Or does it keep track of what day/time it is on its own?We were just discussing this in the office today, because we'replanning for the changes in Daylight Savings Time in the United Statesthis year. It's going to start a month earlier and end a month laterthan it used to. Microsoft is apparently putting out patches forWindows so the OS will know to adjust the time by an hour on the rightdays, and we're trying to determine if our SQL and Oracle databases aregoing to be affected at all.--Richard

View 2 Replies View Related

Stupid... Simple Question

Jul 20, 2005

In sql server 2000, how do you manually go and truncate the logs? Doesthis only occur when you create a backup? all I want to do is manuallyshrink the log files. I have backups, so I don't need them.I actually backup the db once a week and back up the logs every day,yet the logs are getting real big. I thought this was configured inthe backup and/or the maintanance plan. I've done a restore (from thedb backup) manually hundreds of times, but I've never had to restoreto a checkpoint from the transaction log backups, maybe this is whyI'm confused on how to do this.thanks,dave

View 1 Replies View Related

Stupid Newbie DDL Tricks

Aug 20, 2007

I have an SSCE database that I did not create. I'd like the app I'm working on to programmatically create said database the first time it runs (if for no other reason than the fact the next version may want to need the schema and not wipe out what's already there.

My idea was to have the Management Studio give me a database creation script like SSDE would and execute the T-SQL commands inside of the app but it doesn't appear that's something the Studio will do for SSCE databases. Is there another/better way to pull this off?

Tx

-Joe

View 5 Replies View Related

Stupid Late Night SQL Question

Dec 27, 2003

How do I return the updated value to client for this update?

UPDATE table SET x = x + 1 WHERE idvalue = y

View 1 Replies View Related

Feeling Stupid...SQL Cluster Question

May 9, 2008

This is bad, what I thought I knew about clustering I now am questioning as I research this more.

When I have a multi server (say 4 servers) cluster using Windows 2003 & SQL 2005 Enterprise editions, can they or can they not all access the same resource database? If not, then I need to know how to provide better service to a web app that is heavy on the database access. We have a load balanced front end (web services) but the current SQL Server is now becoming a bottleneck and need to start to spread the workload across multiple sql servers access the same database in real time. Data is not currently partitioned. Regardless of the arrangement I will need to maintain the cluster for failover, but also need to spread the workload.

Thanks

Raymond Laubert
MCITP:Administration, MCT
http://www.rd-webhosting.com
Home Based Business Library and Hosting

View 2 Replies View Related

Multiple Row Insert Into A Table (stupid, Yes)

Mar 31, 2008

Hi guys,

Okay, I really should know the answer to this by now, but the answer escapes me.

--Let's say I have a simple table:

create table #mytable
(
id varchar(3)
)
go

--Instead of doing this:
insert into #mytable
values
('ABC')
go
insert into #mytable
values
('DEF')
go

select * from #mytable
go

drop table #mytable
go

/*
I'd like to do this (since I might have anywhere from 20 to 50 of these, etc.).

Like:

insert into #mytable
values
('ABC','DEF','GHI','JKL')
go

(Obviously this doesn't work since I need to repeat the column name however many times) - but isn't there a simpler way to insert multiple rows into an unpopulated table?

Unfortunately, I don't have the data in another table somewhere already, so I need to manually populate, but was wondering if there was a convenient way of doing this.

Any help much appreciated!

*/

View 4 Replies View Related

SQL To Find Short, Fat And Stupid People

Jul 23, 2005

This is a question concerning query optimisation. Sorry if it's a bit long,but thanks to anyone who has the patience to help - This is my first posthere...If I have two tables: 'tblContact' and 'tblCategory' where categories arelike:Code Name010101 Short010102 Fat010103 StupidThe junction table 'tblConCat' has fields CctConID, CctCatCode to tell mewhich contacts have which category codes. These are nchar(6) fields, if itmakes any difference.If I need to find all people who are short, fat and stupid I can see twoways:Solution One:SELECT tblContact.* FROM tblContact WHEREConID IN (SELECT CctConID FROM tblConCat WHERE CctCatCode='010101') ANDConID IN (SELECT CctConID FROM tblConCat WHERE CctCatCode='010102') ANDConID IN (SELECT CctConID FROM tblConCat WHERE CctCatCode='010103')Solution Two:Build a helper table which contains the codes I'm looking forSELECT tblContact.* FROM tblContactWHERE ConID IN(SELECT CctConIDFROM tblConCat INNER JOIN tblHelperON tblConCat.CctCatCode = tblHelper.HlpCatCodeGROUP BY CctConID HAVING Count(*)=3)I have tried them both out and although I looked at the query analyzer itprovided more information than I knew what to do with. In practise theyboth provide similar working times (I wait about a second) but I thought thefirst looked rather inefficient and thought my helper table might help.There are about 30,000 contact records, 180 category records and 120,000junction table records.All I am looking for comments on any pros and cons of these two approaches -does one look that bad? The database was migrated from Access where thehelper table really did help, but using SQL Server I might not need it.Thanks again, if you got this far!

View 16 Replies View Related

Stupid Question: Joining Strings

Jan 21, 2007

HiThis is a dumb question as I know it's fairly easy but I cant seem tofind an example after two hours of searching.In a stored procedure I'm trying to build up a string eg,(the following is in a loop)IF @xcount 0BEGINSet @list = @list + @title + ': ' + @xcountENDProblem is when I come to return @list, it's always NULL - when I knowthere should be data returned. Any ideas?ThanksLee

View 1 Replies View Related

Stupid Question On Graph Width.

Jan 2, 2007

when I create graph (Pia)

the graph take 80%, and the labels take 15%,

example here:
http://img2.tapuz.co.il/forums/1_91779074.jpg

is it possible to grow the place of the labels?

I try look on the properties and I didn't find.

thanks!

View 5 Replies View Related

Stupid Text Box/notation Question

Mar 11, 2008



I'm in Visual Studios working on a data flow. I want to add some notes. I open a text box (by typing on the screen).

Why can I only get ONE line of text???? The return key doesn't work.

View 5 Replies View Related

SQL Backend Access Adp Frontend - Stupid QUERY!!!!

Sep 26, 2005

Ok, little frustrated hence the excessive exclamation points.

I'm designing a database in access to use a sql backend. Table structures are setup and am creating a view to join multiple tables together for data entry purposes. Tables are joined properly but when I add more than one join, ie adding more than two tables, I can't add records!?!

I checked the joins, it's not the table, since if I add one table its ok, remove table, add another table and that works, but when I add both tables together, it prevents me from adding records!

And another thing, when I have just two tables joined together and add a record, it comes up with this save changes, drop changes or cancel thingie!!! WTF!!!?

Is there something simple i'm missing or is it my table structure????

Thanks in advance!

View 14 Replies View Related

Ridiculously Stupid SELECT Statement Question

Jan 9, 2008

This is very embarrasing, but I can't find this anywhere (An online search turned up a ridiculous number of results, and thus far [as of page 6], I haven't found anything that answers my question.

I would like to write a SELECT statement, WHERE a given field does NOT equal "". I know that in C# it would be !=, but this doesn't appear to work. I tried a couple of other things, but did not have any luck.

This is a very silly question, but could someone please tell me what I use in a SELECT statement to signify "Does NOT Equal"?

Thank you very much. I really appreciate everyones help.

View 5 Replies View Related







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