3,481 Topics
 | |
| | I'm trying to store a data from the checkbox. when i checked on NSO Birth Certificate it has to be stored into my mssql server. here is my code If nso.Checked = True Then strsql = "insert into student info(Requirements) values ('" & nso.Checked & "')" Dim sqlcmd As New …  |
| | Guys, I have an SSRS report with a month to date parameter. the date parameter is set up like startdate 10/01/2011 - enddate 10/31/2011. I would like to run this every first day of the current month through ssrs subscription. I need your idea guys to tis in subscription. thanks. … |
| | Hello, I'm currently working on a database application where the application can show a number of risks and counter-measures. Now i'm updating the application so it is possible to upload new risks without having to open the database. However, each risk has an riskID, a number that was being put … |
| | Hi dear S/W Eng and Asp.net c# Developer. I am facing a big problem during converting a textbox value to decimal. baceous the Database type of that variable is decimal(4,4) that is client requirement.From front end when we passing a value like 1234.0000 MSSQL throws exception "Fail to convert numeric … |
| | Hi dear S/W Eng and Asp.net c# Developer. I am facing a big problem during converting a textbox value to decimal. baceous the Database type of that variable is decimal(4,4) that is client requirement.From front end when we passing a value like 1234.0000 MSSQL throws exception "Fail to convert numeric … |
| | Hi There; I have a MS-SQL 2005 in my computer. There is a [I]person [/I] table, and this person table have three columns; [I]name[/I], [I]surname [/I]and [I]address[/I].They are nvarchar(50). I hold the data of my company on it. User can make some queries over it via HTML. PHP code does … |
| | Hi, I[B] have a problem with the following query select tbl_employee.E_Name,sum(tbl_Salary.Amt),tbl_Dpt.DeptName from tbl_employee inner join tbl_Salary on tbl_employee.eid = tbl_Salary.eid inner join tbl_Dpt on tbl_Salary.eid = tbl_Dpt.eid where tbl_employee.eid ='E101' When the query is executed,the following error is displayed "Column ' tbl_employee.E_Name' is invalid in the select list because it …  |
| | Hi all, this is maybe a big stupid question, but cant get this to work thing is that i have 5 tables: airlines - hotels - costs - projects and payments being costs my main table. In this costs table I need to have in the 'total' column the sum … |
| | I'm new to stored procedures and, really anything about sql beyond the basic SELECT/INSERT/etc... so this is probably just something I don't understand but my problem is that my stored procedure seems to only return the last row of the result set (i.e. if it should return 10 items it … |
| | Hi There; I have a MS-SQL server and I have Turkish names in my table. User enters names and I send it to SQL server, print result to output. However, my PHP code process and prints text as a UTF-8, and send it to MS-SQL and print it to output.However … |
| | I try many tips but not able to connect two table with each other! Actually i want something like that , I insert into one table and if data also used by another table (Data automatically insert in another table also by submitting data in first table) |
| | Hai , I have a table Student_transport_Details having columns : UserId DesignatonId StartDate Enddate I need to get records for a particular month. Can i retrieve records by passing MonthId [between 1 -12]. Thanks in advance |
| | Good day! Anyone knows how to select latest record of an item..here's the scenario. I have records with the same data except for the date. Example: product_code productname item_code date PR-123 abc TY-01 2011-10-11 PR-123 abc TY-02 2011-10-11 PR-123 abc TY-01 2011-10-13 PR-123 abc TY-02 2011-10-13 PR-123 abc TY-01 2011-10-16 …  |
| | Hi, I needs to upload the excel file and how can i read this excel file cell by cell using PHPExcel class and needs to import into database(mysql or mssql).please help me out. thanks in advance |
 | I'm having problem to update the data into mysql database. for insert new data, it works nicely but if i want to update the existing data, it will hang my pc. even if i debug line by line, it shows like infinite loop. which part has gone wrong? i'm totally … |
| | |
| | When I execute the code below I am getting unknown column 'total' in 'field list' error. [CODE] DELIMITER$$ CREATE PROCEDURE setAuthentication(IN uname varchar(12), IN oldpws VARCHAR(12), IN newpws VARCHAR(12), OUT status INT) BEGIN call getAuthentication(uname,oldpws,@total,@pwsval); IF(total=1 AND pwsval IS NOT NULL) THEN UPDATE authentication SET password = newpws WHERE loginId=uname … |
| | create table test2 (Roll_ID int ) insert into test2 values(1) insert into test2 values(2) insert into test2 values(3) insert into test2 values(4) insert into test2 values(5) i want output as RollId |
| | Heya people, Here's my problem: i have a (for me quite lengthy) piece of SQL code which is automagically generated by my own application. However, when i try to execute it, it gives me an recordSet error ("Either BOF of EOF is true, or the current record has been deleted"). … |
| | Hai , I have 2 tables 1. [B]Transport_Details[/B] having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee[/B] having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. My problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 and … |
| | Hi There; I have a problem during connection to a MS-SQL server. I copy the code there: [url]http://www.webcheatsheet.com/PHP/connect_mssql_database.php[/url] [CODE] <?php $myServer = "localhost"; $myUser = "Murat"; $myDB = "examples"; //Point 1 //connection to the database $dbhandle = mssql_connect($myServer, $myUser) or die("Couldn't connect to SQL Server on $myServer"); //Point 2 //select … |
 | Code Warriors, I need to set a value in my SQL database as (1 or 0 ) (true or false) so that when i click a button to insert into the database the column register 1 and when i click the button delete the column register 0. do any warrior …  |
 | I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 … |
| | Hi, I have a datarow retrieved from a datatable. I have a value that exists in some column in the datarow. I want to find which column this value is in. How can I achieve this please? Thanks |
| | Hi, I have a value which I don't know which column this belongs to in the table. So is there a way I get get those rows that contain this value using query? Thanks |
| | This code supposedly generate a web chart but it does not work. How is the correct way to bind data using SQL into web chart. thank you all :) [CODE]Function GetReader() As IDataReader Dim strSQL As String strSQL = " SELECT aa.alert_id, " strSQL = strSQL & " (SELECT alert_value … |
| | Hi. Good day! Hope you could help me through this. I'm having trouble with my customize table sorting in BIDS. i used this formula in group sorting. [CODE] =Switch(Fields!AGE_CAT.Value = "0 - 1", 1, Fields!AGE_CAT.Value = "2 - 4", 2, Fields!AGE_CAT.Value = "5 - 9", 3, Fields!AGE_CAT.Value = "10 - … |
| | Hi friends... I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working. I google it and found some solutions but not successsful yet. Can anyone give me detailed guide (step … |
 | Okay so I am completely new to creating a database, and have been trying to create one in Visual Studio 2010 I found this guide on the web and have been following it pretty successfully till I came to spot that I can't get past (here's the link - [url]http://msdn.microsoft.com/en-us/library/dd193408.aspx[/url]) … |
| | I need to get data between year and period. 1 year have four periods. i.e; year = 2010 period = 1,2,3,4 the problem is on the period part where i could not select second period smaller from the first period. for example, i choose year=2010 to year=2011 and period=4 to … |
| | Hi. I would like to do insert and update database using data from excel file. before i can insert any data into the db, i have to check whether the field is already in the database or not. the primary key is year_id, period_id and stock_code. IMO, to do data … |
| | Pals, I love this site with a passion. Again now i need to know how i can relate different tables together using SQL database with different field. Thank you for your responses. |
| | Hi guys, I am writing some query from winforms. I am getting error with the following query: [CODE] string query = "Select [Doctor Name], Day, DateTime, Med_Sur from Doc_Pat_App where (lower([Patient Name])= '" + name + "') and (DateTime >= GetDate()))";[/CODE] I know that there is no mistake till lower() … |
| | Hai , I have 2 tables 1. [B]Transport_Details [/B]having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee [/B]having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. But my problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 … |
| | Hi, Anyone please help me out. Am having a table with field name 'status' with the values 'yes' or 'no'. Really, i wants to change this 'yes' or 'no' status automatically using mssql server. But i don't have an idea to continue on this work. for example, now the value … |
| | I have an intranet using php 5.3.8 on Server 2003 using IIS 6.0 and SQL 2005. I run a command to call a batch file that starts and stops sql server and then calls a stored procedure to delete records from a table Items and then refreshes the records from … |
| | Guys I have a table with image datatype and I wana insert an image in the image field, for example [CODE=SQL]insert into dbo.Products(ProductID, ProductName, ProductPrice, ProductImage) valeus(144, '8 Gig Lenovo memory Stick', 250.00, 'Image from C:Drive or where ever the image residing')[/CODE] Thanx in advance |
| | guy i was given a qeustion for my exam that What is the most commonly booked room type for each hotel in London? to this i replied [CODE]SELECT MAX(R.roomno)AS most room selected FROM ROOM.R,HOTEL.H,BOOKING.B GROUP BY roomtype WHERE H.hotelno=B.hotelno AND city='london' [/CODE] my problem is that i dont know if … |
| | I want to create a SQL login in SQL2005. I tried creating it but it gives me error message [COLOR="Red"]"Create failed for login 'username'. User does not have permissions to perform this actions"[/COLOR] What to do now to create a SQL login in sql 2005 |
| | hi all. here's my problem;. I would like to have a macro to export data from an excel file into the database(SQL) for insert and update data purposes. but i'm not sure how to do this.Can someone please show me a code syntax on how to do it?the excel file … |
| | Is it possible to create a stored procedure to delete all records from a table (i.e. DELETE FROM <tablename>), but pass the table name to the procedure as a parameter? My desire is to have only one procedure for deleting multiple tables' records; I would simply pass in the table … |
| | I'm new to MS SQL and trying to solve a problem where I need to extract specific data from a remote SQL Server 2005 DB into a local SQL Server 2008 R2 DB. In a Stored Procedure, I'm trying to use Linked Server via Ad Hoc links in the following … |
| | Hi there. I am learning SSAS using Wrox book. I followed the tut in the book to create a project in BIDS (Business Intelligence Studio by Microsoft). Deployed the project in SSAS, which gave success status. However while browsing it in Cube Editors browser pane it gave me error as … |
| | |
| | I have 3 tables: A, B, C. How to insert 100000 rows into table B, while inserting have data is the random data are taken from Table A and C Thanks for help!!!! |
| | Hi, I have a problem with reading a csv file with SQL server UNH+ATOPHOEXEDI+AVLABL' PLD+AII+RE11S' TRV+1+40+DU03+MAN+LCA+20110706:0000:1' ACC+1+SUNNY HILL HTL APTS ?+ POOL 3*:11113+:: PAPHOS+20110706+3:3 STAR++E:1:999' PRC+A:825:3*C:0:1:15+9+5:2475:9:1BDR APT 2/4 INLAND VIEW+2:4++SC: SELF CATERING' TRV+2+40+DU03+MAN+LCA+20110706:0000:7:N:20110713:0000' ACC+2+SUNNY HILL HTL APTS ?+ POOL 3*:11113+:: PAPHOS+20110706+3:3 STAR++E:1:999' PRC+A:4900:3*C:0:1:15+9+5:14700:9:1BDR APT 2/4 INLAND VIEW+2:4++SC: SELF CATERING' . … |
| | Hi! I need some help. Let's say I have 3 tables (t1(id,ds), t2(id,ds) and t3(id,ds)) where the tables don't necessarily have the same id fields. For example: t1 id ds 1 1 2 0 5 7 t2 id ds 8 5 1 2 t3 id ds 9 3 8 5 … |
| | I am having a hard time figuring out how to delete a row from the datagridview using a datasource that will also delete the row in SQL Database. [CODE] public partial class Form1 : Form { const String sStr = "Server= ************;Database=***; Integrated Security=SSPI"; SqlConnection sConn; SqlDataAdapter daCourse; DataSet ds; …  |
| | Hi Morning all, here I've code how to insert data into multiple tables in Sql Server using asp.net C# form but the data unable to enter ang got error, may anyone help fix it form me? because i've tried so many times already but still cannot, there is the code … |
| | Procedure is created on SQL server inserting the data from sql server to oracle databse When individually run the query it executed in 10 sec When run through procedure it takes sometime 1.5min and 5min [CODE] CREATE procedure sp_Trade_Book as Begin SET NOCOUNT ON BEGIN TRY --Begin of TRY BLOCK … |
The End.