How To Retrieve Last Updated Record
I have some set of records in my table.
The same set of records will be updated often. Now I have a column as "lastupdated"
While i am displaying the records in a datagrid, The LAST UPDATED record should only be displayed.
Means, the recently updated records should be displayed in datagrid.
Pls give me the sql code / i am also in need of a Stored procedure for this.
I am working in SQL 2005
View Complete Forum Thread with Replies
Related Forum Messages:
Retrieve Last Inserted Or Updated Record
Hi I have an application which get any change from database using sql dependency. When a record is inserted or updated it will fire an event and my application get that event and perform required operation. On the event handler I am usin select ID,Name from my [table]; this will return all record from database. I just want to get the record which is inserted or updated. Can u help me in that. Take care Bye
View Replies !
Keep Track Of When And By Who A Record Was Created And Also When And By Who The Record Was Last Updated
I have not yet succeeded in getting an aswer to this in a previous post, so I'll try again and rephrase the question I have 2 fields, 1 called 'Created' the other 'Updated' I would like to create a function, user procedure ,whatever in SQL something along the lines of... FUNCTION myUID() RETURN Date(Today)+Time(Now)+USERNAME END FUNCTION so that the value returned by the above pseudo code is something like '20080526T21:01:05.620SamL' where the date part is in yyyy0m0d format I have got this working fine for the default 'Created' field but the calculated (and persisted) field comes up with something about being non-deterministic and refuses to play Clearly something along these lines is a very straightforward requirement (I have it working fine in my 20+ year old database) , but have spent a week trying to get an answer (even from this forum) without success, so would be grateful for any help that you can provide me with to get round this barrier
View Replies !
SQL Help: Get The Record I Just Updated
Hi - apologies if this is not the right forum for this - I've searched a bit and this seems to be the best fit. I have the following problem: I want to update records in a table that fit certain criteria. The way the insert logic works make sure that there will always be only one record that fits the criteria and I'd like to get the ID value of that record once the update went through. So here is what I tried: 1 UPDATE Timeslot 2 SET StartTime = @StartTime, EndTime = @EndTime 3 WHERE (ProfessionalID = @ProfessionalID) AND (ProviderLocationID = @ProviderLocationID) AND (RequestID IS NULL) AND (StartTime > @StartTime) AND 4 (EndTime < @EndTime); 5 SELECT SCOPE_IDENTITY() My hope was that the select scope_identity would return the Timeslot ID of the row that was affected, but it doesn't. How do I get that row? Thanks!!! Oliver
View Replies !
How Can I Be Notified When Record Is Updated
I want to build an windows application by using a visual C# to Notify the user that his data in the database had been changed ..such like "New Message In Your Mail Box Alert"..So I need to know if there is way that to let the SQL Server send a notify (just like Trigger) ..
View Replies !
Need Help Checking To See If More Than 1 Record Updated.
I am trying to write a trigger that, on an update, will check to see if more than one record is being updated. If more than one record is being updated, rollback the transaction and print a message. If not, then commit the transaction and print an OK message. My problem is I am having troubles writing this trigger. I will post my SQL trigger code so far. I am new with Triggers, so any help or advice is appreciated. Code: CREATE TRIGGER trgPaperCheck ON BOOK AFTER UPDATE AS IF UPDATE(Paperback) BEGIN DECLARE @count AS INT SELECT @count = COUNT(Paperback) FROM Book IF @count > 1 BEGIN PRINT('Only one Book record can be updated at a time!') ROLLBACK TRANSACTION END ELSE IF @count =1 BEGIN PRINT('Paperback Updated') COMMIT TRANSACTION END END
View Replies !
How To Get The Record I Just Updated By Mistake
Hi, I was opening a web page, that has a grid view representing the records of a table, I updated a record of the sql table by mistake, but I am not sure which record, is there any way in Sql server to get the last record just updated few minutes ago. I hyave admin permissions on the DB. Also, is there a way to know the value that was just there before the changes? Thanks a lot.
View Replies !
Trigger To Update An Updated Record?
I have a table called invoice. The invoice table has two audit columns: last_update_by and last_updated_date. I am trying to create an ON UPDATE trigger that will use the getdate() and user_name() functions and udpate the updated record with those two values. In other words, I want to create an ON UPDATE trigger on the invoice table that udpates the invoice table. Would this create an infinite loop? Can you update an updated record through the use of a trigger in this manner? Thanks for your help.
View Replies !
(sql 2005) How To Get The Record I Just Updated By Mistake
Hi, I was opening a web page, that has a grid view representing the records of a table, I updated a record of the sql table by mistake, but I am not sure which record, is there any way in Sql server to get the last record just updated few minutes ago. I hyave admin permissions on the DB. Also, is there a way to know the value that was just there before the changes? Thanks a lot.
View Replies !
Auto Update Value When Record Gets Updated
I have a table that contains a field LastUpdated. This field should contains the date of the last update of the record. Is there a way to auto-update this field value to the getdate() value each time the record is "touched" by an UPDATE sql command? Thanks in advance, Joannes
View Replies !
Display Last Updated Record By A User
I would like to show when leads updated last their records in database. An automated report that tells me when the last date was that the leads updated an entry, only 1 entry per lead. select Lead,LastUpdated from dbo.KPITbl I have a table with data that looks like this: Lead LastUpdated ----------- ----------------------- JOHN SMITH 2008-03-26 08:45:00 JOHN SMITH 2008-03-20 09:33:00 MEG RYAN 2008-02-21 16:16:00 JOHN SMITH 2008-02-21 16:19:00 MEG RYAN 2008-02-21 16:22:00 JOHN SMITH 2008-03-28 16:10:00 JOHN SMITH 2008-03-28 08:49:00 JOHN SMITH 2008-03-23 19:23:00 MARK MCRAE 2008-03-27 03:12:00 MARK MCRAE 2008-03-26 08:48:00 MARK MCRAE 2008-03-26 08:46:00 JOHN SMITH 2008-03-26 08:47:00 JOHN SMITH 2008-03-26 08:48:00 ALLAN WHITE 2008-03-26 08:43:00 ALLAN WHITE 2008-03-26 08:40:00 JOHN SMITH 2008-03-26 08:48:00 Thank you appreciate it.
View Replies !
How To Determine Which Record Was Updated Using A Update Trigger?
Im using a trigger to check updates on particular table and execute a email. it works but it doesnt show the right record im looking into one table called SiteInfo. here is my code Im using sql 2005, can someone look at my code or the select statement. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE TRIGGER TTSUpdate ON SiteInfo FOR UPDATE AS declare @SiteID varchar(10) declare @Body2 varchar(2000) declare @Sitename varchar(50) declare @TTSCreate varchar(30) declare @TTSCreator varchar(50) declare @Subject2 varchar (100) SELECT @SiteID = SiteID,@Sitename = AccountName,@TTSCreator = TTSOwner,@TTSCreate = TTSCreatedDate from SiteInfo SET @Body2 = 'New TTS site created: ' + @Sitename + ' With TTS Site ID:' + @SiteID + ' TTS was created on: ' + @TTSCreate + ' By:' + @TTSCreator SET @subject2 = 'New TTS site created: ' + @Sitename EXEC msdb.dbo.sp_send_dbmail @profile_name = 'TTSAdmin', @recipients = 'email address here', @subject = @subject2, @body = @body2 GO
View Replies !
How To Retrieve One Record
I have a question, one user made mistake that she delete one record from a database. How can i retrieve this only one record. I just know how to restore the database. Thanks.
View Replies !
How Can I Retrieve Nth Record Only?
Could you help me out? I am interested in retrieving certain record among outputs. For example, if I use the following sql, select * from info order by name asc ==================================== then I can retrieve 25 rows from info table. What I want to do is that I want to retrieve 15th record only among possible 25 records. How can I solve this problem? Thanks in advance.
View Replies !
Retrieve The Record.
I'm trying to compare the fields if they are equal, retrieve it. Because null <> null. i cant retrieve the record. Is there anyway to retrive the records by comparing all the fields? declare @table table( ad_num int null, ad_str1 varchar(50) null, ad_num_suffix_a varchar (10) null, ad_num_suffix_b varchar (10) null, ad_unit varchar(10) null, ad_num_test int null, ad_str1_test varchar(50) null, ad_num_suffix_a_test varchar (10) null, ad_num_suffix_b_test varchar (10) null, ad_unit_test varchar(10) null, passed bit) insert @table (ad_str1, ad_str1_test) select 'apple road orad RD' , 'apple road orad RD' select ad_num , ad_num_test, ad_str1 , ad_str1_test, ad_num_suffix_a , ad_num_suffix_a_test , ad_num_suffix_b , ad_num_suffix_b_test , ad_unit , ad_unit_test, passed from @table select * from @table where ad_num = ad_num_test and ad_str1 = ad_str1_test ad_num_suffix_a = ad_num_suffix_a_test and ad_num_suffix_b = ad_num_suffix_b_test and ad_unit = ad_unit_test
View Replies !
Retrieve The ID Of The Record Just Added
I would like to retreive the identity field value of a record that was just added to the table. In other words, I have a form and on submission, if it is a new record, I would like to know the identity value that the SQL Server has assigned it. This may be overkill, but here is my code to process the form: Protected Sub processForm(ByVal thisID As String, ByVal myAction As String) Dim sqlConn As New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) sqlConn.Open() Dim sql As String Select Case myAction Case "save" If thisID > 0 Then sql = "update INCIDENT set " & _ "RegionID = @RegionID, " & _ "DistrictID = @DistrictID, " & _ "DateReported = @DateReported, " & _ ..CODE... "WHERE IncidentID = " & myIncidentID Else sql = "insert into INCIDENT(" & _ "RegionID, " & _ "DistrictID, " & _ "DateReported, " & _ ...CODE... ") " & _ "values(" & _ "@RegionID, " & _ "@DistrictID, " & _ "@DateReported, " & _ ...CODE... ")" End If Case "delete" sql = "delete from INCIDENT where IncidentID = " & myIncidentID Case Else End Select Dim sqlComm As New SqlCommand(sql, sqlConn) sqlComm.Parameters.Add(New SqlParameter("@RegionID", SqlDbType.NVarChar)) sqlComm.Parameters.Add(New SqlParameter("@DistrictID", SqlDbType.NVarChar)) sqlComm.Parameters.Add(New SqlParameter("@DateReported", SqlDbType.NVarChar)) ...CODE... sqlComm.Parameters.Item("@RegionID").Value = ddRegionID.SelectedValue sqlComm.Parameters.Item("@DistrictID").Value = ddDistrictID.SelectedValue sqlComm.Parameters.Item("@DateReported").Value = db.handleDate(txtDateReported.SelectedDate) ...CODE... Dim myError As Int16 = sqlComm.ExecuteNonQuery 'Response.Redirect("incident.aspx?id=" & ) End Sub The response.redirect at the end of the sub is where I would like to put the identity field value.
View Replies !
How Can I Retrieve The Id Of A New Record Before Update
Can anyone help with an effective way in retriving the id of the new record before input of any data into a form. We have a form where a few of the controls recordsource requires the new record id before they will display correctly. I have tried various ways to trigger the form afterupdate event in the hope that the id will be returned but get the error message "The data will be added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying recordsource" Thanks in advance
View Replies !
Retrieve The Last Record Of A Table
Hi! I needto find the last record that has been inserted on a table. If I perform a SELCT * FROM mytable , will I receive the data based on the inserted order (natural order)? In that case i'll simply need to check the last record of the results I got in my application to find the last inserted one? (no I am not looking for an identity number ^^) thank you
View Replies !
How To Retrieve Identity Of Just Inserted Record???
Ok I've been researching this for a day now and I'm not coming up with much. I want to store the auto-incrementing ID of the last inserted record in a session variable, so that I may put it in a foreign key column in another table, if the user wishes to fill out a form on another page. I think my stored procedure is correct. But don't know what code to add to my aspx page. Any help will be greatly appreciated. Here is my VB ScriptProtected Sub submitButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim personalContactDataSource As New SqlDataSource()personalContactDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("DataConnectionString1").ToString() personalContactDataSource.InsertCommandType = SqlDataSourceCommandType.StoredProcedure personalContactDataSource.InsertCommand = "PersonalContactInsert" personalContactDataSource.InsertParameters.Add("FirstName", FirstName.Text) personalContactDataSource.InsertParameters.Add("LastName", LastName.Text)personalContactDataSource.InsertParameters.Add("KeyPerson", KeyPerson.Checked) personalContactDataSource.InsertParameters.Add("DayPhone", DayPhone.Text)personalContactDataSource.InsertParameters.Add("EveningPhone", EveningPhone.Text) personalContactDataSource.InsertParameters.Add("Fax", Fax.Text)personalContactDataSource.InsertParameters.Add("Email", Email.Text) personalContactDataSource.InsertParameters.Add("HomeAddress", HomeAddress.Text)personalContactDataSource.InsertParameters.Add("City", City.Text) personalContactDataSource.InsertParameters.Add("State", State.Text)personalContactDataSource.InsertParameters.Add("Zip", Zip.Text) personalContactDataSource.InsertParameters.Add("ReqEffectDate", ReqEffectDate.Text)personalContactDataSource.InsertParameters.Add("MRID", MRID.Text) personalContactDataSource.InsertParameters.Add("CurrentPremium", CurrentPremium.Text)personalContactDataSource.InsertParameters.Add("CurrentCarrier", CurrentCarrier.Text) personalContactDataSource.InsertParameters.Add("CurrentDeductible", CurrentDeductible.Text)personalContactDataSource.InsertParameters.Add("CurrentCoins", CurrentCoins.Text)personalContactDataSource.InsertParameters.Add("ReasonForQuote", ReasonForQuote.Text) End Sub And here is my Stored ProcALTER PROCEDURE dbo.PersonalContactInsert @FirstName varchar(30),@LastName varchar(30), @DayPhone varchar(14),@EveningPhone varchar(14), @Fax varchar(14),@Email varchar(60), @HomeAddress varchar(80),@City varchar(30), @State char(2),@Zip char(5), @KeyPerson bit,@ReqEffectDate smalldatetime, @CurrentCarrier varchar(30),@CurrentPremium smallmoney, @CurrentDeductible smallmoney,@CurrentCoins smallmoney, @ReasonForQuote varchar(150),@MRID int, @ClientNumber int OUT AS INSERT INTO PersonalContact(FirstName, LastName, DayPhone, EveningPhone, Fax, Email, HomeAddress, City, State, Zip, KeyPerson, ReqEffectDate, CurrentCarrier, CurrentPremium, CurrentDeductible, CurrentCoins, ReasonForQuote, MRID, DateTimeStamp) VALUES(@FirstName,@LastName,@DayPhone,@EveningPhone,@Fax,@Email,@HomeAddress,@City,@State,@Zip,@KeyPerson,@ReqEffectDate,@CurrentCarrier,@CurrentPremium,@CurrentDeductible,@CurrentCoins,@ReasonForQuote,@MRID, GetDate()) SET @ClientNumber = SCOPE_IDENTITY() RETURN
View Replies !
Hard Task To Retrieve A Value From A Record?!
Hi!I'm desperating here!!! Two questions:1º Is line 13 realy selecting all the records with the username samurai (in this case)?!2º How do I fill the Boolean SeExiste var with a value from the record?1 Dim UserIDParameters As New Parameter 2 3 UserIDParameters.Name = "ProdUserID" 4 5 UserIDParameters.DefaultValue = "samurai" 6 7 Dim LoginSource As New SqlDataSource() 8 9 LoginSource.ConnectionString = ConfigurationManager.ConnectionStrings("ASPNETDBConnectionString1").ToString() 10 11 LoginSource.SelectCommandType = SqlDataSourceCommandType.Text 12 13 LoginSource.SelectCommand = "SELECT FROM aspnet_Users (FirstTime) VALUES (@UserIDParameters) " 14 15 Dim SeExiste As Boolean 16 17 SeExiste = LoginSource.SelectParameters("FirstTime").DefaultValue I'm a newbye and despite this simple thing that in normal ASP is very easy to do!!! Please help me!Thanks in advance!
View Replies !
Retrieve Record From Database Problem
i m using sql server 2000 with asp.net with c# i hv 4 customer records in the customer table starting from C1001 to C1004, i wanna ask is that when a new record is add to the table, the record will be placed at the bottom of the table. For example, CustomerID Customer ID C1001 C1002 C1003 C1004 C1005 When i add a new record which is C1005, is it the record will be placed as shown in the table? if so, that's mean can straight away use the datarow to retrieve the largest number which is C1005, right??? Thx
View Replies !
Retrieve The GUID For Inserted Record
I am using this code to insert a record in my table where i have assigned a guid datatype field to generate an automatic guid for each record. but now i need to retrieve the guid to use it to send a confirmation email to the user. SqlConnection sql_connection = new SqlConnection("Server=xxx.xxx.xx.xxx;uid=xxxxxxxx;password=xxxxxxx;database=xxxxxxx;");SqlCommand sql_command = new SqlCommand("INSERT INTO members (member_sex, member_cpr, member_nationality, member_block, member_gov, member_daaera, member_email, member_mobile, member_created_ip) Values (@member_sex, @member_cpr, @member_nationality, @member_block, @member_gov, @member_daaera, @member_email, @member_mobile, @member_created_ip)", sql_connection); sql_command.Parameters.Add(new SqlParameter("@member_sex", Session["member_sex"].ToString()));sql_command.Parameters.Add(new SqlParameter("@member_cpr", Session["member_cpr"]));sql_command.Parameters.Add(new SqlParameter("@member_nationality", Session["member_nationality"].ToString()));sql_command.Parameters.Add(new SqlParameter("@member_block", Session["member_block"].ToString()));sql_command.Parameters.Add(new SqlParameter("@member_gov", "GOV"));sql_command.Parameters.Add(new SqlParameter("@member_daaera", 6));sql_command.Parameters.Add(new SqlParameter("@member_email", Session["member_email"].ToString().ToLower()));sql_command.Parameters.Add(new SqlParameter("@member_mobile", Session["member_mobile"].ToString()));sql_command.Parameters.Add(new SqlParameter("@member_created_ip", Request.UserHostAddress.ToString())); sql_connection.Open();sql_command.ExecuteNonQuery();sql_connection.Close();
View Replies !
Retrieve Good Records From A Bad Record Table
I have a situation where I need a table if bad items to match to. Forexample, The main table may be as:Table Main:fd_Id INT IDENTITY (1, 1)fd_Type VARCHAR(100)Table Matcher:fd_SubType VARCHAR(20)Table Main might have a records like:1 | "This is some full amount of text"2 | "Here is half amount of text"3 | "Some more with a catch word"Table Matcher:"full""catch"I need to only get the records from the main table that do not haveanything in the match table. This should return only record 2.
View Replies !
How To: Retrieve A Limited Number Of Records From A Record Set
I€™m working on a database project that will ultimately contain millions of records for each lot. In addition, each lot will have up to 96 corresponding serial number records. I would like to add a SQL parameter that would tell the database engine to only return X number of records. For Example: If table TBL_LOTS contains one million records I would like to limit the return set to 100 for example. What would I need to add to the SQL command to below to restrict the data set to the first 100 records in the set of one million? SELECT [LOT NUMBER] FROM TBL_LOTS WHERE [STATMENTS]
View Replies !
SQL Server Everywhere - Retrieve Identity Column After Insert Record
Hello Using Visual Studio 2005 Prof and SQL Server everywhere. How do get the identity column value after insert record. With SQL Server 2005, its quite easy to get by creating and insert statement on the tabledapter ( Insert statement followed by a select statement where identitycolumn = scope_identity()) How do this is sql everywhere?? regards
View Replies !
Linked Reports Not Being Updated When Master Report Is Updated
Since updating to SQL Server 2005 SP2 I've noticed two things about Linked Reports. 1. I do a lot of 'Snapshot' reports. With SP-1 if I updated a master report and made any changes to the Parameter List - it undid all my custom parameter changes on linked versions (restored to the Master Reports Defaults). While this is no longer happening with SP2 - it is still 'unhiding' the parameters. 2. With SP-1 if I added/deleted columns or made other changes to the report structure - the linked reports would pick up on the changes with their next refresh. With SP-2 I'm finding that I have to 'Re-link' the linked report back to the master report before the changes are refreshed. This is very time consuming especially with each report having 8 or more Snapshot reports pre-set up. Am I missing something - or is this a 'bug'... Any help would be appreciated...
View Replies !
Save Updated Date When Row Is Updated
Hi,I want to save the last modification date when the row is updated. I have a column called "LastModification" in the table, every time the row is update I want to set the value of this column to the current date. So far all I know is that I need to use a trigger and the GetDate() function, but could any body help me with how to set the value of the column to getdate()? thanks for your help.
View Replies !
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 !
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 !
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 !
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 !
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 !
Switch Record Background Color With Each Record In Report
Hi Everyone- i have a matrix report and i want to switch the record background color with each record in the value column in that matrix report e.g 1st record background color is gray and next record background color is white and then the next record background color is gray ... and so on can anyone help? thanx Maylo
View Replies !
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 !
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 !
Lookup && Update Record && Insert Record
Hi All, I am trying to create package something like that.. 1- New Customer table as OleDB source component 2- Lookup component - checks customer id with Dimension_Customer table 3- And if same customer exist : I have to update couple fields on Dimension_Customer table 4- if it does not exist then I have insert those records to Dimension_Customer table I am able to move error output from lookup to Dimension_Customer table using oledb destination but How can I update the existing ones? I have tried to use oledb command but somehow it didnt work my sql was like this : update Dimension_Customer set per_X='Y', per_Y= &Opt(it should come from lookup) I will be appreciated if you can help me...
View Replies !
Multiple Record Insertion For Each Record From Source
Hi, How can we insert multiple records in a OLEDB destination table for each entry from the source table. To be more clear, for every record from source we need to insert some 'n' number of records into the destination table. this 'n' changes depending on the record. how is this achieved. thanks.
View Replies !
Update A Record Based Of A Record In The Same Table
I am trying to update a record in a table based off of criteria of another record in the table. So suppose I have 2 records ID owner type 1 5678 past due 2 5678 late So, I want to update the type field to "collections" only if the previous record for the same record is "past due". Any ideas?
View Replies !
Column Locked In Record Even Though No One Accessing Record
Hello. I have a database with a record that has two columns locked. descrip1 and descrip2. they are both nvarchar(max) columns. These are the only two columns of the record that remain locked. I am certain no user is accessing the record. I have even moved a backup of the database to my testing computer and the lock still exists. How do I remove the lock from these two columns on that particular record. I can edit these two columns on other records. I have researched "Unlock" on MSDN but it doesn't seem to apply to t-sql. Any help would be greatly appreciated. Thanks. Gary.
View Replies !
How To Return First Record Child Record And Count
I've been looking for examples online to write a SPROC to get some data. Here are the tables. Album_Category AlbumCategoryID (PK, int, not null) Caption (nvarchar(max), not null) IsPublic (bit, not null) Albums AlbumID (PK, int, not null) AlbumCategoryID (int, null) Caption (nvarchar(max), not null) IsPublic (bit, not null) I need to return: -[Album_Category].[AlbumCategoryID] -[Album_Category].[Caption] -[Albums].[Single AlubmID for each AlbumCategoryID] -[Count of Albums in each AlbumCategory] I hope I was fairly clear in what I'm trying to do. Any tips or help would be appreciated. Thanks.
View Replies !
|
TRACKER
