2,736 Topics
|
|
Hi guys, Let me describe the situation I am in. I have a table of 2000 objects and each object has a range of different prices associated with it, stored in another table. I have created a view which serves to list the objects as well as their average price. … |
|
Hi, Is there any way of finding the modal (most frequent) occurrence of a value. I know that mode doesn't exist in the same way that count, avg and max do but is there any way to combine count and max in such a way to find the most frequent … |
|
From last two days i am searching for the answer of this querry. I want to know how can i access the rows of tables in stored procedures using loops(Without cursor). We don't want to use cursor for that because of the performance issues. |
|
Hi..... i create a new user in mssql... user is --- kumar now i login to mssql by using the above user... now i login to mssql with another console by using administrator account..... now i try to delete the account(@ present in administrator account) -- kumar .... then the … |
|
Hi guys, I have this situation.. The Min funcition in SQL returns lowest value in query but I what to return is the 2nd lowest instead. Take this table for example col=Pay(3000,2300,1000,1900,1200) Min(pay)=$1000 but I want to return Min2ndlowest(pay)=1200 Is there a way to solve this problem. Thanks for help … |
|
Hi, I am using MSSQL (Microsoft SQL)to liase with python via third party driver. Well here goes... I have created two instances of SQL registration in my Enterprise manager. It is under i)Console Root->Microsoft SQL Servers->SQL Server Group->(LOCAL)(Windows NT) and ii)Console Root->Microsoft SQL Servers->SQL Server Group-> INTEL\FR6EnterpriseDB (Windows NT) Btw … |
|
First of all Hello to this forum. I have the follwoing problem. When I am runnig an UpdateCommand with codebehind : sqldatasource1.Update() I get the following error. (I want this command to CompareAllValues) [COLOR=#000000][B][I]You have specified that your update command compares all values on SqlDataSource 'SqlDataSource1', but the dictionary passed … |
|
Hello, I recently deleted some columns from a table with the statement DROP and I saw that database size doesn't change, it remains exactly the same(very big by the way). So I suposse DROP only take away the logical references but the COLUMN is still physically there. The question is: … |
|
Hi i having a few problems what i need to do is find duplicate rows in a mssql database i can do from one table but i need it to run across 2 tables this is the code i useing to do one table SELECT COUNT(*), sID1, sID2, sID3 FROM … |
|
Hi can anyone help me on how to get the names of the tables from a DB - MSSQL 2k server? i need to list them or add them into a combobox, but i also need to select them by owner, or by type. user defned or system. thx in … |
|
Already typed my post once, having to do it again.... With the following code in MS SQL 2K: SELECT Users.*, Trainers.FirstName AS TFirstName, Trainers.Surname AS TSurname, Trainers.DisplayAs AS TDisplayAs, Trainers.DIRealname AS TDIRealname, Trainers.UserID AS TUserID, Trainers.TrainerExpiry AS TTrainerExpiry FROM Users LEFT OUTER JOIN Users AS Trainers ON Users.UserTrainerID = Trainers.UserID … |
|
product transaction date -------------------------------------- 1 06/07/2006 2 06/05/2006 2 06/10/2006 3 06/09/2006 I have a table like above, now I want to retrieve the latest transaction date for each product, so the result should be: product transaction date -------------------------------------- 1 06/07/2006 2 06/10/2006 3 06/09/2006 I try to use statement: … |
|
I am attempting to apply an SSL certificate on a per client basis in SQL 2000 (Windows 2000). I have read a number of MS Knowledgebase articles on the subject, and followed their directions, none of which seem to be working. After installing the certificate, the directions say to export … |
|
We are getting frequent error in display while processing through web, we are having higher end hardware , ML350G SERVER,with 4GM Ram, duel processer capable, 145x3 hard disk, We are having 30 GB Space in C: Drive and 240GB in D:Drive, we have sql database upto 17 GB, the process … |
|
Hi all, Please help me in solving following query. Can we define in sql server the same parameter as input and output? How to do it? Thanks and regards, Swapnil. |
|
I currently have a form that i have created using html, (can create in another language if makes it easier) however, i can't seem to find how to send the information from that form to my database. I have searched over the internet and asked some people that I know, … |
|
Hi !!! I m Jai and pursuing engineering in IT. We have to do a mini project in DBMS. I have decided to do a project for mainting Insurance policies. Pls help me out for its case study. Also suggest me any other new topic if possible. Thank you. |
|
Hello, I backup my databases like this: [I][B]dump database MYDATABASE to disk='c:\temp\MYDATABASE.bak' with init[/B][/I] [B][/B] This saves the structure and data to the bak-file. Now, for some DB's I want to save the structure only, can someone tell me how to do this? THX pakko |
|
Hello, i'm currently working on an online game (browser based), and obviously, since all of the contents is meta-data, I have loads of DB-related work. Recently I came into a brick wall while trying to figure out how to make one of the more important features of my game to … |
|
hello frinnds, i am new to this forum.........afte seeing this i feel it is gonna helpme..... right now my problem is-> i am usin msql, here i am using a table in a database..inside this table i have field called [B]ID, i[/B] want autoincrement feature for this field......... i don … |
|
I own a small web site / hosting company and I had a hard drive failure and my back-ups didn't work perfectly. I have a complete back-up of my C drive from May 2006, but I can't figure out how to restore my MS SQL. Can anyone help? thanks, Marc |
|
I'm not sure if this is a Server 2003 issue or an MSSQL issue, so pardon the cross-post. I have created a local user called "sql-daemon" to run MSSQL 2005. At the onset, everything works fine: I can reboot the server and all SQL processes start as expected. Then, one … |
|
Hi, I am not sure if my question sounds silly. I have a [B][I]table[/I][/B] that has a few columns like [B]date[/B],[B]source[/B],[B]race[/B] and [B]state[/B]. I need to generate a report. The table stores the details of callers including name,age,sex. But the report need to display in this format counting the number … |
|
I'm trying to display only rows where the identity column is divisible by 5. Could someone help with this? |
|
Hi - this may seem like quite a simple query but i'm new to the SQL world... I have a column in my database (DB_Users) called Email - how would i go about extracting all of the email addresses in the column? I am using SQL Server 2005 and i … |
|
Hi, I want to edit the sql server regestration. I want to change the Connection property from Windows authentication to Sql server authentication. But when I edit the sql server authentication with sa username and password, it gives error message saying that the [B]registration has failed for user sa, not … |
|
Hi All, I am writing this just to even know if this is possible. What I would like to do is a UnGroup. Crap this is so hard to explain...okay I have a table in sql that is five columns long. The first Column is, ohh never mind. Copy and … |
|
How do I find, alter, create, edit, etc. the stored procedures, triggers, and foreign keys on an MS SQL 2000 database? I'm trying to figure out how a given database maintains its referential integrity but I can't get behind the scenes on those things. I'm using SQL Server Enterprise Manager … |
|
Hi,I'm new to daniweb forum. I hope someone could help. I have a table called [I][B]Caller[/B][/I] which has a field called [I][B]Area[/B][/I]. I need to select the value of the record in this field that [B]repeats the most[/B]. For example [B]Area[/B] Sel KL Sel Sel Pen KL which means i … |
The End.