cgyrob

Hello, I am in my 3rd year and would be required to submit about 5 project proposals next month. I am really interested in doing a project involving database but as many topics as i have seen look like i would get hooked mid way. So please if you have …

Hi all, I have created a table in which i have a DateTime Column . i need that i dont want to insert values in that column from the front end. i have created a trigger for that purpose. whenever i insert a row in that table the dateTime column …

Hi I'm a newbie in SQL and for scores whose credit is greater than 2, I want to select students with scores of 10 or more .Here is what I wrote and Im having errors(See table below): SELECT Student,COUNT(Score)>=10 AS NumPasses WHERE Credit>2 GROUP BY Student Student Credit Score Tomy …

I have the following data in a field in my SQL table. I want to break up the data in this field so I can use it in reporting: Sample records: Record 1: Player: (265613) Miss Linlde M Simonds, Promo Adjusted -> 10.00, Beg. Bal -> 0.00, End Bal -> …

Dear SQL sharks.... Please somebody help me with this struggle. I have been searching the web for hours now. I have a table with sales data. In this table i have a columne called SalesAmount, CustomerName and SalesDate(the format i smalldatetime) Now I would like to retreive all the records …

Please how can I write a query to display only the top three earners in a table in desc order e.g Emp Sal John 100 Jam 120 Abi 90 Jo 170 the query should display Emp Sal John 200 Jam 170 thanks

Hi I have installed Microsoft SQL SERVER 2005. This consists of the Configuration tools(SQL server configuration manager,SQL Error and usage Reporting, Sql Sever Surface area configuration, Reporting Services configuration) and SQL Server Management Studio. However I dont find SQL Server Business Intelligence Development Studio. Can anybody tell me how to …

Hello, I've been trying to find a way, using Oracle Express, to return more than one column but have only one column be distinct. The following will make all three columns distinct. I want only the Job_ID column to be distinct. Can this be done in Oracle? [code=sql]SELECT DISTINCT Job_ID, …

I have an app where I keep getting this error. This is a c# .net 3.5 app running on a windows 2003 server with IIS 6.0 connecting to an Oracle 10g db. This app had no problems during testing where it was connecting to an Oracle 9i DB but once …

Hi, I need help with the following; Table 1 --------- Col A 1 2 3 4 5 Table 2 --------- Col A ColB 1 AA 2 BB 3 CC 4 DD 5 EE I need to look up say Table 1 Row 3, reference that to 'Table 2' but instead …

I have the following query in MS Access 2007 [CODE=sql]SELECT Projects.BIMinspector, Sum(Projects.R9) AS SumOfR9 FROM Projects GROUP BY Projects.BIMinspector HAVING (((Projects.BIMinspector)=[forms]![Form Report]![Elist]));[/CODE] How do I get it to return a result of zero if no records are found?? Any suggestions would be great. Thanks,

I am creating a gridview dynamically using Itemplate but I have run into an issue where the event handlers I create for my drop down boxes in edititem template are accumulating every time it fires. To be more specific. When I enter edit mode and select a new item in …

Dear All I am new in ADO.Net and i am using C#. My problem is I want to execute one trigger in my program I am having name of student in my student table now from my C# program I will pass any name which is in table from textbox …

conectivity of sql & visual basic is needed as early as possible pleaseeeeeeeeeeeeeeeeeeeeeeeeeeeee!

Hi... I want to write a IF Condition as follow: [CODE]set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[abc] AS SET NOCOUNT ON; BEGIN Declare @add = 0 as int Declare @change = 0 as int Declare @remove = 0 as int Select abc.value as 'Name' if (History.OLDSTR == …

Hello, I would like to know if there is an easy way to transform the following table CarId | PropertyName | PropertyValue 1 | Size | XL 1 | Name | Porsche 1 | Color | Red 2 | Size | XS 2 | Name | Smart 3 | Name …

I am new at oracle and working on a small project. I am trying to find "[" in a field and produce from that point to the end of the field. My code is as follows: [code] declare startPos PLS_Integer; endPos PLS_Integer; begin set startPos := (Select top 1(instr(description, '[', …

I want to select from a table only when a field repeats more than once. For this I have: [CODE]Select title, Count(*) As Cnt From poss_titles where Cnt > 1 Group By Title Order By Cnt desc[/CODE] But it says invalid column name cnt. How should I refer to this …

Hi all, Is it possible to insert a SQL statement where I specify the time, and not the date. I do need the date, but I want it to be the current date when I run the insert statement. The time got to be fixed. For example, Insert into xxx …

Im currently working on a gridview built using Itemplate at runtime. When in edit mode I use dropdownlists for some of the control fields which are populated from views in my db. The problem I am finding is I usually have a memberID field and a MemberName field and need …

hello , (begginer of SQL) i have to make one pro. in which i have to use trigger which will fire before inserting into table and convert the name into upper case but i don't what is the prob. with the code pls provide ur suggetion my table attributes are …

As the title suggests, I'm having trouble sorting the results of a union statement. I'm trying to sort the results by date descending and it's coming out ascending. [CODE=mysql] (SELECT a, b, c, d, e, f, date FROM table1 WHERE a=10 AND b=1) UNION (SELECT a, b, c, d, e, …

Hi, I am working with the gridview in .net 3.5 and have run into something I can not explain. I am testing my delete methods when I realized that the row was actually being deleted before my event handler even finished processing. Am I dreaming or just missing something. I …

I am just wondering if there is a way to stop my paging images from moving around the gridview footer when using the builtin gridview paging control.

Hi all, i hope anyone of you can help me on the following matter: I have two tables: Recordingid Connection Sequenceno 1233036621 1 3 1233036621 1 4 1233036621 2 8 1233036621 2 9 And the second one: Recordingid Connection Sequenceno Code Cause 1233036621 1 1 21 9 1233036621 1 2 …

hi can anyone help me? i cant even run the program I have made... This program should show the distinct numbers after you inputted numbers... I really don't know what to do, hehehe.. [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Distinct { class Program { static void Main(string[] …

Hi I use the following code to connect to an orace database in Visual Studio 2008 and it is falling over with the exception of ServerVersion threw an invalid operation exception at line 3: [CODE=C#]m_strConnectionString = Settings.GetMandatoryConfig("databases", "SourceDB"); m_strQueryTerminator = Settings.GetConfig("databases", "QueryTerminator"); m_odbConn = new OleDbConnection(m_strConnectionString); m_sql = new SQL(DatabaseType.AnsiSQL, …

I want to create a procedure which takes one input parameter(@name) and list all the fully or partially matching results. I used [code=sql]Select * from Table1 Where Name LIKE @Name[/code] but it didnt work. Can you help plz?

I want to store codes in a database i.e title code, status code, etc. I want to do this without affecting the performance of the database. I want u guys to tell me the most advisable way of doing this. I want to retrieve the actual code descriptions using these …

Hi guys, I'm new here. I have a problem though. I can perform a bulk insert from .csv file to MS SQL Server 2005. My problem here is that there are foreign tables in the .csv file. What I want to happen is that these data should be replaced with …