3,481 Topics
 | |
| | Hi guys, I'm brand new to SQL and was looking for any help I can get my hands on! What resources does everyone find useful?? Books, magazines, links, forums, etc.??? My friend shared this one with me so I thought I'd pass it along, I've found it pretty informative and … |
| | [COLOR=#000000]I have two record sets. One is transactions and another is GL posting. I am aiming to create a third table to find out the customers are from which country inflate our GL.[/COLOR] [COLOR=#000000]For example GL Table has following fields[/COLOR] [COLOR=#000000]GLCode[/COLOR] [COLOR=#000000]GLDescription[/COLOR] [COLOR=#000000]GLAccount[/COLOR] [COLOR=#000000]GLAccountCCY[/COLOR] [COLOR=#000000]Balance[/COLOR] [COLOR=#000000]BalanceUSD[/COLOR] [COLOR=#000000]Transaction Table has the … |
| | Hi, I am writing a query that requires as input the difference in days from two dates (Project_End - Project_Start, both of data type DATETIME), how can I find it? Can I subtract the two dates? Thanks, Robert |
| | Hi! I want to share news... Found an interesting SQL editor supporting intellesense. Site vendor [URL="http://www.yukondev.com"]www.yukondev.com[/URL] there is no editing tables, but otherwise that is what I was lacking. [COLOR=black]Regards, Mike [/COLOR] |
| | Hi, I'm a bit stuck. I've been breaking my head quite long figuring how to do this. I need to generate areport that is grouped by week. i need to display total number of patients who are enrolled in the system. And they are grouped by the weeks in a … |
| | Hi all, I am writing a web interface which uses a MSSQL Server 2000 database. I have checked and double checked all permissions and can't find any problems but when I run a [code]select * from sales[/code] I get the 'Permission denied for `sales` database `dbasename` database owner `sqluser` I …  |
| | Hi, I have a small database with 15 tables and 20-40 records in each table. I just want to ask how can I print all the tables together with their names, atribute names and all the records? (the Print option from the File menu is not active) Thanks, Robert |
| | I posted this in someone elses thread, but I'm afraid it'd go unanswered so I made my own. I used to be able to load pages in less than a second, now sometimes the page doesn't load at all. Regarding browsers opening up by itself... I use Mozilla Firefox for … |
| | Hi, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a form/interface for the database in Visual Basic .NET. I managed to connect the tables by using the BindingSource / DataGridView controls. However I cannot find the queries in … |
| | Hi. I have just installed 2005 in my on my database server. Now, I have a web server and will need to access my database from my web server for simple stuff such as querying the database and checking tables, etc, etc. What should I be installing on the Web … |
| | I have a view that looks at new student records and a table that stores those records and information related to their Active Directory logins. What I need to do is filter out any duplicate records between the two "tables". So I only see unique records in the view to …  |
 | My company is using a third party software designed by other private company. there is a point where there is data redundacny on our tables and it requires me to do the data cleaning. i thought it would be better to fix the incorrect field with the procedure with those … |
| | I am so impressed looking around at the vast knowlegde you guys have. I have chosen you as I am certain you know more than alot of the other forum users. Machine - Vaio VGN FE31Z [URL="http://www.daniweb.com/techtalkforums/post341405.html#"]Intel[/URL] core duo, 2gb ddr,200gb hd,1.83 Intel speedstep, Proc t5600 Soft - Itunes, MSN … |
| | Hi, i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it? Thanks this doesn't work but something like this; insert into exam (e_score, l_name, s_id) values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id) |
| | Hi, I am writing a small search engine. There are two tables. The first one holds the search engine main index, the second one is link table. I have the following query that retrieves results. I would like to sort the results by: dbo.OCCURS2(LOWER(:query),se_links.anchor). se_links.anchor obviously comes from se_links table, … |
| | HI, [COLOR=#000000]I am trying to return automatic value into another column with using trigger in a table, when I enter new record into that table. It works if it is first data to be in that table. If I have more than one record already, it doesn’t work. I thing … |
| | hi! I need a program in vb that does this as soon as possible, I'd be very grateful if anyone could tell me how to do it: the customer gives a table containing the old values and new values in an excel sheet which will be connected to an access … |
| | I have the following select query: [CODE]SELECT DISTINCT Job.JobID, Job.DateAdded FROM Job, ImageTag, Image, Tag, TagCat WHERE TagCat.TagCatID = Tag.TagCatID AND Tag.TagID = ImageTag.TagID AND ImageTag.JobID = Image.ImageID AND Image.JobID = Job.JobID AND ImageTag.TagID IN (#TagIDList#) ORDER BY Job.DateAdded DESC [/CODE] However, I need to add to the query the … |
| | I have created the following stored procedure in sql server 2005.I m using asp.net with C# 2005. Can someone please rectify my errors why i m getting such type of the errors... [code] ALTER PROCEDURE CompanyStoredProcedure @uspcompanyid INT NULL, @uspcompanyname VARCHAR(20), @uspaddress1 VARCHAR(30), @frmErrorMessage AS VARCHAR(256) OUTPUT, @RETURNVALUE AS INT … |
| | Hi, i'm new to all this. I'm really stuck!! I'm running XP Prof and have recently installed SQL Server 2000 Personal edition. It seems to have loaded in ok,,BUT,,it won't connect to my localhost,,i don't know what the problem is i get the 1069 error message. Pleaaaaasssee can someone help … |
 | I want to install SQL Server agent using [B]Setup Factory 7[/B]. Can anyone please help me on how exactly I can do this? (I am installing a VB6 program that must access data from SQL Server 2000, so I want the setup to: 1. Install the SQL Server part. 2. … |
| | hai guys, I am a newb in SQL server. yesterday i have installed microsoft sql server 2000 to my computer. But i don't know how to employ this. I have a group of ASP pages that contains my MBA assignment notes and files, and is successfully working with IIS in … |
| | My dears, I have installed SQL server 2000 on my computer. And have made database through the below command: Create database mydb go exit But nothing happens. I don't know how to manage this database. Can anybody clarify how can i store my ASP pages in this database. How can … |
| | Could you please help me with this. thanks. Logfile of HijackThis v1.99.1 Scan saved at 10:27:21, on 29/03/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe C:\WINDOWS\system32\lsass.exe C:\WINDOWS\system32\svchost.exe C:\WINDOWS\System32\svchost.exe C:\Program Files\Intel\Wireless\Bin\EvtEng.exe C:\Program Files\Intel\Wireless\Bin\S24EvMon.exe C:\WINDOWS\system32\spoolsv.exe C:\WINDOWS\Explorer.EXE C:\Program Files\Adobe\Photoshop Elements 4.0\PhotoshopElementsFileAgent.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgamsvr.exe C:\PROGRA~1\Grisoft\AVGFRE~1\avgupsvc.exe … |
| | I have three tables that are linked as follows: SOShipheader.shipperid, SOShipheader.invctot SOShipline.shipperid, SOShipline.invtid, SOSHipline.qty, SOShipline.price SOShipmisc.shipperid, SOShipmisc.miscid, SOShipmisc.charge Here is what I want the report to look like: S80709 150.00 abcpart 3 40.00 defpart 1 10.00 misca 20.00 S80710 30.00 defpart 1 20.00 miscb 10.00 I have group1 as soshipheader.shipperid … |
| | I feel kind of dumb, sorry about the mix up. Anyhow, I got the abominal 'CLICK ME' link in an IM and if you can't guess already I definitely clicked and then things got messy. It was something through MSN if that is needed and I've come to find my … |
| | hi everyone im wondering how will i connect a VC++ program with an SQL server. i would like the program to have direct access with the tables/data. if you can provide a sample source code would help. thanks.  |
| | I'm using asp and use the Connect style to my database, it works perfectly on my virtual localhost PC, but when i need to use the server i have my web page it doesnt work, then i says i need to create a database as well using their MsSql "MyLittleAdmin" … |
| | Hai guys, i want to know how to create a database in sql server for creating a database in sql what should be download in my system. and how to download it .my system has windows xp proffessional. please tell me how or give some website name to know detail …  |
| | :cheesy: OK, I am new to this so go slow please. I cannot open my Control Panel, My Computer, etc. I have tried to delete some viruses with HiJack This unsuccessfully. My HiJack This log is as follows: Logfile of Trend Micro HijackThis v2.0.0 (BETA) Scan saved at 3:03:40 PM, …  |
| | Forgive my ignorance, I am new to RDMS and SQL both. My question is this: I have 2 tables, one a primary table and 1 a relational table table 1 has ten rows valued 1,2,3,4,5,6,7,8,9,10 table 2 has 4 rows keying from table 1 row1 = 1 2 row2 = … |
| | Hi All. I am now doing this tutorial step by step ; [URL]http://www.azroc.co.uk/csharp/asp_net/asp_net_data_access_layer2.htm[/URL] ----------------------------------------------------------------------------- It shows on how to create a dataset and retrieve it.Then it will be show in the browser.But then, when try to run, it says got error at my aspx.cs file. Well,I run the codes by … |
| | Hello I am in the process of cleaning up my computer, can anyone advise me if i can delete any entries in my HJT Log attached. Thanks Logfile of HijackThis v1.99.1 Scan saved at 10:37:28, on 17/03/2007 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16414) Running processes: … |
| | [COLOR=#000000]Hi, I have 2 tables a parent and a child. I want to insert value from C# (Windows Form) to DB(MSSQL) in VS2005. Although I’m sending data to both of them but the new record will be generated only in parent table but not child. At the first I thought … |
| | Hello Everyone, I have a DTS package, which has been working fine for few years. it runs once a month to get information from different databases and save it into the destination database. Now I get this error: error source: microsoft ole db provider for sql server error description: could … |
| | I'm having a problem querying data from two different databases on a SQL 2000 server. We have two databases, a main data db, and a separate security db that has login info. Database logins for the data db DO NOT have access to the security db. I have a function … |
 | Hi All sorry if this is in the wrong forum but it was the only way I could find to post this thread. I have just picked up a machine from a friend of mine who uses it to manage her business. I have logmein installed on it so that … |
| | Hello everyone, I have a MSSQL db with PHP front end. The data in the table is similiar to: "Two spaces" with 2 white spaces in the middle. When I use this code: [code] $sql = "select Name FROM Name_TBL WHERE Number = '$Num"; $rs = mssql_query($sql); $RT = mssql_fetch_array($rs); … |
| | Query to find the 10th maximum salary from an employees table which contains empno,empname,empsal as columns.If this table contains n number of records,how to determine the 10th maximum salary |
| | Hello everyone, This was posted in the PHP section also... I have a MSSQL [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]db[/URL] with PHP front end. The [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]data[/URL] in the table is similiar to: "Two spaces" with 2 white spaces in the middle. When I use this [URL="http://www.daniweb.com/techtalkforums/thread70770.html#"]code[/URL]: [code] $sql = "select Name FROM Name_TBL WHERE Number … |
| | OK, I'll admit straight away i'm new to SQL. I've got a SQL 7 Server with two small databases running. I have been able to backup both to file. However when I try and "restore" them on a test SQL 2005 Server, it errors because the file & folder structure … |
| | [COLOR=midnightblue] Hello All, Apologies if this is the wrong forum section. Some help and advice please regarding a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]SQL[/URL] Report. It is for a Feedback form and below is a quick mock up of the DB diagram [IMG]http://img219.imageshack.us/img219/4102/feedbackbr8.jpg[/IMG] tblFeedback is populated with a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]Customers[/URL] details and the tblResults with the … |
| | Hi: I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls … |
| | Hello, I was looking around for some tutorials about how to backup my database in my hard disk using [B]SQL Server 2000 Enterprise Manager[/B]. Can someone explain me in a friendly and step-by-step method? (screenshots preferred) Thanx so much in advance |
| | Hi Friends, I have one strange problem the if conditions are not working, it is not supporting at all. Any idea why ? iam using ODBC_CONNECT() with MSSQL and PHP. Regards |
| | Hello... :eek: Sorry, I'm new here and new to SQL (please dont kill me for asking) What I'm trying to do is write a script to backup a few databases in SQL. I know that I can just right click on the db and back it up, but how is … |
| | how i can convert different packages in mssql 2000 to 2005. |
| | I've been fighting through a fairly nasty infection and I'm left with one resistant creature that resists the best efforts of the normally available tools. Probably most noteworthy is that a Google search on the culprit returns absolutely no results at all... when have you ever heard of that happening? … |
| | I am running a website of crossword puzzle and Sudoku games. The website is designed to be: [LIST=1] [*]There are 20-30 games onlines each day. [*]Every registered user could play and submit the game to win scores. [*]For each game, every registered user could get the score for ONLY one … |
| | Hello. Random hyperlinks have been appearing in some of my Excel spreadsheets. I've run virus scans, spyware scans (including AVG AntiSpyware) and they've come out clean. I've also cleaned my registry with Eusing Free Registry Cleaner. Here is my Hijack this log. Please let me know if you see any … |
The End.