I think you just need to add [font="Courier New"]@Startingdate =[/font] before [font="Courier New"]s2.StartDate[/font]. Can you guarantee that the SELECT query will always return a single row only?

John

Are you looking for separate rows for each backup type for each database? If so, just add backup type to your SELECT list and GROUP clause. If ,...

Petr

In that case, yes, change CategoryID to varchar something, and then use something like this page[/url] for tips on how to perform your concatenation.

John

Petr

This isn't possible - CategoryID is int, so you can't change it to 2,7. Even if you could, I'd advise you not to - you're breaking the laws of...

I would suggest a slight modification to the above, since the previous ID is not always going to be the current ID minus 1 (there will be gaps). Also,...

Dave

The problem with a maintenance plan is you don't have much control over what it does. What you want to do is only rebuild the indexes that need it....

Jeff

It's easy enough to install. You don't even have to run it on the same server as you're doing the ETL on. If it's really not an option,...

Jeff

I would use SSIS (or your favourite other way of doing ETL) to bring the data from the remote servers into Access. Don't use linked servers at all -...

Have a look at the properties of the linked server, and go the the Security tab. Are there any logins listed in the box at the top? Which...

No, SQL Server waits ad infinitum for locks to be released. As Gianluca suggested, please use sp_who2 or sp_whoisactive to find out whether there is any blocking. What...

You're looking for a splitter function. Try this search for a start.

John

Edit: oops - I just realised that you were asking for an expression in SSIS to do...

I think Ola Hallengren's procedures will automatically take a full backup if one doesn't exist.

John

Blush! Thanks, guys.

John

You can do it by breaking each permission down into a sum of powers of two. Something like this should work:

SELECT UserName, ServerOperation, SUM(DISTINCT p)

FROM #Operations o

OUTER APPLY (

SELECT...

I see - you want to find out which groups a particular user is a member of, rather than which users are members of a particular group? That's a...