3,481 Topics
 | |
| | [INDENT][INDENT]--URGENT--[/INDENT][/INDENT] Ive written a code in VBScript in ASP where back end is SQL. Here I want to display all the records with the data of the selected field of the table "Users" but it displays only the first record repetitively for the total number of records in the table … |
| | Below query for comparing 2 tables and extract the uncommon like GUID X121 doesn’t exists in the 2nd table and the GUID which are unsuccessful (has –ve values). select isnull(pt.GUID,Wo.GUIS)as GUID, pt.[ErrorNo] as Error from PieTreace pt full outer join WorkMessage Wm on pt.GUID = Wm.GUID where(pt.GUId is null) or … |
| | This is the copy of my hijack this log. I have worked on this system since 10am this morning and it is now 4:15...Help please Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 4:07:52 PM, on 10/1/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180) …  |
| | Say we have a table with 1000 rows and there is no column which can identify a row(i mean no Identity or unique column) now if we want to select a set of rows from this table how can we do that? Ex: i want to select from rows 201 … |
| | Hi all, Short history - C programmer whose day job is working on AS400's over VPN. Now getting into C# and chose VS 2008 using ASP 2.0 MSSQL for web development on IXWebhosting They don't have 3.5 yet, so I believe I have to use MS SQL 2005, but I … |
| | [code] hai friend's i have 1000 and more question's in database ,now i want to select the question's by the amount of 10 at a time ,when i click the next button the another 10 question's are want to show , now the selected questions from database should be in … |
| | Hi all, I hope someone can help me with this. I have been racking my poor stupid brain for days over this. I need a way to be able to create a view of the data in a single table. Let's call it tblStatus. Here is a list of fields … |
| | I have a huge database with around 250 tables. But all the tables are the same ie. they all have all the same columns. These are survery forms from different stores and thats why they all have the same schema. When i converted all these files from excel sheets into … |
| | how is maintence plan in sql server 2005?ebook for maintenceplan in sql2005? tanks |
| | Hi, My server machine is running on Windows XP and running MSSQL. I have another client machine which also installed on Windows 2000 and since i cannot install the whole MSSQL, I installed the Client Tools only. After installing,through my query analyser in client machine i can query the tables … |
| | I am joining a select statement and a subquery with a left outer join. The subquery does a an average on one of the selects columns grouped by name, and I only select this sum value in the resultant joined result set. Typically there will the select result set will … |
| | I have a very large with milions of rows: I will attempts to create a reduced SSCCE to explain my problem. The below applies for multiple locations, and I will attempt to describe my problem assuming one location. The metric are also foreign keys so to get the real value … |
| | Is this posible: I am working in SQL 2000, using MS Access 03 as the front end. I have a table 'Mileage' that has the following fields, ID, Vehicle_ID, Current_Mileage, Date Checked, Last_Current_Mileage and Mileage_3000. I am trying to find out if it is posible to create a trigger so … |
| | i want to connect mssql(microsoft sql server 2005), when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect server which is in another system connected through LAN. if i connect the sqlserver 2005, is …  |
| | i want to connect mssql(microsoft sql server 2005) using php, when i connect the following error displayed. why this error mssql_connect() [function.mssql-connect]: Unable to connect to server: note:in my system mssql 2005 is not installed..i connect another db which is in another system connected through LAN. if i connect the … |
| | Hi I want to execute below query in ms-sql server 2000 but its giving errors. Can anybody help please. [CODE]select * from ( select vRefTable from mainmenu where iMenuId=58 ) where (select vFieldsName from TableField where iMenuId=58 and bIsPrimary=1 and iTableFieldId=11) = 1[/CODE] Its showing below errors. your help is … |
| | Hi all, I need to sort users by matching preferences, and because of the high count of rows I need to do that in the data store, not in the business logic layer. Imagine I have a table like USER-PREFERENCE 1-A 1-B 1-C 2-A 2-C 3-B 3-C 3-D 4-C 4-E … |
| | Emp ----- ID Name 1 x 1 P 2 y 2 Q 3 W Emp_Data Id Name-1 Name-2 1 x P 2 y Q 3 w above is my tables (Emp ),And the I want the Resulting Data in the (Emp_Data) format.is this possible Pls Help........Thanks in advance----- |
| | Hi, I've got a major headache with a SQL Union statement. Basically I'm running a SQL Union statement in ASP that is not returning the first few unions. But if I run the SQL in enterprise manager it runs fine. I can't find anything on the web that even remotely … |
| | I have done everything in the prepost instuctions; please help In both Firefox 3 and IE7, I have updated XP to SP3 and IE to v8 Beta. I have installed and ran (AVG8, Ad-Aware 2008, CWShredder, SpyBot1.6, SuperAntispyware, Malwarebytes AM, CCleaner, SDfix, MS Malware tool, and maybe other). I have …  |
| | Hi, I have a table with columns like cats,dogs,birds and totalanimal. It is mainly a database which maintains how many cats,dogs and birds a person has... what i need is , get the sum of these columns(cats,dogs,birds) and keep the total in totalanimal column... how do i do this ??  |
 | Hello ,That should read hijack not hojack lol could someone advise on what to do with this and whats bad if any or program to remove the nasties ,all ready tried AVG antiviri/ spybot S&D/malwarebytes/ and ccleaner and combofix . Logfile of Trend Micro HijackThis v2.0.2 Scan saved at 6:02:17 … |
| | I have been having problems with my browser the last couple days. Everytime i do a google search and click on one of the results, it brings me to something completely different. Also certain webpages dont load at all. PLEASE HELP!! Here is a Hijackthis log of Trend Micro HijackThis … |
| | Hello All, I am needing to develop an SSIS package that reads a large text file into an SQL Server table, then formats 2 different output text files. I think that is the easy part as my client wishes to run this from a VB 2005 front-end by clicking on … |
| | how do i create join views in MS SQL and in mySQL. in mySQL it is almost impossible any one with an idea |
| | In one of my application I am getting (through OTL using ODBC drivers) the following information from the SQL Server 2005 for each table - Column Name - Datatype of each column - Primary key information and after getting this information I create a table with the same schema information … |
| | i want to add column in a table through following SP [code=sql]create procedure sp_addCol @tablename varchar (50) as DECLARE @tsql_TZ varchar (200) SET @tsql_TZ = 'ALTER TABLE [ '+@tablename+'] ADD timezone varchar (5)' EXEC(@tsql_TZ)[/code] whenever i try to execute this through EXEC sp_addcol 'MGV10SEP_MNPC_MNLD' ' it shows me the error … |
| | Hi everyone can someone pls help me with my data. I have an sql table(Test) in this form Student_No Grade_code Test_N0 Mark 20427103 DS302 1 60 20427103 DS302 2 65 20427103 DS302 3 60 20427103 DS302 4 70 20427103 DS302 15 69 and my stored procedure Select * from Test … |
 | I'm working with MS SQL Server 2005. I am trying to add two columns together, and I have more or less succeeded. However, it obviously adds the entirety of each column, rather than calculating for each row. I can't just include each column in the original SELECT statement, because it … |
| | Can anyone please help me.........I am at a loss. I am trying to install sql 2005 server on a windows 2003 server and am getting an installation error. The error states that there was an unexpected failure during setup wizard, and to review setup log. [B]In the log there is …  |
| | Please help.. I've tried everything i could find from other posts. My computer folder on the start menu and my docoments folder will not open in normal mode. Hour glass icon comes up briefly then disappears. Also, i am getting the following dll errors on start-up egcomservice_1048.dll, stlb2.dll, doceoc15b1, e6f1873b.dll. … |
| | I have recently issued nearly 2000 ID mifare cards to all the new students who recently started at the college at which I work. Accidentally, the software that printed the cards reversed the LSB of the UID of each card which means I have a useless database of codes. I … |
| | Hey there! I was hoping some of you can help me with this problem i have. I was recently infected by a virus that showed up as a process named CKVO.exe. I was able to remove it through the online scanner of BitDefender but some problems still remained. All my … |
| | I have setup the following table:- [code] IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'TlHold') DROP TABLE THold GO CREATE TABLE THold ( pid int NOT NULL IDENTITY(1,1), TS NUMERIC(2,2) NOT NULL, TR NUMERIC(2,2) NOT NULL, TB NUMERIC(2,2) NOT NULL, TP NUMERIC(2,2) NOT NULL, TP2 NUMERIC(2,2) NOT NULL, filler1 … |
| | Hi, I'm new here, and still a noob in sql. This is my query [code=sql] SELECT Payments.ClientID, Payments.CreditorID, Clients.FirstName, Clients.LastName, Clients.SSN, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, SUM(Payments.Amount) FROM Payments INNER JOIN Clients ON Payments.ClientID = Clients.ClientID WHERE (Payments.CreditorID = 1015 or Payments.CreditorID= 1014) GROUP BY Payments.CreditorID, Payments.ClientID, … |
| | I set up a server with SQL 2005 Standard and another server with SQL Reporting Services. Now my boss wants to upgrade to SQL 2005 Enterprise Edition. What would be the procedure for this upgrade and any caveats or problems that might arise, not only with SQL 2005 Std to … |
| | Hi I wonder how to write a query where given record meets at list n criteria from given criteria? For example i have a table PERSON like this: Name Height (short, medium, tall) HairColor (brown, blonde, black) EyesColor (blue, green, brown) I want to fine people who meet at least … |
 | I am trying to install Microsoft Accounting 2008 Express, which requires installing SQL Server Express 2005. I have a Vista Home Premium machine and it's giving me fits trying to get SQL Server (any flavor) installed. I've tried every tweak I can find online, but all to no avail. I've … |
| | Can anyone help me on this I recently installed MS SQL 2005 Developer on my PC (XP Pro)and that works oK. I installed another on my Notebook (Vista Ultimate) and somehow got connected to my PC Database. But that is cool. At least I know I can connect to my … |
| | Hello I am new in this. Just installed MS SQL 2005 on my notebook for learning purpose. I found that though using the default instance, it keeps giving me a logon screen which I am having problems loging in with Server Name: JMZCONS-PC Error Number: 18456 Severity: 14 State: 1 … |
| | i tried to add a database file to an exsiting Website project. i get this error. "connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly." installed products are visual studio 2008 sp1 sql server 2008 however creating a data connection to a database attached with … |
| | Hi all, I need a help in MS SQL Express query. I have a table named "tblTotalCust" and the fields are: [Date] date, [ServedTime] date, [TotalCustomer] int. Example data: [Date] [ServedTime] [TotalCustomer] 8/9/2008 12:00:00AM 8/9/2008 9:23:00AM 12 8/9/2008 12:00:00AM 8/9/2008 9:27:00 AM 7 8/9/2008 12:00:00AM 8/9/2008 9:37:00AM 9 8/9/2008 12:00:00AM … |
| | Hi, i have a problem with SQL, im verry new to it and in the beginner guides and tutorial you can't learn anything of the special tricks. I have developed a Access db, and i need to use the INSERT INTO statement to insert the current record id of a … |
| | Hi Friends, can some body help me in designing the below scenario: MY QUESTION IS HOW WOULD THIS INTERFACE LOOK LIKE? Objective: To design an interface for the following scenario. See attached image for visualization. Scenario: 1. There is an Application X (May be a VB or Java application) and … |
| | I have a datetime column in a T-SQL table that I need to sort desc. However, when I do this the NULL values for that field will show up at the bottom. I need them to be at the top of the list, while still having everything else sorted in … |
| | Hi, I have a question. Am aiming to install sql 2005 in one server and connect my applications which are put into another server to it. My applications are built in .NET2003 with .NET framework 1.1. Now I know that to install SQL2005 I need .NET framework 2.0.My question is, … |
| | Help - I am fairly new at MS SQL, but understand the concepts and have looked at the code in MS Access many times. But here's my problem: I need to create a complex query across multiple tables within the same database, but I'm just not sure how to do … |
| | We have a need to see if data exists in a field based on an ID and Date. The data we have exists in a table as follows: ID DATE ISSUE 903 01/15/08 3,2,1,,,,1, 903 01/15/08 3,,1,,,,,1, 903 01/16/08 ,,,,,,,,1,, 903 01/16/08 ,,5,,,,4,,, 903 01/15/08 ,,,,,,,,, 904 01/15/08 ,,,,,,,,, 904 … |
| | Hello, i'm very new here in these forums. I'm making a webpage for registration for my online game's server. My problem is in the registering part, i've got the query to register the new user on the database, but first i need to check if the name of the account … |
| | My database knowledge is pretty limited but im hoping this will work...... The idea is to have a database for customers who have their grass cut fortnightly. The database will be mail merged to form bills every month or so... So far I've constructed a database with the following tables: … |
The End.