3,481 Topics
 | |
| | Hi, I followed the following [URL="http://www.coderanch.com/t/424312/JBoss/Configuring-Eclipse-JBoss-MySQL-EJB"]http://www.coderanch.com/t/424312/JBoss/Configuring-Eclipse-JBoss-MySQL-EJB[/URL] to configure JBOSS and MSSQL Server in Eclipse. But I'm getting an error and I tried many ways but I'm still there. (In this guide "5. Copy the driver libraries to jboss-5.0.0.Beta4\server\default\lib" means copying jdbc.jar ??? right?) When I run an EJB project I'm … |
 | hi guys, i'm hoping some one will be able to help. i basically want to create website where people can upload pictures and then other people can view them and leave comments iv created the website of how i want it but i dont know how to create the database … |
| | Hi All, Couldnt figure out to obtain the nearest date in query properly. find below the sample. Insert Fsample (ESN varchar(10), optn_type int, auditdate datetime) values('123',2,'2011-1-03') values('123',11,'2011-2-20') values('123',2,'2011-03-02') values('123',2,'2011-4-10') values('123',11,'2011-5-18') 2=shipdate 11=returndate result ESN|Shipdate|returndate 123|2011-01-03|2011-02-02 123|2011-02-20 123|2011-04-10|2011-05-18 Thank you in advance. Jonel |
| | I cannot figure out how to increase the @bin I tried a cast as int and still no success. Any ideas are greatly appreciated. [CODE]DECLARE @counter int DECLARE @bin varchar(9) SET @counter = 1 Set @bin = '65R110001' WHILE @counter <= 5 BEGIN insert into laitem (ViitemName,viitemdesc,vilastused,vidateadded,virevisiondate,active,entitycode,manufactureddate, stopid,statusid, itemtypeid) values …  |
| | |
| | Is there a way I can set a user as System Admin via cmd? I have been searching the internet for ways to do this. i found this: [URL="http://support.microsoft.com/kb/937682"]http://support.microsoft.com/kb/937682[/URL] , but I would like to know if there is another way of doing it. Thanks, Andrew |
| | I have uninstalled sql server 2005 but failed to uninstall SQl Server 2005 Management Studio Express. To install Sql Server 2008 Management Studio I need to uninstall Sql Server 2005 Studio otherwise I can't proceed further! Can anybody suggest an easy and clean way to uninstall SQl Server 2005 Management … |
 | Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 …  |
| | if @fromDate = Datetime.MinValue BEGIN set @fromDate = (select MIN(applicant_statuss.created_on) from applicant_statuss) end if @toDate = Datetime.MinValue BEGIN set @toDate =GETDATE(); end the following error is Comeing : Msg 107, Level 16, State 2, Procedure sp_InterviewerPerformance, Line 21 The column prefix 'Datetime' does not match with a table name or … |
| | - I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help … |
| | Hi Guys, I am using SQL Server 2008 R2 on Windows Server 2008 Standard Edition.I tried to uninstall one of instances in SQL Server and I believe I "Select all the features" to remove from the Select the features windows.After uninstalling, I tried to run SQL server with another existing … |
| | I am using Windows Vista Ultimate. I was getting an error while installing MS SQL server express edition 2008 R2. I use VS 2008. I cannot find any any correct version of power shell on the internet. Please Help ! |
| | Hi everyone, I want to implement an "achievement" system of sorts into one of my projects. Similar to StackOverflow where if you do a certain thing or answer a certain number of questions etc you get a trophy that is linked with your user profile. The membership section of my … |
| | Hi. I'm having a problem with that code. Im getting this error: [I]Warning: mssql_execute() [function.mssql-execute]: message: Error de conversi�n al convertir una cadena de caracteres a datetime. (severity 16) (Translate: error converting string to datetime) Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed[/I] But I dont use datetime in this script! … |
| | Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD … |
 | Hi guys. I know this is a long shot, but does anyone know if parallel computing (multiple simultaneous programmers/developers working on the same file) is possible for SQL databases? What I'm wondering if is possible is working on a local database that updates the mdf file in two computers, which … |
| | Is there a way to exclude column from a table or View or Stored Procedure without specifying all the columns in the Select List Especially with table or View |
| | Hi guys Ive created a piece of software to extract data from 2 fields in an mssql table, and using php translate them into a graph. Im now trying to extract the field names as titles for my axes. I'm using sqlsrv_query s and have retreived data from the table … |
| | I have a table named "Table1" Its schema with data is like this [CODE=text] Id col2 col3 col4 col5 isUnique dbUnique 1 red 3M 1995 UK 1 null 2 red 3M 1995 UK 0 null 2 red 3M 1995 UK 0 null 3 red 3M 1995 UK 0 null 4 … |
| | Hi. Here's my scenario: I have a native Windows service running on a machine. The service is installed under Administrator privileges. Once per day, the service fires, creates a login to SQL (using the administrator account), queries a specific database (read only). The database is stored locally (same machine) and … |
| | The date stored in my db is in the following format: 2011-06-10 17:15:26.000 2011-06-10 17:15:27.000 2011-06-10 17:15:28.000 2011-06-10 17:15:29.000 However I intend to retrieve the date above using the format below: 2011-06-10 How is it done? Your help is kindly appreciated. |
| | I'm trying to import a Visual FoxPro database into SQL. The database is a free table directory data base, and I can import all but 3 of the tables. All three tables that won't import give me the same error message, that the memo file is missing or invalid. I … |
| | hi , i ma using the reporting service in MS SQL express 2008. but in the company i don't have the admin previlages to upload and create reports to the server. if i was to ask from the administrator to grant me the previlages what previlages does he have to … |
| | I am taking a database course and we are required to create some SQL queries. So don't give me the answer if possible. Just let me know what is wrong with this code: [INDENT]SELECT p.pat_id, p.pat_first_name, p.pat_last_name, p.pat_dob, ph.phys_last_name, s.service_desc, v.visit_date FROM Visit as v LEFT OUTER JOIN Visit_Service as … |
| | I would like to auto-generate a column which has a mixture of both numbers and alphabets. Like AA01 or AC24. I want to start at AA00 until AA40. From here i will go to AB00 until AB40, and do likewise for other subsequent alphabets until the last one which will … |
| | Hi I m Having a Problem in retrieving records. I want to get nth maximum value in a column. I have tried it using top select top n ColumnName from tablename where(select top n-1 ColumnName from tablename order by columnName desc) But i m getting all the n records. Any … |
| | We have 4 tables with field types like NVARCHAR and SMALLINT and we have 4 tables in the same database with VARCHAR and SMALLINT. The all reside i the same MSSQL2008R2 database with a database collationtype LATIN_GENERAL_BIN. If we run a simple query on the VARCHAR tables it comes with … |
| | |
| | Hi everyone, Thanks for viewing this post. I have a question about SQL. May i know how to remove rows that have NULL value in one of the colums. SELECT name, grade, age FROM education If let say grade 1 of the rows is NULL, how do i remove that … |
 | Hi In my compnay we use web based application and backend as sqlserver 2005.recently this backend is move into another new server.I restore database backup in new server.Issue is after 4 days I saw transaction logs file size is more that 16GB in new server .In old server transaction log … |
| | i want try to update the value of record from table1 where the value i need is from table2 like: table1 [CODE]Item_id | Quantity 0001 | 100 0002 | 200 0003 | 300[/CODE] [CODE]table2 Item_id | Quantity 0002 | 100 0003 | 50[/CODE] [CODE]when the query run.... i want the … |
| | In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring … |
| | Can anybody plz help me.. i need to find all the users who are grater than 10 days old. table name users ,fild contain with registration dates.to store date i used DateTime.Today with C#.Can any body give me a sql query to slow this |
| | Here is the condition,i have a table with the records for every months per year. I would like to retrieve the records only for three months per year. Lets make this clear, the records would be around Jan~Mar or Apr~Jun or July~Sept or Oct~Dec. Current date is 1-May-2011, so the … |
| | Hey. i have a table that has the columns of A,B,C,D and another table that one of the coulmns the VALUES of A,B,C,D i am trying to subquery the 2nd table at the coulmn that stores the abcd. and the result act as a column name for the 1st table. … |
| | Hope someone can help [B]I am using Visual Studio 10 Languague VB [/B] It is web based and conects to remote SQL Server If i run a query on database connecting using Sql Server management studio this query give correct results which is to find minimum value in a column … |
 | Good Evening All I want to create a unique value for my User in Silverlight and access this value on the asp.net page that is part of the silverlight website. So i cant use cookies because they wont work and i cant do the client site cookie thing because it … |
| | Hi guys. I am an IT student currently 3 days into my work placement which is the mandatory 3rd year of my degree course. I am working for a charity in England and my first task is to transfer data from excel sheets to a microsoft sql management studio database. …  |
| | I'm having problems with my query below. Basically I need to calculate the feet between two gps coordinates. Basically once I can get this formula completed instead of manually entering the data I'll use a temp table and then select the top 2 rows and then delete these and keep … |
| | I have varchar value 4890 And i am casting it to decimal and dividing by 100000 Its output is 0.0489000 But when i calculated the same on calculator it gives 0.04890 And i think it should be 0.04890 Please help me out Thanking in Advance |
| | Hi folks, this is my first post in danniweb, please excuse me if I am in the wrong place or the thread title lacks self explanation. I am very disoriented in the field since im new in MS SQL. Before going into the problem, I'm going to give some context: … |
| | I am debugging this error on my dataset table.I dunno what error is this should called.I calling store procedure then return to me this error.When i run in mssql is showing fine.But debug in C# ,1st table is showing fine but 2nd table is showing error mark in all my … |
| | Hai, I used a table for generating grade for students. for thati used the fields: UpperBound[int] LowerBound[int] Grade [varchar(50)] I have some datas such as : UpperBound LowerBound Grade 61 70 D 71 80 C 81 90 B I sent the value 80.09 to Stored procedure. Stored procedure something like … |
| | i have an interesting question for you guys. [CODE] SELECT S.SCHOOLID AS [SCHOOLID],S.SCHOOLNAME AS [SCHOOLNAME],SP.PHOTO AS [PHOTO] FROM SCHOOLPHOTO SP INNER JOIN SCHOOL S ON SP.SCHOOLID = SP.SCHOOLID WHERE S.SCHOOLID IN (SELECT SCHOOLID FROM #SCHOOLS) [/CODE] the Photo Field is an Image Datatype Field, i now you can use them … |
| | hi every one, I m tring to make on webapplication with PHP and MSSQL2005.This simple website has some report and chart those r dynamically update from my MSSQL db.I m using fusion chart free for charting. I have used this codes for report.[CODE]<?php include('DBConn.php'); include("FusionCharts_Gen.php"); $link = connectToDB(); $stmt=mssql_init("AreaWiseMonthlyRpt", $link); … |
| | I am new to SSRS, I need to to know basic concept of SSRS in PPT. Kindly help in this. Thanking in advance |
| | Hi everyone, I'm having a bit of trouble figuring out what to do here. Basically I have 3 tables shown below User Table [CODE] ID Firstname Lastname etc.... 1 James Hay 2 Someone Else [/CODE] Permissions Table [CODE] PermissionID UserID 1 1 2 1 2 2 3 2 [/CODE] Permissions … |
| | I have a table called UpdatedFigures with the following headings: ProductType, Month13, Month14, Month15.......Month24. Under each month there are numeric values and under Product type there is a row for ProductAlpha, ProductBeta and ProductGama. Each Row is populated with eh numeric values from the months. I have a separate table … |
| | Hello ..... I writing sql statment on access 2007, all what I need to do is to get the max value of a column depending on the max of another column.. an exmaple of the data is as below: Invoice No-------- Document no--------Document Date-----Value 1001115600188757 /// 5100002019//////13/12/2010////////-30469.50 1001115600188757 /// 5100002018//////13/12/2010////////30469.50 … |
 | Hi, I can't really understand what the problem is with my work computer. Below I will give a full description, and a summation at the bottom. I installed an apache server, php, mysql and mozilla, the usual. Installed Dreamweaver CS5, GIMP, SQL Server Management (accessing MSSQL databases in the system), …  |
The End.