2,736 Topics
| |
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) 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 … | |
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 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 … | |
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 … | |
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 … |
The End.