You can also define a "zero" time (set @time = '0:00:00') and use this with the DATEDIFF to get the passed time

datediff(minute, @time, @time1 + @time2)

Just add both values. The return type will also be a datetime value which you can CONVERT to the desired format. If you want to calculate just the minutes, you'll...

I don't have a complete solution for you (not enough time on my hands), but I think the code below could give you a headstart.

Create Table #Temp

(

Number Int,

Transaction_Date DateTime,

Totalcoll Numeric(12,2),

Maintainance_Due...

You should number your rows (add a number column) and join on this number column, or change your current JOIN statement from "ON T1.ID1 = T2.ID1" to "ON T1.ID1 =...

I don't have powershell experience yet, but I think http://technet.microsoft.com/en-us/library/ee176858.aspx could give you a start. There are also a lot of other resources on the web. Just google around 😉

Use WMI or powershell (for example every minute, depending on the requirements) from a central server to monitor the status of the SQL Engine service on a remote server. When...

You don't mention how the rows are related to the next row. I have numbered all rows, but this is maybe not as you need. The numbering is needed to...

This is way to little information. You need to specify sample input and output data and preferrably explain what your goal is. Also state whatever you have tried so far....

When using "SELECT *" in a view the metadata is not automaticly updated when the related table(s) are altered. Use "sp_refreshview" to update the metadata for the specified non-schema-bound view....

You'll need to add a rownumber to the table so you can JOIN it to the previous row. In the below code I've used also a CTE . That way...

If you provide the statements to create the test data, it will be a lot easier to give you some help.

My guess is you need to join on a sub-select...

take a look on this post on MSDN: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/420a44b3-86ec-4aca-8165-cf5ed5e2d8d4

The error message "The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'." implies that DENY or REVOKE access is applied on the [mssqlsystemresource] database. Or perhaps...

Instead of patching first three nodes and second one node, you could also patch first two nodes and second other two nodes. Perhaps you could allready implement this without installing...

If the cluster node has enough capacity (mem, CPU) you could move all SQL-instances to one node.

1. Move all SQL instances to node A.

2. Install patches on nodes B, C...