[microsoft:sql-server] Forum Topics

hi am beginner in php.. please help me.. rough explanation: user will select orgname and the following code will get the orgname and import data from mssql. i wanted to filter those data according to groupname and count number of users access to the system in month basis according to …

i know how to save a text file to a sql database, the problem is on when will be the process is executed because i need to monitor the operation of an existing system..

hi friends .... i have one website which have only html pages. I want to add one page that fetch records from sql database . is it possible????? what should i do for this task???? somebody please help me.. i waste 2 days behind this thing. thanks in advance.........

Is it possible to move the "description" column to the right of the "Allow Nulls" column in the table designer so you can see the descriptions for each table column without clicking through them one at a time? Like the attached picture? Please, someone, for the love of all that …

I have a database [CODE]LastBalance,AdmissionFee,ClassFee,Total,Received,Balance[/CODE] Please tell me how can i get [B]Last Balance[/B] from sql server

I'm trying to connect a SQL database to a Classic ASP site. I keep getting the following error message no matter what I do: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. I have an ODBC entry for this database, as well as have the …

I hve created one procedure in oracle which is used as a dataset 1 in SSRS in oracle procedure we created one table which is used in sql server query as a dataset 2. but after click on refresh button it gives proper resultset. can we get proper data without …

Hi, I have a table with more than 3000 records. I need to replace a particular string of all the rows wid some other string But when i am using replace function Its only replacing half of the rows of the table while the other half are not getting replaced. …

Hi Guys, I have created a manual SSRS Report. when i click the layout tab it display report layout then i drag the fields from report datasets. i want to set my fields into Table details and i want to insert group but this function is missing or hide. i …

Hello, I have a SQL database that I am trying to run and narrow it down quite a bit. The database is for a calendar, and for a school district, on the main district homepage, I want to display events from all four high schools, but only the NEXT one …

Hi, I want to implement a voting system in my web page. What I want to do is give a user 1 point per day so they can give that point to other users but after they give their point they have to wait until the next day to have …

Hi All, I have my table with duplicate records. the duplicate records have the same ESN and Shipdate the difference is the time. there is no transaction in same date. That's why i would like to remove the other records. I need your help guys. How to this. 1. I …

LEADID ACCOUNTMANAGERID ActivityDate USERNAME Q6UJ9A08MZSN U6UJ9A0000IR Mar- 1-2011 KSHITIJ GUPTA Q6UJ9A08MZSN U6UJ9A0000IR Mar- 1-2011 KSHITIJ GUPTA ACCOUNTNAME Kayess Finance & Investments Kayess Finance & Investments show only one records for duplicate this o/p come from various join it just an sample data i have near about 250 duplicate records in …

Hi, Can any one suggest the method to delete bulk records upto 1 lakh without specifying any condition? There's no Id to be specified in checking in the where condition. Please suggest an idea . Thanks In advance

I have a table customer in ms sql and i have same table in Oracle. I want to insert data from ms sql to Oracle. I am not getting the solution.

Hi I want to populate a text box from a stored table I have this for the data With DropDownList1 .DataSource = ds.Tables("property") .DisplayMember = "propRef" .ValueMember = "propRef" .SelectedIndex = 0 End With "property" holds all the info from the db when the user changes the dropdown list I …

Hi, Please could you help me resolve the error message below by pointing me in the appropriate direction. The frustrating thing is that whilst the error code points to a Stack-Overflow I can not pin the offending code down because the software works faultlessly on some computers after deployment but …

Can You Please help me where I am getting error.. :( I am using NetBeans and MicroSoft SQL Server 2005. [B]HTML CODE[/B] [CODE]<html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body> <form action="movie.jsp" method="POST"> <p><strong> List Of Movies:-</strong>s</p> <select name="moviename"> <option>powe</option> <option>ghi</option> <option>xyz</option> <option>Troy</option> <option>poer</option> <option>abc</option> <option>pqr</option> <option>qwe</option> <option>ghj</option> <option>RA …

I am creating a runtime table which is taking values from the database, but the problem is that the all the rows of database table is showing in one column when running on browser, how to divide the data in two columns . the code is shown below which is …

what query should i write in c# with backend sql server for finding all purchases i did from george in a date range. from purchases table.

I posted this out here yesterday and received several great responses using an ArrayList. During a code review it was suggested that a use a List<Sting> for the reusultset. Any Ideas would be welcomed. Thank you for all of your responses yesterday... [code] public List<String> getAnswers() throws DAOException, SQLException{ //This …

:confused: I'm trying to select multiple rows in a DGV and then do something with them(delete them for example) and then apply these changes to DB. and I'm using sql server express. the problem is when i load data from a table that is bound to the DGV and then …

I have sql table with 3 columns id, parentid and name.I have attached the table i have . Also i have attched the table output i want. In the name column ,there are so may values out which yes and no are two values which occur more than once. I …

Hi Guys need a bit of help! Basically I have a parent table called users which stores all the user info with a prime key field called ID. Now in the child table which has a seperate foreign key associated with the ID field in the parent table. What I …

I developed a method to query a database and return the specific values that I'm looking for except that the value being returned is the last value. In my while loop I can do a system.out.println(answers)and I can see all of the values, my return answers only returns the last …

Im using the rank function for a route order on my import. The script works perfectly fine except when I have to stops at a location (locationid,stored as a GUID). This is how it currently looks locationid Rank 0A0F4E97-699B-E011-B139-00188B47C528 1 0A0F4E97-699B-E011-B139-00188B47C528 2 110F4E97-699B-E011-B139-00188B47C528 3 110F4E97-699B-E011-B139-00188B47C528 4 0E0F4E97-699B-E011-B139-00188B47C528 5 0E0F4E97-699B-E011-B139-00188B47C528 6 …

Any could give me a PHP script on how to call or execute a MS SQL Server stored procedure, passing parameters to it and receiving a value from it using an Output parameter?

could you help me, please ! ... because i am newbie, sorry :) at form vb net 2005, i can browse file .mdb (C:\my documents\db1.mdb), I have created a table in sql server database, where table is the same as the access table that will be imported, after that when …

I have a piece of code that takes two strings, puts them together, then attempts to save that result into a table in a database. For some reason, the database is only showing the second half of the string ([ICODE]Me.txtRev.text[/ICODE] in this case). When in debug, I can see that …

please tell me c# code i want to determine largest number in a column of sql server 2000 table and store it in a variable.

i want to select MAX Id where i have the list database s001.1 s001.2 s001.3 s001.4 s002.1 s002.2 s002.3 s002.4 upto so On my field type is char(7) MSQL SELECT MAX(sup_id) where data type is char(7) plz help me out to perform this query in SQL.

Guys, Can you help please to compare or check the records from Mytable1 to MyTable2 if exist or found. and i have to count the records with not null. Any idea. you can modify my script. [CODE] elect a.ESN b.ESN FROM MyTable1 as a Left outer join Mytable2 as b …

Hello, I am currently working on a stored procedure that shows the time of day as an integer value: 456, which means 4:56. I was wondering if there is a way in SQL that I can convert this int in to a datetime value. So instead of the time appearing …

Please i need to know how to schedule an auto backup for my program database. Please anyone with ideas?

[CODE]insert into mst_report_dtls(report_name,url_path,login_id,pwd,domain,amd_date,amd_user_id) values ('Contractwise_statistics','http://192.168.22.11/ReportServer?/TradingReport/Contractwise_statistics','dbadmin','1nPrPgqv5UIpU4SYnGddJw==','ace',getdate(),1) [/CODE] Above statement i used to run from backend. Now i have developed a front end While running the code it gives me SQL Exception Following is my code [CODE] namespace Ace_System_test { public partial class Admin_CRMReport : Form { SqlConnection connstr = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["database"]); …

Hello All I'm converting an access database to MS SQL for a webapp and have a question if anyone knows how to do this. 4 fields [TimeReported] [TimeOff] [TimeOn] [TimeAssigned] Access only stored time, so date is incorrect. 1 Field stored date separately [Date] I would like to take each …

Hi Guys need your help on this :( Basically I am developing a web crawler so once the html source is converted to plaintext in a textbox, i intent to save it in dB. But the dB seems to be having trouble excepting some characters into the table and throwing …

hello all i kindly help me out i have a table in sql server with transaction id and amount i want to add the amount values of those rows where id is same for example i have 4 times 2 in transaction id table now i want to add all …

Hello I am going to use datagridview checkbox column to check the desired records to insert into sql server database.how it is possible?

I m trying to connect an sql express database over lan. my connection string is as below. Data Source=Mr-4f04a26307ff\sqlexpress; AttachDBFilename=F:\\Projects\\MyProj\\FirstProj\\bin\\Debug\\Database\\MyDB.mdf;Integrated Security=ture; User Instance=true; but unable to connect and throw this exception Login Failed for user 'Mr-4f04a26307ff\Guest' What is the problem with this and what is the solution. thnx

Hi Folks, I have a simple app (coded in VB 2008 Express Edition) that uses an SQL Server database (in .mdf format) that works fine on my own machine. I created the database in SQL Server on this machine. I added the DB as a data source and it works …

I have written the following code in a class as my connection string. I want to retrive data from a field in a table in my database using this connecyion string. Please how do i go about it? [CODE]Public Class ConnectionString Public Shared Function ConnSQL() As SqlConnection Dim connectionString As …

Hello All Experts Please tell. Can I use Microsoft Excel Sheet in c sharp as addition of Students Monthly fee And save it in SQL Server ?

Hi, I have developed a software program using c#.net and with sql server express. When I put this into production environment this should be able only for people who has a get the software by me. Eg: If I have issues a license, it should be valid only to a …

[CODE] string sid = Session["id"].ToString(); string q1, q2; q1 = "select count (*) from All_msg where target_id = '" + sid + "'"; SqlCommand cmd1 = new SqlCommand(q1, cn); int v1; v1 = (int)cmd1.ExecuteScalar(); q2 = "select count (*) from All_msg where target_id = '" + sid + "'"; SqlCommand …

i have a project connected with sql server 2000... i want to generate the some reports, for that user should itself enter the dates or codes for reports.. i have created a data environment, called the tables. now in general tab, i have selected SQL Statement to filter my data …

I am trying to generate rules form of output from user data.that output i have to store in sql database.so when each time , user is giving different data for processing, i have to create a new database for storing the rules from their data. how can i do this …

Hi! my code gives me this error. "An object reference is required for the non-static field, method, or property 'HD.RegisterMember.CN'" Plz can anyone help me. This is my code(Class); [CODE] private SqlConnection CN; public static String getLastMemID() { String ID = null; try { CN = new SqlConnection("Data Source=BJ-PC\\SQLEXPRESS;Initial Catalog=DB;Integrated …

Exception in inserting date into database [CODE] String Fname= request.getParameter("txtfname"); String Lname= request.getParameter("txtlname"); String Uname=request.getParameter("txtuname"); String Pass=request.getParameter("txtpass"); String Email=request.getParameter("txtemail"); String Gender=request.getParameter("group1"); String Add=request.getParameter("txtadd"); java.sql.Date sqlDate = new java.sql.Date(new java.util.Date().getTime()); //out.println(""+Fname+Lname+Uname+Pass+Email+Gender+Add); Connection con= null; //if(Fname != null && Lname != null && Uname != null && Pass != null && Email …

Hi Guys, Kindly please help me on how to this in scripts. How to calculate and get the average aging based on the Aging period. I could not figure out on how to do this in script. btw, even the format is not like my sample it's okay, unless i …