Novice Question. This Should Take About 5 Seconds For A DB Professional.
Jun 4, 2007
I'm sure this problem borders on retarded for most readers of this form, but here it is:
I have table with contest and another table with user ratings on those contests.
Contests: ContestID, CreatorUserID, Title
Ratings: ContestID, UserID, Rating
If I
SELECT Contests.*, Ratings.*
FROM Contests INNER JOIN Ratings ON Contests.ContestID = Ratings.ContestID
WHERE (Ratings.UserID = '1')
This only returns the contests that User 1 has rated. But I need all contests. If the user hasn't rated one, I want the result set to show Rating = NULL. The problem is that if a user hasn't rated a contest, that ContestID does not exist in the Ratings table.
Can someone please show me how to solve this?
Thanks!
Gavin
View 2 Replies
ADVERTISEMENT
Jul 23, 2005
Hi all.If I've got a query which has a field with seconds in it... how will I usethe Convert function to get my field converted to the format: HH:MM:SS ?The field with the seconds in is called: "Diff"Thanks alotRudi
View 2 Replies
View Related
Sep 21, 2007
I have a Stored Procedure that has a query in it and it take 0 second and then a stored procedure that takes 16 seconds. From what I can tell they shoul be the same.
It doesn't recompile when i run the stored procedure, I checked that.
View 8 Replies
View Related
Sep 4, 2005
Hey all - been knocking my head on this on for awhile - perhaps someone could shed a little light.
I have 2 tables that I want to link:
Table 1:
UserID - Primary key
First Name
Last name
AuditionID - FK
Table 2:
AuditionID - PK
Description
Sing
instrument
So - I have a web form that collects the information for both tables and then insets the collected data. But, the AuditionID value in Table1 does not update. Now, I assume I am incorrect in thinking the AuditionID in Table1 will be automagically updated when Table2 creates it's key...?
If that is indeed the case, how do you update 2 tables and maintain a foreign key relationship?
I hope I am being clear enough - any help would be greatly appreciated.
Thanks all
View 2 Replies
View Related
Oct 2, 2007
Hello,
I'm running a (phpBB) forum which uses a MYSQL data base - I can access the database via a webpage through my ISP and it lets me run short scripts (through a web interface). I need to do the following (shown in psuedo code below). I would be eternally grateful if someone could translate it into pure SQL commands for me to paste into my SQL quiery input field on the web page I'm using to access my database. (I'm a complete SQL novice)
=====================
/* I need to be sure these commands will do nothing if 'jeff' does not exist in the user table */
/* extract the id value for the user called 'jeff' from the users table */
user = GET id FROM users WHERE username = "jeff"
/* remove all entries from the forums_watch and topics_watch tables that contain Jeff's userID */
REMOVE ALL ENTRIES WHERE userID = user
notify = 0;
/* insert many entries into the topics_watch table, one for each topic that exists in the topic table */
arrayOfTopicIDs = GET ALL id FROM topics
FOR EACH current_Topic IN arrayOfTopicIDs {
INSERT INTO topics_watch
(topic_id, user_id, notify_status)
values (current_Topic, user, notify)
}
/* insert many entries for jeff into the forums_watch table, one entry for each forum that exists in the forum table */
arrayOfForumIDs = GET ALL id FROM forums
FOR each current_Forum in arrayOfTopicIDs {
INSERT INTO forums_watch
(topic_id, user_id, notify_status)
values (current_Forum, user, notify)
}
=====================
I'm going to implement this with php and MYSQL as a mod for my forum application (phpBB) - but I could really do with a way of doing this immediately with pure SQL commands as a quick and dirty one shot paste into the input field of the MYSQL database web interface until I get the php mod going.
Can this be done using only SQL commands without tedious repetition?
Best Regards,
Alan
View 2 Replies
View Related
Oct 20, 2006
How do you work with an xml file that resides in a database column using IS XML related features? From what i understand so far, the path cannot point to a column within a database but only to a source outside of the database. Am I correct?
View 1 Replies
View Related
Aug 10, 2007
Hello,
I am asking a question i have seen many threads on, but I am looking for an idiot's guide on how to convert my SQL 2005 database to SQL 2000 so i can get it to run on my web hosting server. I'm very new to asp.net , but have ahd years of experience in normal HTML and a year or two in the old ASP.
I was advised to learn ASP.Net 2.0 and have found it nothing but brilliant. The intergration with SQL 2005 made it a lot quicker to link up a database than using Access. Unfortunatly my hosting company is a little behind and still using SQL 2000. There isn't mch databse intergration (a few aplication forms) so I dont mind re-writing the whole database but I dont know how to set Visual web developer up with a SQL 2000 Database. I have also read from various other forums that you can convert a databse to 2000 by doing something with the scripts, but the explaination is too complicated for me to follow.
Is there anyone out there who wouldn't mind going over some old ground and explain this all in simple terms? Im using 'SQL Server Managment Studio Express' (although i dont know how to use it) and 'Microsoft visual web developer 2005 express edition' .
Thanks for reading this
Simon
View 6 Replies
View Related
Aug 10, 2001
seems like it should be a simple ALTER TABLE query but im getting a 'Incorrect syntax near the keyword 'column'.' error. Trying to add a boolean column, heres the script, any help would apprectiated.
ALTER TABLE SHIPPING_ADDRESS
ADD COLUMN isUpdated bit,
thanks.
matt
View 1 Replies
View Related
Jul 20, 2005
What is the common mechanism (if any) to make the server notify aclient when some condition is met (say, upon completion of asql-transaction)? The only way to implement this feature I am aware ofnow is to set up a timer and query the server every once in a whilebut surely this technique isn't much good.
View 2 Replies
View Related
Dec 18, 2006
Hello,
I'm creating a website for a student organization at my university. Basically, I have an Excel file with a list of contacts that the members of our organization need to be able to search on our website.
The only field that I need our members to be able to search is "contact location." So for example, a member might want to know if our organization has any contacts in Spain, so the member would type "spain" into the "contact location search" field" and would get results.
I really don't known where to turn... I need the easiest thing that would be manageable for a novice. It doesn't need to be an intense search function; just something to make the website functional (so it obviously needs to be uploadable to a server; the server has PHP capability...no idea if that has any relevance). I've been searching around all day and have come across potentials like PHP, SQL, XML, etc. but have no idea which way to turn... I have Office and Adobe Studio programs at my disposal.
Thank you all-powerful and all-knowing web gods! I owe you my deepest gratitude!
Mikey
:beer:
View 1 Replies
View Related
May 24, 2001
Hi all,
I think most of the visitors here are experts of SQL 7.0. But I am a absolutely new one. So I may ask some very foolish questions.
I plan to learn how to use MS SQL 7.0 recently, but I don't know how to begin, can anybody here give me some good experience or material(websites) on learning SQL 7.0?
Also, I want to install SQL 7.0 in my home PC. should I install it with Win 2000 professional or Server version?
Thank you.
Henry
View 2 Replies
View Related
Oct 11, 2002
Which Edition of SQL SERVER 7 and SQL SERVER 2000 can be run on Windows XP Professional? I'm talking about the server itself not the client tools.
Thank you for any help.
View 2 Replies
View Related
Mar 4, 2006
Hi All
I am trying to install sql server on my xp machine. When I run the install it says it can't validate the product key. I have all legit copies of the software. I did a search on the web and i found something about problems in NT, but nothing for XP. Any ideas?
thanks!
View 3 Replies
View Related
May 18, 2006
Hi All, I have read MANY posts on how to track changes to data overtimeIt appears there are two points of view1. Each record supports a Change Indicator flag toindicate the current record(would this be EVERY table?)2. Each table is duplicated as an archive table andtriggers are used to update archiveCan someone give me some guidance based on REAL world experiencewhich works best for them?My scenario - I have insurance policies and must track history aspolicies are updated by customer service reps.Imagine many tables Policy>LifePol>LifePolRiders[color=blue]>AccidentPol >etc...>DIPol>DIPolRiders[/color]To me the archive table scenario does not seem scalable at all....someguidance on design would be aprreciated...Thanks!!!
View 2 Replies
View Related
Jul 27, 2005
Dear all,I have XP pro as Operating system.I installed Webmatrix, downloaded SQL 2000 desktop (sql2ksp3), run the command prompt in the directory where dir MSDE of sql2ksp3 was as so: setup.exe SAPWD=hello INSTANCENAME=RMSI lat the installation ran and I got msg that installation ran successfully. So far, so good. From WebMatrix, I tried to add a database connection within a project. When I select SQL-database and click on OK, I get the error message that SQL server administration requires SQL client installed on my machine. In Control Panel - AddRemove Programs, I see indeed that there is no MSSQLserver or client mentionned.I check also the services. The only one I have is SQLADHelper that starts manually. I must have to do with XP security, right... Can someone please please help me. I am a newbie and only want to learn ASP and VB programming via Matrix and Visual Studio IDE.Thanks in advance!Christiane
View 1 Replies
View Related
Jul 3, 2001
Hi,
I am looking at installing SQL Server 7 on my PC which runs Windows 2000 Professional. Can anyone give me some advice before I do the installation of SQL Server 7. Any tips or any problems I might encounter.
Regards
Guy
View 1 Replies
View Related
Jun 28, 2000
Currently, I have the client side of SQL Server 6.5 (Enteprise Manager, Security Manager, Books Online, etc.) installed and running under Windows NT 4.0 Workstation. When I attempt to install the same package under Windows 2000 Professional I get the following message - This program does not run correctly on this version of windows. To continue, click Run Program. Has anyone sucessfully installed this under Windows 2000 Professional? Are there any patches or service packs to apply? Thanks.
View 1 Replies
View Related
Oct 4, 2004
Hi there,
We are currently developing a E-Com research site where subscribed members can conduct market research. The web site is developed and ready to go, however we are undecided what is required on the Database side and could do with some of your expert help.
Users will be conducting research on our MS SQL database. The database holds every product sale made by a select number of consumer good companies. The database holds 12 million records at any one time, however overall the database is very static and is not updated online. We intend to only store 1 months data, therefore on a weekly basis we delete old & add new records.
We are offering three categories of searches on the DB.
1. By Seller
2. By Category (i.e. Hair Care, Laundry etc)
3. By Sale.
The first two searches are not performance intensive as they are compiled and stored in the database - therefore no need for calculation online. Our main concern is the 3rd report. This report is where we allow the user to search for a specified search string. Therefore in the main table that holds all the sales, we have a full-text index for the field "Product Description".
What we are unclear on is the Capacity requirements regarding providing such functionality. I.e What server do we require?
We have researched many articles and have absorbed all the information regarding multiple disk controllers, lots of memory etc.. etc.. However we still have not been able to obtain an idea on what Server would serve our purposes. For example: would the following server do the job?
2 x 2.4Ghz Hyper-threading Xeon CPUs with 512Kb Cache and 400MHz System Bus
2GB Samsung RAMBUS 800-45 Memory (RIMMS / RDRAM)
A lot is determined by the usage, i.e. how many queries are executed per minute etc. At present we do not have a clear idea on the number of users. However we are not truely concerned about this as the 3rd report needs to execute and return within a short period of time. That is our main concern.
Therefore our question is as follows: If you were going to host a database that consisted of 12 million records & full-text indexing which had to be queried in a few seconds, what would you purchase?
We ask you to consider that funds are extremely tight and although the new latest server may do the job, it is most likely out of our budget. We are looking for the most cost effective solution but still statisfying the purpose.
Kind regards
Angus
View 1 Replies
View Related
Sep 24, 2007
Occasionally, when I try to edit a package I get an error. Visual studio is busy found VS hanged.
It is specific to my machine or a common problem.
View 4 Replies
View Related
Jul 20, 2005
I have a copy of MS Visual Studio 2002 Professional ACADEMIC which Iunderstand is the same as the regular Professional version with theaddition of a student CDROM. The installation program on the firstCDROM only copies the MSDE to the harddrive and the copied setup filehas to then be manually executed to complete the installation.Are the SQL tools such the SQL Enterprise Manager and MS Queryincluded in the professional version? If so, how can I install thesetools? The course that I am taking uses these tools to study SQL. Ifnot, how is the MSDE to be used?
View 4 Replies
View Related
Jun 19, 2006
Just curious if anyone out there has had success running a Distributed Transaction on Windows 2000 Professional SP4 lately?
I have come to the conclusion that is is virutally impossible. I am running MSDE on a Win2k Pro machine and trying to run a distributed transaction via linked server and am getting the
"The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction."
error. Yes I have been scouring the web looking for answers and have implemented pretty much everything I have run accross... and Yes the MSDTC service is started on both machines... BTW: If I run the procedure on XP it works great!!!
I am wondering if anyone even uses Win2k Pro anymore let alone trying to run a distributed tarnsaction on the darn thing.
If anyone out there has it running let me know I would love to chat with you for a minute or two.
View 3 Replies
View Related
Dec 6, 2006
Hello all,
This is my first time posting, so be gentle as I'm not exactly sure what the protocol here is regarding posting errors.
I'm encountering an issue with an installation of SQL 2005 Express (SQLEXPR_ADV.EXE) on a Windows 2000 Professional SP4 machine (Intel P4 1.8 Ghz). The following error is what I receive:
Setup.exe - Entry point not found:
The procedure entry point _create_local could not be located in the dynamic link library mscvr80.dll
< OK >
The following is what I see in the error log (C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles):
SQLSetup0007_SQL2005TEST_Core.log
Microsoft SQL Server 2005 Setup beginning at Wed Dec 06 11:28:08 2006
Process ID : 452
c:98b179fcf692887ac3setup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/11/6 11:28:7
Complete: LoadResourcesAction at: 2006/11/6 11:28:7, returned true
Running: ParseBootstrapOptionsAction at: 2006/11/6 11:28:7
Loaded DLL:c:98b179fcf692887ac3xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/11/6 11:28:8, returned true
Running: ValidateWinNTAction at: 2006/11/6 11:28:8
Complete: ValidateWinNTAction at: 2006/11/6 11:28:8, returned true
Running: ValidateMinOSAction at: 2006/11/6 11:28:8
Complete: ValidateMinOSAction at: 2006/11/6 11:28:8, returned true
Running: PerformSCCAction at: 2006/11/6 11:28:8
Complete: PerformSCCAction at: 2006/11/6 11:28:8, returned true
Running: ActivateLoggingAction at: 2006/11/6 11:28:8
Complete: ActivateLoggingAction at: 2006/11/6 11:28:8, returned true
Running: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8
Complete: DetectPatchedBootstrapAction at: 2006/11/6 11:28:8, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__452" returned false.
Running: PerformSCCAction2 at: 2006/11/6 11:28:8
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2006/11/6 11:28:8, returned true
Running: PerformDotNetCheck at: 2006/11/6 11:28:8
Complete: PerformDotNetCheck at: 2006/11/6 11:28:8, returned true
Running: ComponentUpdateAction at: 2006/11/6 11:28:8
Complete: ComponentUpdateAction at: 2006/11/6 11:45:55, returned true
Running: DetectLocalBootstrapAction at: 2006/11/6 11:45:55
Complete: DetectLocalBootstrapAction at: 2006/11/6 11:45:55, returned true
Running: LaunchLocalBootstrapAction at: 2006/11/6 11:45:55
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 128
Aborting queue processing as nested installer has completed
Message pump returning: 128
Notice the time jump; I did this to make sure I was looking at the right log file.
Any help is greatly appreciated as I'll be monitoring this thread closely. Searches of my error show that other people have received it as well, although no resolution has ever been forthcoming. Thanks in advance.
View 3 Replies
View Related
Nov 17, 2006
We are looking for some professional, low-cost, and easily configurable CMS tools that work hand-in-hand with SQL Server Express. Any come to mind?
View 1 Replies
View Related
May 26, 2006
Hi Everyone,Can you please kindly tell me how to create a new user on the MS SQL 2005 Professional edition for accessing the existing database called VCalendar?thanks for your time and help!Jiimmy
View 13 Replies
View Related
Nov 29, 2002
I try to install MSDE as a new instance (SQL2) on my computer with Windows 2000 Professional, but a problem occurs and instalaltion does not complete successfully. I am an administrator of the computer. The application log contains the following errors descriptions:
"The SYSTEMCurrentControlSetServicesMSSQL$SQL2Perfo rmance key could not be opened or accessed in order to install counter strings.The Win32 status returned by the call is in the Record Data as DWORD 0. " and
"Installing the performance counter strings for MSSQL$SQL2 failed. The Error code is DWORD 0 of the Record Data. "
Have someone experienced a similar problem?
View 1 Replies
View Related
Nov 8, 2006
Hi Every one,
I have installed Visual studio 2005 professional edition.(with SQL Server 2005 expree Component). The Installation was done by Administrator.
I am able to work to access all database servers, Except SQL Server 2005. When I am trying to Add>>New Item>>SQL database in project, I am getting following error.
Login Failed for "XXXYYY"
Please some one help me to short it out.
thanks in Advance
View 1 Replies
View Related
Sep 18, 2007
Can you explain please why Extended SP does not work under Vista ?
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )
UAC turned off. MSQSL runs under Administrator account.
Any call of user esp - and SQL server goes to loop.
If I call system esp - all works fine.
If I try to read properties of ESP from Management Studio - I have the same effect - SQL server is in loop.
select object_id('dbo.xp_mylog')
-- works.
EXEC('sp_helpextendedproc ''xp_mylog''')
xp_mylog c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLogEsp.dll
exec master..xp_mylog
die forever
Konstantin
View 6 Replies
View Related
Apr 1, 2006
The computers here at work run Windows 2000 5.00.2195 SP4. Everything checks out with the minimum requirements at http://msdn.microsoft.com/vstudio/express/support/sqlreadme/#_3462_setup_issues_238p
However, one of the "Reports" from the installation says the machine does not meet the minimum requirements, but provides no details. It installs and I have Admin rights on this machine, but I can't even connect to the Northwind database that I downloaded.
Is this due to our logging process where the "system" is actually in another country? (ie, "CITYNAME/Username"
Any help is appreciated!
Jason
View 4 Replies
View Related
Jun 20, 2006
Hi
I am trying to install SQL Server 2005 Standard on my laptop, which has Windows XP Professional with Service Pack 2. I could not able to install properly and i am getting error always. i tried whatever the people mentioned in Google, but I could not able to fix the problem. please some one can help my problem.
Here is the Error I am getting always "The certificate chain was issued by an authority that is not trusted" . I am trying for past few days i could not able to resolve.
please help
Note : I have SQL Server 2000 Client installed in my laptop. this is my development machine
Thanks
Paddy
Here is the Error message from Summary.txt
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : W4102762
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_w4102762_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
Machine : W4102762
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_w4102762_SQLXML4_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
View 1 Replies
View Related
Sep 7, 2007
Hi, I am trying to open or create a sqlexpress database within Visual Studio 2005 Professional in the App_Data folder. If I attempt either method, I get the following dialog box:Required Components MissingConnections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkID=49251 The link above just takes you to the download page for Sql Server Express 2005. I have both SQL Server 2005 Developer and SQL Server 2005 Expression instances running. The existing database will work properly in my web application, however I cannot access it through Visual Studio.As background, I did have a problem connecting to the database via the web application, receiving a "Failed to generate a User Instance of SQL Server" error. But I was able to fix that by renaming my SQLEXPRESS folder in C:Documents and SettingsuserLocal SettingsApplication DataMicrosoftMicrosoft SQL Server Data. When the web page ran, it created another SQLEXPRESS folder.However, I cannot figure out why I am having the other issue.Thanks in advancePatrick
View 1 Replies
View Related
Jun 10, 2008
I am really confused and I can’t concentrate. Please help me with this easy question:
I have a field which contains seconds for example 128460 I need to have how much hours is that in my Query.
Please Help me.
Sep
View 6 Replies
View Related
Mar 6, 2007
I'm using a stored procedure that outputs a field of duration in seconds... I'm limited in that I cannot edit the stored procedure to alter the output but I need to convert this duration to hh:mm:ss. Is there a way to do this using the expression editor in RS 2000?
Many thanks.
View 3 Replies
View Related
Nov 2, 2007
Hi,
I have an user input variable called @stop_time which takes input in the format of HH:MM:SS.
I need to convert it into seconds only.
declare @start_time datetime
set @start_time ='02:15:00'
How can I do that?
Can anyone help please?
View 1 Replies
View Related
