Red Gate forums :: View topic - sort by Date Last Modified
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

sort by Date Last Modified

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Fri Aug 31, 2012 5:14 pm    Post subject: sort by Date Last Modified Reply with quote

Looking to add a column on the object to be able to
sort by Date Last Modified
Back to top
View user's profile Send private message Send e-mail
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Mon Sep 03, 2012 12:25 pm    Post subject: Reply with quote

Sorry - I'm not sure exactly how this relates to SQL Compare? If you want to order rows in a table by the date last modified, you'd need to set that up through SSMS - there's a little more information here that might be useful to you:

http://stackoverflow.com/questions/2610370/question-about-datecreated-and-datemodified-columns-sql-server

Is that the kind of thing you're after?
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Thu Sep 06, 2012 8:04 pm    Post subject: sort by Date Last Modified Reply with quote

Well this way you can sort by date order and determine which change you want per date.

For Example if you are only looking to find out today's changes and not all other changes.
Back to top
View user's profile Send private message Send e-mail
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Thu Sep 13, 2012 2:51 pm    Post subject: Reply with quote

Ah, right, OK. SQL Server doesn't capture any information like this by default, so you'd need to set up a computed column for SQL Compare or SQL Data Compare to have any access to that information. I'm assuming this question is actually about SQL Data Compare, given that you're talking about sorting by columns.

If you've got that DateModified column set up, then you can filter the data with a WHERE clause as detailed on this page:

http://www.red-gate.com/supportcenter/Content/SQL_Data_Compare/help/10.0/SDC_ApplyingConditions

That ought to let you filter for changes applied within a specific timeframe. Does that help at all?
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group