9,022 Topics
Is there a keyword in SQL that would allow you to select a value from a field in the previous row? I am looking for something that would give me the speed field value for the row before: [code]SELECT min(Parsed.Time), [Parsed.Number] FROM Parsed GROUP BY [Parsed.Rev Number] [/code]
I am new to both c#.net and sql server. I am working on a project in which I have to 2-3 users using their application and connecting to common database in lan. I decided to use c# as my programming language. when coming to database i m very confused. microsoft …
Hi........ i'm currently working for an application that requires reports. So i used crystal reports. I did the standard way of connecting database and adding table to the report. However after doing all the necessary part, when i click the "preview report" button it doesn't show required output. Instead it …
hi i need to store data more than 8000 char in varchar in sql server 2000 how can i? plz help.
iam using following connection string (C#) SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\WindowsApplication1\Database1.mdf; Integrated Security=True;User Instance=True"); i deployed my project and i installed into client machine. after installed into client machine i cant able access the database.. Error: cant able access specified database path. can anyone tell me how to fix …
Hi plz help me I am done project on asp.met back end-sqlserver2000 I want to convert this web application in to exe form Would you plz tell me how to convert it
i have 2 comboboxes filled with ram values..both are the same.. i need to choose 0.5 from combobox6 and 2 from combobox7. and when I hit the click button, I want the sql query to get executed. 1. how do i fill the comboboxes with the same values from the …
Hi all, i am facing a problem to display image in IE 7.0 which are coming from my database (SQLSEREVER2005). for displaying image i am using folloeing code. [code=asp.net]Public Sub DataImage() Connstring = ConfigurationManager.ConnectionStrings("TestingConnectionString").ConnectionString 'Conn = New SqlConnection(ConfigurationManager.AppSettings("conn_string")) Conn = New SqlConnection(Connstring) If Conn.State = ConnectionState.Closed Then Conn.Open() i = …
Hopefully this will be an easy one for someone. I am trying to write a SELECT statement that pulls the row with the least time for each Special Number. Example data would be: Time Special Number 3:25:00 1 3:26:00 1 3:25:30 2 3:26:30 2 The expected output would be: 3:25:00 …
Hello, I am currently having problems getting Coldfusion and SQL Server 2005 to connect on my home laptop. I have both installed correctly, I just cant seem to get the connection part down I keep getting this error from the Coldfusion Administrator. [I]Connection verification failed for data source: GTOTDsite java.sql.SQLException: …
I have 2 table in a ms sql database prod_curs_test and rebuturi_test. I want to update some fields in prod_curs_test with data from rebuturi_test. I used this to do that: [code] update dbo.prod_curs_test set dbo.prod_curs_test.cant_rebuturi = (SELECT dbo.rebuturi_test.Cantitate FROM dbo.rebuturi_test CROSS JOIN dbo.prod_curs_test WHERE dbo.rebuturi_test.Comanda = dbo.prod_curs_test.Comanda) where exists (SELECT …
I have 2 problems with Reporting Service: [COLOR="Red"]The first problem:[/COLOR] I can't show report header and footer. [COLOR="red"]The second problem[/COLOR]: I am using the Arabic language to display the numbers and dates in the report and it's displayed arabic but when printing the report the numbers and dates appear in …
This isn't a problem as I have already solved the problem, just trying to figure out why it happened. Ok I have a field that is type money. I wrote a stored procedure that updates this field, however, I made the datatype for the parameter to get passed in a …
Hi , I have designed a database that is to create a application simlar to microsoft money The database erd is aattched with this post. The database has following table Invoice Amount Account Profit_center Customer A invoice can sometimes split in to 3 parts therefore i have create table invoice …
Hello, I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005. I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it …
Hi Everybody, I have problem with unicode data in SQL server. I could not show data that fileds are nvarchar,nchar,ntext properly on front end. [code] $myServer ='servername\SQLEXPRESS,1433'; $myUser = 'odysseous'; $myPass = 'ody1'; $myDB = "eSQL"; // connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to …
[B]Is it possible in a query to delete a row specifying its row index?[/B] I want to delete a row from my table. I'm trying to figure this because when I delete rows from my datagridview, it does not update. So I was thinking if I just directly delete it …
In relation to my previous post. I was able to delete the rows in the datagridview (thanks to ema005), but now I am having problems with the updating of it in the database. It's deleting in my datagridview alright. But not in my database. My codes are already going on …
hi this is suraj...i m final year IT student...and i m currently working wid my project of last year... i have an idea of my project....i just want to ask whether i can attach a C compiler in my VB project orr not....i m making something in which a C …
I have developed an application in vb.net to generate reports against a SQL database where I used visual studio 2003 - crystal reports. I need to deploy the same as a setup file to install it in other client PCs where there is no crystal reports or visual studio installed. …
Hi, I am unable to create a new database within Visual Studio. I can however create a database in SqlExpress and then see it in Visual Studio, but once in Visual Studio I can’t seem to do anything, e.g. If I right click the ‘Tables’ icon within a database in …
I have 3 radio buttons and each connected to a SQL statement..the first one 'NVIDIA*' does not get executed whereas the other two do because they dont have wildcard character in them. Can you please help me with this ? I tried 'NVIDIA*' in Access query and they worked perfect …
Hello I seem to be having a problem, I have this query that pulls back correct results [CODE]SELECT hourStamp, SUM(CASE WHEN datestamp < GETDATE() THEN 1 ELSE 0 END) / @numberofdays as HourAverage, SUM(CASE WHEN dateStamp BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),0) AND GETDATE() THEN 1 ELSE 0 END) as HourToday FROM webstats GROUP …
Hi everybody, I have a ntext problem. There are MS SQL SP in my project.And I am taking mssql_bind() warning and mssql_execute() error. But the problem is that I cannot make changes on these SPs. Because these Sp are used by other programmers who are using cold fussion as programming …
when i check one or 2 or 3 or all 4 chechboxes..i want a corresponding SQL query to get executed. Please help me rectify my code.. thanks kavitha. Dim con As OleDbConnection = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb") Dim cmd1 As New OleDbCommand con.Open() If (CheckBox1.Checked = True) …
How to Delete top 5 rows from a table
I want to begin a new project for company the project about Document Management System over internet In ASP.NET and SQL server they want to uploade the file and download ,edite file delete the company has main office it connect to 9 company how can i know the table first
Hi All. When I try to install the following: [COLOR="Red"]Windows Malicious Software Removal Tool - July 2008 (KB890830) Security Update for Windows XP (KB951748) Update for Microsoft Office Outlook 2007 (KB952142) Update for Microsoft Office Outlook 2007 Junk Email Filter (KB953463) Security Update for SQL Server 2005 Service Pack 2 …
Hi, I'm loading server 2003 onto a 2.66 core2duo with 4Gb of Ram and a 500 HD. When the software install gets to installing hardware the error message comes up with the above. I know this has sometging to do with a device or driver that the OS doesn't like, …
How can you make a table from a union query in access - i have the union working and producing what i want but i can store it as a view or as a table - i keep getting syntax errors [code] INSERT INTO HgTotals SELECT CollectionDate,HgTotalnglA as AllHGtotal FROM …
How To get the 5th row from a table.
I am using asp.net 3.5 and a sql server database. My host is godaddy. I was able to login before I deployed my website but now I am just getting the failure text of the login control. Can someone please help me?
Hey guys, I have some question about a query in SQL I'm buliding for my software. This software meant for Bills managing. I have main screen which display all the bills and another screen which display the bill details, this screen built on 3 tables : Bill,BillItem,Payment tables. My question …
I'm getting the error Incorrect syntax near '=' when running the following query. I'm fairly new to SQL, but this looks like it's pretty straightforward. Basically, I have a table with smartphone information (A_INV_SMARTPHONE) and a table for Windows CE Pocket PC information (A_INV_WINDOWS_CE). Both tables contain columns for Manufacturer …
Hi all, I have a problem achieving the result. I want data as below which is based on 4 tables [B]Expected rasult [/B] SiteID SiteName State PostCode Phone1 StateName CanDelete --------------------------------------------------------------------------------- 1 Site1 1 2134 124 123 - ADC 1 2 Site2 3 2323 124 234 - QTY 0 3 …
Hi all, I am searching and fetching the data in a form based on the name entered in the text field. When the submit button is clicked, another form is displayed containing all the fetched data.Right now the functionality works only for the name entered in the textbox. I want …
Hello, I am an intern at my company, and they are pushing me to start learning MS SQL. Primarily, I have been instructed to start learning scripts and query syntax. Thus, I searched for forums that could help me learn SQL and scripting, and here I am registering!. Can someone …
[COLOR="Red"][/COLOR]Please help me. Its very urgent.....I want to [B]develop a page in ASP [/B]where i need to [B]upload a table content from MS SQL database [/B]and [B]write to a text file in ftp server[/B], if file not present then i need to open new text file and write the log …
my selection of one, or 2 or all 3 at a time should get connected to a SQL query and get executed but that does not happen here atall.can u all please take a look at this code and help me with this.. please..' thanks Private Sub Button4_Click(ByVal sender As …
how to delete duplicate records from table.
Hi friends, There is one small problem for me regarding the data access..... Iam creating one FormView and iam connecting it to the SQL-server to access the table data..in that table iam creating a field without entering any value By using the FormView iam entering the value dynamically and iam …
Hi PPL I am working on a mobile application with VB.NET. I have created a table in SQLServerCE <tblFertilizer> in a database <Packhouse.sdf> Now i am trying to insert data into the table upon a button click event, but i get an "error parsing query" issue on the line where …
I have been trying to figure this out, surf thru google but I came back empty handed... I wana move data from Database A to Database B that means copying the content of one database to another database, I am using SQL server 2005... any help will be highly appreciated
hi guys, im having problems connecting to my database using vb.net and sql server 2k5. below is the code im currently using and it is having problems. please help me solve this problem. Thanks adapter.connection = conn is the one having problems the problem is connection is not a member …
Hi, I only joined yesterday. I have a problem with the following code where I get a missing operator error. Could someone please tell me what I am doing wrong. Thanks John '--------------------------------------------------------------------------- ' Function: strbuildSQLstr ' Purpose: Build SQL String to retrieve ADO Recordset ' Paramters: strChoice- string(Good or …
vista home premium sql server 2005 installer help
Hi I have a problem with inheritance (Generalization / Specialization). As far as I understand, you can implement inheritance in Relational Data-Base by (zero or one) to one relation, so how to make sure that Lecturer and Student are not the same Person, giving that Lecturer and Student are generalized …
Hi I have Client, Owner, and Staff entity, they all are persones!! with additional criteria... Client ID, FName, MName, LName Owner ID, FName, MName, LName Staff ID, FName, MName, LName so Is there a concept of inheritance in RDBMS like SQL-Server-2005 if so how can I implement it. At lease …
Hi my name is John from I U.K.. Have only recently got back into progarmming following the death of my wife in April this year, so could really do with help on a few things I am trying at the mo! Other than computers my other interests are my lovely …
Haris Hussain - Posted on Monday, June 30, 2008 23:15:15 I am facing a following exception. While am deleting a row from gridview. I am using VS 2005. Exception: Index was out of range.Parameter must be non negative and less than the index collection. Parameter Name : INDEX private void …
The End.