(Without going into the details of your query) maybe you can convert your query to a CTE then group the result?

Sean Lange (11/18/2013)While the pivot seems a bit contrived here it does a good job of demonstrating how it can be used. ...

The question does test your knowledge of how...

OK. This shows how incomplete understanding can lead to problems...

In further experimenting I found:

If you run the script again it seems to create and drop the table again but it...

Does this explanation from the MSDN forums answer the question?

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/258beea6-f797-4b28-9ba5-aec36b9bc3b2/error-handling-in-user-defined-functions?forum=transactsql

I am not sure I understand the connection. Maybe it would not even get to the CATCH because the whole...

If this does not need to be automated, I have assembled simple queries in text by creating an Excel formula like this in an extra column:

=CONCATENATE("Select * From Logins Where...

I think the idea was to create a view which is basically a select of the 2 columns you want from the table, then you can look at the properties...

In the object explorer find the database you are working with, right-click and select New Query to...

Thanks for the information.

I am sort of an accidental DBA; most of my experience is as a developer. I am learning a lot from the articles and forums on this...

Thanks for your reply.

It may not be as bad as I thought. There are backups in the history tables. (backupfile etc. in msdb)

As for where the backups are going, there...

I like to make use of the fact that SSMS will execute the code that is highlighted with lines like this:

Select * From Employee

-- Update Employee Set LastName = 'Smith'

Where...

OK. Should have done some research before asking so many questions...

Looks like Xcopy will take care of what I need to do (although I have not copied anything yet.

It requires...

When I just re-read my original post I realized there is a problem with terminology. To clarify, when I said

I...

Thanks for the replies. I will look into SQL 2012 Local because that is exactly the type of thing I need. Will it work with a 2008 R2 data...

Hello,

I have implemented a form with a grid that can be used to edit data in a variety of different tables. Then the update button calls a generic method that...

I would say it depends on the kind of questions they ask. I had a lot of "technical interviews" where the questions could have been answered by someone who just...