2,935 Topics
 | |
| | 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 … |
| | 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: … |
| | I'm writing a program determine employee's working hours in a day by entry and exit clock in classes. In sql, I have a table, there are 4 field like : classID, cardID, date and clock. Teacher come to class and every teacher have an unique card. Card reader read this … |
 | Hi, I want to create a DataBase Diagram using MS SQL Server Management Studio 2005. But on context menu of DataBase Diagrams Folder, I am not able to see New Database Diagram menu item for any of the Database. I am getting only two menu item "Working with Sql server … |
The End.