2,935 Topics
 | |
| | Our employees have an interface to enter their vacation days. The vacation dates are stored in the database as one row per day, minus the weekend days. I'm trying to create a report that will show the starting and ending dates for each employee. Note: Each employee can have muliple …  |
| | In my MS SQL 2005 i have given "[B]Windows Authentication[/B]". Now how to connect with NETBEANS?? I means wat to give in User Name and Password fields?? I tried to give my User name and password while login into Windows. But not working. I am getting this error [COLOR="Red"]"the user … |
| | Hi , can anyone help me. I tried to start an SQL Server instance from command line with sqlservr.exe. But on the last line it said "a significant part of sql server process memory has been paged out. this may result in performance degradation". And my instance didn't start. But … |
| | Our server growth is too fast from 30GB from last month now it reaches into 50GB. Is their a problem in our database? Can this be possible to shrink this database into a minimal Size? Our server is MS SQL server 2000. |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
| | Hello, I'm having problem with a query which is based on fixed-part and all I do is that I'm modifying part after WHERE something.value='... . This whole text is a string which I need to be connected to my query. '113') AND (reklamace.kod_reklamace = '932' ' Error message: Conversion failed … |
| | hello all, im a student and doing a project to automate a process. For which i ve to download files from clients site.. my doubt is can zip files be stored in sql database. if its possible means how can i achieve this.. need help! good day.  |
 | Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to … |
| | I am New TO Programming Am HAving 2 Table One Table Having Coloum ID and NAmeOf Eventt And Other Table Having Coloumn ID and Imagepath I want To Retrive Id related the NAme Of Event and Want To Insert That ID into other Table at the same time i want … |
| | Hello! I'm hoping that you can help me Alter a SQL table to provide a unique constraint over 2 columns. For instance let's say I have a departments table called Dpt_tbl with two columns that I want to be unique Name Location So I want to make sure that you … |
| | Hi, Not sure if this is right place to post this, please move if needed. I set up a web form so that the text from a set of text boxes was inserted into a database when you 'submitted' the form Since then I have added some validation to the … |
| | General Question, no code: I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I …  |
| | Hello, can you help me convert MS SQL DateTime to miliseconds since 1970? Thanks, Domen |
| | DOH spelt thread name wrong... should be query! This is surely simple... this is the end of my query [CODE]where CCM0300.dbo.Device.tkModel= '72' AND CCM0300.dbo.NumPlan.DNOrPattern like '31455' OR CCM0300.dbo.NumPlan.DNOrPattern like '38600' OR CCM0300.dbo.NumPlan.DNOrPattern like '36305' OR CCM0300.dbo.NumPlan.DNOrPattern like '36805' OR CCM0300.dbo.NumPlan.DNOrPattern like '38285'[/CODE] what this is meant to do is return … |
| | Hi I need to create an SQL to retrieve the max date for each change in stock code. can anyone assist please? I am extremely new to SQl. I used access to get external data but it drags down 60,000 odd lines. i only have 5000 line items so with … |
| | Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy … |
| | hi i have a query and i want to use it in remote server when i try to run it in my machine it executes ok. but in remote server it cannot be executed. im connected to the remote server and i can view all the records in the table. … |
 | Just struggling through my SQL coursework, and already fallen over the first stubling block :( My case study tells me that i need to put a foreign key from my centre table (parent) to my salesman table (child) on a 1-1 relationship. Trying to add my foreign key, which is … |
| | Hi friends, I am new to SQL.. I have a table with 200 rows and 100 columns.. I want to extract unique rows from this table such that no two row are more than 60% similar.. this 60% is a variable and would be user defined.. I have attached an … |
| | I have created a form in which there are various values such as Name, Address, Date of Birth etc. The user is also allowed to select an image in a picture box. I want to insert these values along with the Image into database in appropriate columns. Any help is … |
| | Hello I have 2 databases, one is like a backup for the other. So they have identical tables: Alarmi, which has columns: OBJEKT, OPIS, VREDNOST, START, E_A, UPORABNIK I want to compare those two tables and copy only new entries (rows) to the backup database. How can I do that? … |
| | Hello, I have downloaded "Microsoft SQL Server JDBC Driver 3.0" and tried sample code. I added "sqljdbc.jar" and "sqljdbc4.jar" in Libraries. But getting error, [COLOR="Red"]java.sql.SQLException: No suitable driver found for jdbc:sqlserver:bug_tracking at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at Main.main(Main.java:18)[/COLOR] The code is given below : [CODE]import java.sql.*; public class Main { public … |
| | Hi friends.When I try to connect to sql server 2008 from visual studio 2008 an error occurs : "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL … |
| | I am creating a sample database and the work is so painful, I really wonder and need assistance to reduce my pain. I would like to create a "lookup Field" which returns the value (string) automatically from another table. Example, I have 2 tables - Department and Employee Department[DepartmentID, DepartmentName] … |
| | web.config ConnectionString My Connection string for an application within iis to connect mssql db looks like this <add key="ConnectionString" value="server=localhost;database=search_parser_2;uid=DOMAIN\Administrator;pwd=password;Connect Timeout=1000000;" /> Yet the application wont get past the login script (where the sql connection is happening i presume). the database name is correct and the server name is correct … |
| | What I'm working on is a video rental project in visual basic 2008. I have a local database which contains info on DVDs, Members and a table for current rentals. [B]The columns i have in the current rentals table are:[/B] MemberID | DVDID | DaysOnRent | DateRented | DueDate | … |
| | I have 2 databases on my computer, managed in the same SQL Management Studio - named [B]DATABASE1[/B] and [B]DATABASE2.[/B] The two databases are different except they have 1 table is the same, this table is called [B]Employee[/B] Because this the content of this table should be the same, how could … |
| | Hello Everybody, I have used inner join with two tables to join them and tried to calculate the sum of rows. Now the table descriptions are- Table1- agent_business_collection (it stores business collection of an agent of different business packages) Table2 - agent_business_commission (it stores commission of an agent against different … |
| | I am exporting a large amount of data from SQL Server 2005 to Excel. Most of the data appears as I want it to- without the exponential notation. Any values [I]smaller [/I]than 0.0001 (i.e. four zeros to the right of the decimal) are displayed as, for example, 7E-05 rather than … |
| | I need to have a database of the online flight booking system. May i have some guidance ? |
The End.