2,736 Topics
 | |
 | I want to write a program in C# that will populate the fields in a database that I have created, for example... I have fields in the database such as TotalWins, Name and TotalCredits. In the C# program, I want to have users enter these values into textboxes and when …  |
| | I have a foreach loop package that parses through some flatfiles and imports them into a database. Instead of using a batch script to grab files only with todays date I would like the the ssis package to only parse files with some sort of getdate() function. SSIS 2005 sorry … |
| | I am making a DBMS using C#.Net and MS SQL. i want to display the data using crystal reports. In the Database Fields when the Database Expert wizard opens after choosing OLE DB (ADO) and then OLE DB for SQL provider, i have to give the Server, user & password … |
| | How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to insert a1,b1,c1 in 1st row. a2,b2,c2 in 2nd row,... How do I write one sql insert statement to do that? |
| | Hi everyone, we have constructed a content management system that gets updated quite frequently and is used by many clients for their day to day opperations for their websites. We have decided to build a section of the CMS with additional modules that we will host on our cloud and …  |
| | 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 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) |
| | |
| | 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 … |
 | 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 … |
 | 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]) … |
The End.