In case you still need to know how to do this. Edit the Registry Key in HKEY_CURRENT_USER: Software\Microsoft\Microsoft SQL Server\xx\Tools\Shell\Text Editor\Visible Whitespace Where xx is the version you have (90 is 2005, 100 is 2008) And set it to 1 to show. Or for SQL Server 2012 and up client tools it is also in … Read more
Try this: SELECT *, ROW_NUMBER() OVER(ORDER BY Id) ROW_NUM FROM ( select Id, VersionNumber from documents where id=5 Union all select Id, VersionNumber from versions where id=5 ) a order by VersionNumber desc TO filter by version number 5 use: SELECT * FROM (SELECT *, Row_number() OVER(ORDER BY versionnumber DESC, id) row_num FROM (SELECT id, … Read more
select @currentTerm = CurrentTerm, @termID = TermID, @endDate = EndDate from table1 where IsCurrent = 1
You can do this simply without the DECLARE command – which is not valid for #temp tables anyway, only @table variables. Did you try just the following without trying to define #tmp first: SELECT * INTO #tmp FROM myTable;
Assuming this is actually a composite key, since you can’t have 2 primary keys… The error message tells you exactly what to do, namely add an order. You can do this by adding [Column(Order = 0)] and [Column(Order = 1)] to your key columns. For your example: public class LineItem { [Key][Column(Order = 0)] public … Read more
;with cteRowNumber as ( select COMPUTERNAME, SERIALNUMBER, USERNAME, LASTIP, LASTUPDATE, SOURCE, row_number() over(partition by COMPUTERNAME order by LASTUPDATE desc) as RowNum from YourTable ) select COMPUTERNAME, SERIALNUMBER, USERNAME, LASTIP, LASTUPDATE, SOURCE from cteRowNumber where RowNum = 1
If the two databases are on the same server, you should be able to create a SQL statement something like this: UPDATE Test1.dbo.Employee SET DeptID = emp2.DeptID FROM Test2.dbo.Employee as ’emp2′ WHERE Test1.dbo.Employee.EmployeeID = emp2.EmployeeID From your post, I’m not quite clear whether you want to update Test1.dbo.Employee with the values from Test2.dbo.Employee (that’s what … Read more
You can get the difference between the two dates to whatever resolution you want (in your example, minutes): DATEDIFF(minute, @start_date, @end_date) From there it’s a simple matter of dividing minutes into hours and hours into days and modding the remainder.
How about something like: select (select isnull(max(val)+1,1) from mydata where val < md.val) as [from], md.val – 1 as [to] from mydata md where md.val != 1 and not exists ( select 1 from mydata md2 where md2.val = md.val – 1) giving summarised results: from to ———– ———– 6 6 8 8 11 14
This is our template (error logging removed) This is designed to handle Paul Randal’s article “No such thing as a nested transaction in SQL Server” Error 266 Trigger Rollbacks Explanations: all TXN begin and commit/rollbacks must be paired so that @@TRANCOUNT is the same on entry and exit mismatches of @@TRANCOUNT cause error 266 because … Read more