Get Current Entered Record
Hi every one
I want to get the currently entered or updated record in the database table by using SQL Query or stored procedure.
Thanx in advance
Take care
Bye
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Sum All Record Except Last One Entered
im trying to summarize all records except the last one entered. ex -column001- 1 2 3 4 5 6 the output should be "15" (1+2+3+4+5) is this possible? One thing i tryed is to put in autodate and time and then count them and leaveout the newest one. Well i can't make it work... Thx for all help
View Replies !
View Related
Capture The ID Of The Last Record Entered And Use In An Update
I'm entering a Selection record for a partiuclar lotID, Once entered, I need to obtain its SelectionID then use it to update a another field within that record. Here's what I've been doing... --insert values into a testchangeorders table INSERT INTO testchangeorders VALUES (2,3,3,3,1,'red',0,5) --Find the SelectionsID of the last record created for that partiuclar LotID SELECT MAX (SelectionsID) FROM testchangeorders WHERE LotID = 2 --Once located, I was trying to update a field called uniqueID with a contantination of '3-' & the record's SelectionsID UPDATE testchangeorders SET UniqueID = ('3-' & SelectionID WHERE SelectionsID = SELECT MAX (SelectionsID) AND LotID = 2)
View Replies !
View Related
Joining Table On On Last Entered Record
Dear All, What's the most efficient way of joining a 1 to many relation, where a record in table A will have multiple records in table B. I'd like to select every record in table A but only joining the last relevant record from table B. So: Table A: A1 Prj1 A2 Prj2 Table B: B1 A1 23/12/2005 B2 A1 26/12/2005 B3 A1 2/1/2007 B4 A2 25/12/2006 B5 A2 1/1/2007 So I'd like to list using the most efficient way this: A1 Prj1 B3 2/1/2007 A2 Prj2 B5 1/1/2007 I'm assuming this is NOT the most efficient way: select A, (select top 1 date from B orderBy ...) Any suggestions?
View Replies !
View Related
Inserting A New Record Into Sql Db Using User-entered Information
Im trying to add a new rcord to my db on a button click usign the following code 'data adapter Dim dAdapt1 As New SqlClient.SqlDataAdapter 'create a command object Dim objCommand As New SqlClient.SqlCommand 'command builder Dim builderT As SqlClient.SqlCommandBuilder 'connection string Dim cnStr As String = "Data Source=ELEARN-FRM-BETA;Initial Catalog=StudentPlayGround;Integrated Security=True" 'dataset Dim dsT As DataSet Private Sub connect() 'connection objCommand.Connection = New SqlClient.SqlConnection(cnStr) 'associating the builder with the data adapter builderT = New SqlClient.SqlCommandBuilder(dAdapt1) 'opening the connection objCommand.Connection.Open() 'query string Dim query As String = "SELECT * from StudentPlayground..Employees" 'setting the select command dAdapt1.SelectCommand = New SqlClient.SqlCommand(query, objCommand.Connection) 'dataset dsT = New DataSet("Trainee Listings") dAdapt1.Fill(dsT, "Employees") End Sub Private Sub BindData() connect() DataBind() End Sub Protected Sub submitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submitButton.Click Dim empID As Integer = CType(FindControl("TextBox8"), TextBox).Text BindData() Dim firstName As String = CType(FindControl("TextBox1"), TextBox).Text BindData() Dim lastName As String = CType(FindControl("TextBox2"), TextBox).Text BindData() Dim location As String = CType(FindControl("TextBox3"), TextBox).Text BindData() Dim termDate As Date = CType(FindControl("TextBox4"), TextBox).Text BindData() Dim hireDate As Date = CType(FindControl("TextBox7"), TextBox).Text BindData() Dim dept As String = CType(FindControl("TextBox5"), TextBox).Text BindData() Dim super As String = CType(FindControl("TextBox6"), TextBox).Text BindData() Dim newRow As DataRow = dsT.Tables("Employees").NewRow newRow.BeginEdit() newRow.Item(0) = empID newRow.Item(1) = firstName newRow.Item(2) = lastName newRow.Item(3) = location newRow.Item(4) = hireDate newRow.Item(5) = termDate newRow.Item(6) = dept newRow.Item(7) = super newRow.EndEdit() 'do the update Dim insertStr As String = "INSERT INTO Employees" + _ "(EmployeeID,FirstName,LatName,Location,HireDate,TerminationDate,Supervisor)" + _ "VALUES (empID,firstName,lastName,location,hireDate,termDate,dept,super)" Dim insertCmd As SqlClient.SqlCommand = New SqlClient.SqlCommand(insertStr, objCommand.Connection) dAdapt1.InsertCommand() = insertCmd dAdapt1.Update(dsT, "Employees") 'Dim insertCmd As new SqlClient.SqlCommand = (builderT.GetInsertCommand()).ToString()) 'dAdapt1.InsertCommand = New SqlClient.SqlCommand(insertCmd.ToString(), objCommand.Connection) BindData() objCommand.Connection.Close() objCommand.Connection.Dispose() End Sub im not sure wats going wrong because the record is not being added. Please help!!
View Replies !
View Related
Trigger - Current Record ?
CREATE TRIGGER test ON [Table_1] FOR UPDATE AS UPDATE [Table_1] set [Field_1] =SUSER_SNAME() This trigger update all record, I want to update only the current record which is currenty update. How I cant to this ? Sorry for my english
View Replies !
View Related
How Do I Make Sure Only One Record Is The Current Issue?
I have a table of magazine issues. The table are defined as below: issueID int Uncheckedname varchar(50) Uncheckedtitle varchar(100) Checkeddescription varchar(500) CheckedcrntIssue bit Checkedarchived bit CheckednavOrder int CheckeddateCreate datetime Checked And here is what I want. Is there a way when inserting/updating or on the table itself to make sure that there is only one record that is marked as the current issue? The way I have it here in my table, any records can have the current issue (crntIssue) field checked. I only want one crntIssue field checked regardless of how many records or issues are in the table. If there is no way to automatically have SQL Server to manage that then that means I must check all the records before hand before the update/insert query, correct?
View Replies !
View Related
SQL: UPDATE, DELETE Current Record Only
Well, I really messed up. Instead of changing the name of a current company record in a table I changed ALL the company names in the table. Me.CustomerDataSource.SelectCommand = "UPDATE tbl_customers SET company = '" & companyTextBox.Text & "'" So, I need to insert a WHERE clause to fix this. My problem is that I've been searching everywhere for this simple command structure and cannot find anything that specifically addresses a simple way to reference the current record. I tried...Me.CustomerDataSource.SelectCommand = "UPDATE tbl_customers SET company = '" & companyTextBox.Text & "' WHERE recno = @recno" But I get the error: Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@recno". Can anyone provide this simple query clause?
View Replies !
View Related
How To Make A Trigger Refer To The Current Record
I have a table full of items that have a "date_updated" field. I'd like this field to be set to GETDATE() whenever a record is updated. I've got this trigger: CREATE trigger tr_cp_shiptos_u on dbo.cp_shiptos for update as update cp_shiptos set date_updated = GETDATE() Problem is, of course, there's no WHERE clause..yet. I don't know how to refer to the record that was updated.... for example: CREATE trigger tr_cp_shiptos_u on dbo.cp_shiptos for update as update cp_shiptos set date_updated = GETDATE() where shipto_id = @THIS_ID I imagine there's some kind of builtin variable or something like that. How is this done? Thanks in advance.
View Replies !
View Related
Get Rows Between Current Date And Current Time
I've this query SELECT t1.ID, t1.Date, t1.Time, t1.VALUE FROM RESULT WHERE t1.Date>=CONVERT(VARCHAR(10),DATEADD(d,-7,GETDATE()),101) AND t1.Date<CONVERT(VARCHAR(10), GETDATE(), 101) Let's say, current date is 8 AUG 2005 and current time is 2045 So, i will get ID | Date (this is datetime) | Time (this is integer) | Value -------------------------------------------------- 204 | 8/1/2005| 2359 | 90 205 | 8/1/2005| 2250 | 99 206 | 8/1/2005| 1950 | 88 ... ... 207 | 8/7/2005| 1845 | 77 208 | 8/7/2005| 2255 | 77 209 | 8/7/2005| 2140 | 77 Can someone can show me to filter data between t1.Date>=CONVERT(VARCHAR(10),DATEADD(d,-7,GETDATE()),101) AND TIME>=CurrentTime t1.Date<CONVERT(VARCHAR(10), GETDATE(), 101) AND TIME<=CurrentTime If current date is 8 AUG 2005 and current time is 2045, so the result shown as follow ID | Date (this is datetime) | Time (this is integer) | Value -------------------------------------------------- 204 | 8/1/2005| 2359 | 90 205 | 8/1/2005| 2250 | 99 ... ... 207 | 8/7/2005| 1845 | 77 I only have this query, SELECT t1.ID, t1.Date, t1.Time, t1.VALUE FROM RESULT WHERE t1.Date>=CONVERT(VARCHAR(10),DATEADD(d,-7,GETDATE()),101) AND t1.Date<CONVERT(VARCHAR(10), GETDATE(), 101) lack of idea to put the TIME condition. Plz help me..
View Replies !
View Related
Getting Key Just Entered
************* Edited by moderator Adec *************** Inserted missing < code></ code> tags (without the spaces inside). Always include such tags when including code in your postings. Don't force the moderators to do this for you. Many readers disregard postings without the code tags. ************************************************** Hi Probably a dumb question but I'm doing an insert into a table with an identity field. How do I get the key back straight after I add it? This is how I do the addition SQLString = "Insert into users (username,password,status,campus, ulevel ) values ( @username, @password, @status, @campus, @ulevel)" cmdInsert = new SQLCommand(SQLString, conn) cmdInsert.Parameters.Add( "@username", _username) cmdInsert.Parameters.Add( "@password", md5Hasher.ComputeHash(encoder.GetBytes(_password))) cmdInsert.Parameters.Add( "@status", _status) cmdInsert.Parameters.Add( "@campus", _campus) cmdInsert.Parameters.Add( "@ulevel", _ulevel ) conn.Open() cmdInsert.ExecuteNonQuery() conn.close() but about now I need the primary key just generated. Any ideas? Thanks ABold
View Replies !
View Related
How Can I Report On Entered And Updated Records
My database has many table, each table has a DateEntered (datetime), EnteredBy (nvarchar(50), LastUpdate (datetime), and LastUpdateBy (nvarachar(50). Is there an easy (ha) way to pull a list of the records that were entered and/or updated for a date range. Hopefully without a select for each table. Maybe a tool someone knows of?
View Replies !
View Related
Parameter Entered Has The Wrong Format.. You Must Be ....me!
Hi I have the problem that the below defined paramter gets entered in the database as a interger. the Field in the DB is a nvarchar(5) and the controll that suplies the value is a TextBox this is the parameter definition:<asp:ControlParameter ControlID="tbComment" Name="Comment" PropertyName="Text" Type="String" /> Why do I get this error, why does ASP to whant to make an integerfrom this text field? When putting a interger value in the textbox all works well and the data gets posted to the database. I use a SqlDataSource with automatic generated script. look forwart to a solution walter
View Replies !
View Related
Prevent Invalid Characters From Being Entered
Hi, I need to be able to prevent an invalid character from being entered into a sql 2000 databae on import from oracle. In short, I need to exclude a certain character from being entered and need to be able to send an email which specifies that an attempt was made to enter this character, if the change was due to an insert or an update, the row to be affected in the target database, date and time info. Also the source of the data. If this is not possible, is it viable to remove the character after insert and still send the email with the required info? Any one any ideas? Thanks
View Replies !
View Related
Preventing Invalid Data From Being Entered
Hi, I need to be able to prevent an invalid character from being entered into a sql 2000 databae on import from oracle. In short, I need to exclude a certain character from being entered and need to be able to send an email which specifies that an attempt was made to enter this character, if the change was due to an insert or an update, the row to be affected in the target database, date and time info. Also the source of the data. If this is not possible, is it viable to remove the character after insert and still send the email withe the required info? Any one any ideas on the cleanest way to achieve this? Thanks
View Replies !
View Related
Detect No Time Entered For Datetime
I have a VB.NET program that displays the time extracted from a SQL Server database datetime datatype by way of a User-defined scalar function I created. However, sometimes information is entered into the system through the program that does not have a time-- only a date. SQL Server automatically assigns a time of 12:00 AM to these values (since they're a datetime). Is there any way to detect when this happens in my user-defined scalar function so that when I try to extract time values, I can instead return a message/time of my choice? I would rather not assume that all 12:00 AM values are automatically inserted by SQL Server since this might not actually be the case.
View Replies !
View Related
User Entered Data Error
Hi Guys, I'm having a problem with some data in our database, basically a web app is storing data into the DB and then recalling it to display to a user. The problem I am having is that for one particular function the DB is causing the app to fail, the app code works for 95% of the data inserted into the DB by the users but it is failing on a few records.. I'v gone through the data manually checking for funny characters or spaces or anything else which is different from the other records, but everything seems to be in order. I doubt very much that this is a system app code problem as the code is working perfectly for all the other records... Can anyone advise me on what else I can check.. really stuck on this one guys Thanks Gurj
View Replies !
View Related
Roll Date If Time Entered Is After Midnight
Hi again, In ASP.net, is there any elegant way to handle a set of time inserts from a form when the 2nd time is past midnight? Specifically, I have a form with 2 textboxes on it (startTime and endTime) that are set up to accept time values (using AJAX MaskedEditExtender for formatting/validation - pretty cool). This data is posted to a sub that enters the data into a table (T_Details). However, I've noticed that the data inserted as part of the record (SQL field is smalldatetime) doesn't take into account the fact that a time value past 23:59:59 in the "endTime" textbox is a time on the next day - it simply rolls to an A.M. date for the same day as the date for the pre-midnight value from the "startTime" textbox. I'm sure that I can simply do some conditional coding and modify the date if necessary but is there a better way to do it? Thanks as always...this forum is a great resource
View Replies !
View Related
Values Entered In Db Has Trailing White Spaces
Hi, I'm inserting a few columns into my db (they all have a nvarchar(50) ).. but i noticed when i retrieve them out of the db, the length of the string always have some trailing white spaces behind them and such when I try to do stuff like dropdownlist.items.findbyvalue(), it normally fails.I did trace and before the string get into the db, they were teh right length. so I'm not sure where did I do things wrong? thanks
View Replies !
View Related
How To See If A Value Entered In A Textbox Is Present In An SQL Database Field?
Hello! and Help if possible!!!I am creating a booking system in ASP and C#. I have a database that stores the calendar info on some employees, including start and end dates of their current meetings.I am stuck! i am a newbie at this! ive got a pop up calendar that populates a text box with the start date selected and the same for the end date. What i need to do is pass this value to the start date field column in my sql database and iterate through the rows to see if that date already exists for that employee! if anyone has any ideas in how to do this, any help would be extremely gratefully appreciated!!!!! Thanks,
View Replies !
View Related
The Value You Entered Is Not Consistent With The Data Type Of The Column.
Hi.. I am trying to add new record to any table in my database. But I can't. I am tryting to add a value (1500 character) and it gives the message below "The value you entered is not consistent with the data type of the column." I have tried alot. The result is my columns in my table accept maximum 900 character. But the type of my column I try to add a value is text.. I am too angry with SQL Please help
View Replies !
View Related
DatetimePicker Control Retains The Previously Entered Value
Hello all, I have a peculiar problem. We are using VS-2005,SSRS-2005,SqlServer-2005. Our front end is Windows forms and we are communicating with SSRS through WebServices protocol. Through WebServices we are generating dynamic parameters based on the report and were able to show them on the Win form screen. We have a Custom Nullable DatetimePicker control, which can accept NULL values. My problem is: once a date is entered and deleted the DatetimePicker control retains the old value. Please throw some light on this issue...Any kind of help would be appriciated. --Deepak
View Replies !
View Related
Not Able To INSERT The Values Into The Database Entered In The Textbox-Please Solve It
using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Configuration; namespace Balatest { /// <summary> /// Summary description for WebForm2. /// </summary> public class WebForm2 : System.Web.UI.Page { protected System.Web.UI.WebControls.Label Label1; protected System.Web.UI.WebControls.Label Label2; protected System.Web.UI.WebControls.Label Label3; protected System.Web.UI.WebControls.Label Label4; protected System.Web.UI.WebControls.TextBox TextBox2; protected System.Web.UI.WebControls.TextBox TextBox3; protected System.Web.UI.WebControls.TextBox TextBox4; protected System.Web.UI.WebControls.TextBox TextBox5; protected System.Web.UI.WebControls.TextBox TextBox1; protected System.Web.UI.WebControls.Button Button1; protected System.Web.UI.WebControls.Label Label5; private void InitializeComponent() { } private void Button1_Click(object sender, System.EventArgs e) { try { string con,fname,age,city,companyname,designation; fname= Server.HtmlEncode(TextBox1.Text); age= Server.HtmlEncode(TextBox5.Text); city= Server.HtmlEncode(TextBox4.Text); companyname=Server.HtmlEncode(TextBox3.Text); designation=Server.HtmlEncode(TextBox2.Text); con= ConfigurationSettings.AppSettings["connection"].ToString(); SqlConnection obcon= new SqlConnection(con); string sql = "insert into home (fname,age,city,companyname,designation) values(@fname,@age,@city,@companyname,@designation)"; obcon.Open(); SqlCommand com = new SqlCommand(sql, obcon); com.CommandType = CommandType.Text; com.Parameters.Add(new SqlParameter("@fname", fname)); com.Parameters.Add(new SqlParameter("@age", age)); com.Parameters.Add(new SqlParameter("@city", city)); com.Parameters.Add(new SqlParameter("@companyname",companyname)); com.Parameters.Add(new SqlParameter("@designation",designation)); com.ExecuteNonQuery(); obcon.Close(); } catch(System.Exception ex) { } } } } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { //CODEGEN: This call is required by the ASP.NET Web Form Designer. InitializeComponent(); base.OnInit(e); } // <summary> // Required method for Designer support - do not modify // the contents of this method with the code editor. // </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion
View Replies !
View Related
Verify Data Entered In An Access Form With A Dialog Box
hi.. i just made a form to collect information and add it to a databse.. i was wondering if tehre was any way i cud put some code in my "submit button" that would tell the user.. "this is wat you have entered.. are you sure u want to add it to myTable? cust. name : jon last name : smith add : 100 main st. ........." and w/2 buttons, "Yes" and "No I made a mistake, let me go back and edit".. whihc server their respective purposes.. any ideas anyone..?? cheers..
View Replies !
View Related
What Is The Optimal Solution To Find, If All The Data Is Entered On A Predefined Condition?
Hi,I want to know the optimal solution, to find if all the data was entered. Lets say, Table A (date field) and for a given month, i need that all the days in the given month are present in the Table A. Right now i have different solutions, 1) a stored procedure which loops through all the days in the given month against a select statement on Table A2) a stored procedure, create a temp table which contains all the dates in the given month, and a single select statement using where condition (select * from.... where datefield not in (select * from...))I want to know what is the best solution of these two or any other solution.Thanks
View Replies !
View Related
Combine Tables From 2 SQL Servers With Different Schemas And Update As New Data Is Entered
I have 2 SQL server 2000 machines, I need to take a table from each one and combine them together based on a date time stamp. The first machine has a database that records information based on an event it is given a timestamp the value of variable is stored and a few other fields are stored in Table A. The second machine Table B has test data entered in a lab scenario. This is a manufacturing facility so the Table A data is recorded by means of a third party software. Whenever a sample is taken in the plant the event for Table A is triggered and recorded in the table. The test data may be entered on that sample in Table B several hours later the lab technician records the time that the sample was taken in Table B but it is not exact to match with the timestamp in Table A. I need to combine each of these tables into a new SQL server 2005 database on a new machine. After combining the tables which I am assuming I can based on a query that looks at the timestamp on both Tables A & B and match the rows up based on the closest timestamp. I need to continuously update these tables with the new data as it comes in. I havent worked with SQL for a couple of years and have looked at several ways to complete this task but havent had much luck. I have researched linked servers, SSIS, etc Any help would be greatly appreciated.
View Replies !
View Related
Question-Advice Needed: Creating A System To Synch Handheld Entered Data With Main Database.
Greetings! I would like to create a database for keeping track of payroll data for employees where the supervisors (job coaches) on our workshop floor can use a Pocket PC device to record the hourly employee data on the fly. Then at the end of the day, the supervisor can place the device in a cradle of some sort and synch the newly entered data into the main database. I'm guessing that SQL Server Compact edition would be perfect for this type of task? Is that correct? Can someone give me recommendations on how to go about setting this up? What should I use as the main database? SQL Server? Access? Any advice is appreciated!
View Replies !
View Related
Check If Date Is Current Date And Stay Current
Hi, I'm making some sort of application where people can add their resume. They also need something to add places where they have worked or currently are working. I have a form where they can add this and i add this experience using the following stored procedure: GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create procedure [dbo].[sp_Insert_Experience] @ExperienceId uniqueidentifier, @ExperienceEmployee nvarchar(100), @ExperienceFrom datetime, @ExperienceUntil datetime, @ExperienceQualifications nvarchar(250), @ExperienceTechnologies nvarchar(250), @ExperienceTasks nvarchar(250) as insert into Experiences values(@ExperienceId,@ExperienceEmployee,@ExperienceFrom,@ExperienceUntil,@ExperienceQualifications, @ExperienceTechnologies,@ExperienceTasks); It must be possible to add the place where they currently are working. Then the ExperienceUntil has to be something like still going on. Then I decided that the user then had to set the current date. But what I want is the following, I want that the ExperienceUntil keeps updating automatically, like everytime i get that record, it has to have current date. Is this possible ? But if the ExperienceUntil isn't the current date , it just had to take the supplied parameter date.
View Replies !
View Related
Ways To Make This Work: Several Selectable Related Record For One Main Record.
Hey all! Sorry for the less then descriptive post title but I didn't find a better way to describe it. I'm developing an app in the express editions of VB and SQLserver. The application is a task/resource scheduler. The main form will have a datepicker or weekly overview and show all tasks scheduled per day. The problem is, I've got one or more people assigned to tasks and I wonder what's the best way to design this. Personally, I'd go for one Task table, a People table and a table that provides a link between them (several record per task, one for each person assigned linking TaskID and PplID). However, I don't see a nice way of showing this data to the end user, allowing him to edit/add etc on ONE screen. To fix that the only way I see is just add columns to the Task table for every person with select boxes. This way everything can be done on one simple screen. This obviously does present some future issues. On top of this, which people are available on a day varies and there should be an option to allow a user to set who is available on a specific day. Which would lead me to my first idea and add another table that would provide this. but then I'm having design issues again for the form. I'm kinda stuck atm, can anyone shed some light on this. I'm sure there is an elegant way of doing this but I'm failing at finding it. Thanks in advance, Johan
View Replies !
View Related
Query Timeouts When Updating A Record Retrieved Through A Websphere JDBC Datasource - Possible Record Locking Problem
Hi, We're running a Sage CRM install with a SQL Server 2000 database at the back end. We're using the Sage web services API for updating data and a JDBC connection to retrieve data as it's so much quicker. If I retrieve a record using the JDBC connection and then try and update the same record through the web services, the query times out as if the record is locked for updates. Has anyone experienced anything similar or know what I'm doing wrong? If I just use DriverManager.getConnection() to establish the connection instead of the datasource, and then continue with the same code I don't get these record locking problems. Please find more details below. Thanks, Sarah The JDBC provider for the datasource is a WebSphere embedded ConnectJDBC for SQL Server DataSource, using an implementation type of 'connection pool datasource'. We are using a container managed J2C authentication alias for logging on. This is running on a Websphere Application Server v6.1. Code snippet - getting the record thru JDBC: DataSource wsDataSource = serviceLocator.getDataSource("jdbc/dsSQLServer"); Connection wsCon = wsDataSource.getConnection(); // wsCon.setAutoCommit(false); //have tried with and without this flag - same results Statements stmt = wsCon.createStatement(); String sql = "SELECT * FROM Person where personID = 12345"; ResultSet rs = stmt.executeQuery(sql); if(rs.next()){ System.out.println(rs.getString("lastName")); } if (rs != null){ rs.close(); } if (stmt != null) { stmt.close(); } if (wsCon != null) { wsCon.close(); }
View Replies !
View Related
SSIS: Multi-Record File Extract With 9 Record Types
I am attempting to create a multi-record file (as described in my last thread) and have found the following set of instructions very helpful: http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2007/09/25/multi-record-formated-flat-file-with-ssis.aspx I have been able to create a sample file with two of my record types. I now need to build on this further, because I have 9 record types in total that need to be extracted to a single flat file. does anyone have any ideas how I might extend the example above to include more record types or know of another means of achieving this? Thanks in advance for any help you might be able to provide.
View Replies !
View Related
Form Criteria Based On An Entered Date And Date Today
Hi I am very new to SQL so please excuse me if my question seems too easy to answer. Basically I need to populate a form based with records based on the criteria that the next mot date and todays are +/- 10 days. i.e if todays date is 13/05/07 and the next mot date is 3/05/07 or later OR 23/05/07 or less then various fields will be shown in the form. Can you please help. Thanks Paul
View Replies !
View Related
Delete Record Based On Existence Of Another Record In Same Table?
Hi All,I have a table in SQL Server 2000 that contains several million memberids. Some of these member ids are duplicated in the table, and eachrecord is tagged with a 1 or a 2 in [recsrc] to indicate where theycame from.I want to remove all member ids records from the table that have arecsrc of 1 where the same member id also exists in the table with arecsrc of 2.So, if the member id has a recsrc of 1, and no other record exists inthe table with the same member id and a recsrc of 2, I want it leftuntouched.So, in a theortetical dataset of member id and recsrc:0001, 10002, 20001, 20003, 10004, 2I am looking to only delete the first record, because it has a recsrcof 1 and there is another record in the table with the same member idand a recsrc of 2.I'd very much appreciate it if someone could help me achieve this!Much warmth,Murray
View Replies !
View Related
Record Locking: Multiple Users Accessing The Same Record
I have read several discussions about SQL 7 having built-in record locking. I am assuming that this is only during the transaction process. I have a problem with multiple users access the same record on a SQL table. We have these users accessing the SQL data with an Access 2000 DB Project form. When one person accesses the form to pull up a record, someone doing this at the same time will get an error window that asks the user to Save/Drop changes. Is there any way to LOCK DOWN a record until a user has finished making changes to it?
View Replies !
View Related
SQL Challenge - How To Return A Record Set Starting At A Particular Record?
I have a directory of user information. What I would like to do isallow someone to search for person X and then return not only theinformation for person X, but also the information for the next 15people following person X sorted alphabetically by lastname.So if someone searched for the lastname = "Samson", it would return:Samson, JohnSaxton, GregScott, HeatherSears, Rebecca.... (15 names following "Samson) ...How do you in SQL return a record set of X records starting atparticular record (e.g. lastname = "Smith)?Thanks in advance.
View Replies !
View Related
Joining Record With The Most Recent Record On Second Table
Could anybody help me with the following scenario: Table 1 Table2 ID,Date1 ID, Date2 I would like to link the two tables and receive all records from table2 joined on ID and the record from table1 that has the most recent date. Example: Table1 data Table2 Data ID Date1 ID Date2 31 1/1/2008 31 1/5/2008 34 1/4/3008 31 4/1/2008 31 3/2/2008 The first record in table2 would only link to the first record in table1 The second record in table2 would only link to the third record in table1 Any help would be greatly appreciated. Thanks
View Replies !
View Related
|
TRACKER
