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...

I think the only possible solution would be dynamic SQL. Get all your info (including required fields, alternate fieldnames, tables, etc.) from the client and build the query with this...

I've read your first post again and noticed something. You are using DTSRUN in your command prompt. The dtsrun command prompt utility (dtsrun.exe) that was used in SQL 2000 has...

steps to generate the automated process:

- manually go througt the RESTORE GUI and generate a script for the complete restore command

- change the name of the backupfile in the generated...

If I understand correctly, you want the values out of a dynamic number of colums and use these values to create a new query.

It takes several steps to accomplish this....

Remember: if within a CASE statement the WHEN clause is TRUE, the following WHEN statements and the ELSE statement is not executed anymore.

So if some data in your example contains...

No, you should put the "EXEC sp_trace_setstatus 2, 1" command in the IF block, just before or after the mail command. Because of the "not exists" check, the first IF...

Check the recovery model of the database. If it is in FULL recovery you need to take frequently LOG-backups (every 15 - 30 minutes). If you don't do that the...

You have mixed Visual Basic language (private sub....) with T-SQL (Select Case ....). Those languages can't be combined in one statement.

The code you stated is more Visual Basic then T-SQL...

Open a command prompt on each node, navigate to the root of the disk and execute "dtexec /?" (without quotes). Compare the version number in both outputs. They should be...