What do you mean by put in another database? Do you mean move the stored procedures into the database(s) that they source their data from or move them into...

I'm not aware of any issues with this DMV. What makes you think the procedures weren't executed?

Just replace TODAY() with Parameters!StartDate.Value in each of the other calculations.

There are a few issues with your attempt at an expression in SSRS.

1. 0 can't be converted to a date by .NET (the basis for the expression...

Just to be clear. If SID = 17 then the destination SID gets 17 and SID2 gets empty string or a NULL (if it is a numeric column) and...

The biggest issue I would have with the scalar udf (and I had a similar issue when working on time zone conversion) is that the scalar UDF is being called...

DennisPost (8/22/2014)

---

Resolved.

Daily job saves all indexed views into a table.

DDL trigger checks if the view to be alter is in the IndexedView table.

If so, raise error & rollback.

To alter the...

Wow, sounds like poor design to start with. When I first read the question a redesign around Service Broker popped into my head because this is essentially a queuing...

The only problem I see is I don't think you'll be able to find a way to get the expression button to popup the expression dialogue. Otherwise you just...

Yeah, this is right, my first answer was wrong because...

The way I would handle this would be by passing the parameters as parameters to the query in the data set. So the query would look something like this:

IF...

Duplicate post, please post answers here, http://www.sqlservercentral.com/Forums/Topic1606251-1632-1.aspx

This isn't an intuitive thing to do in T-SQL and I normally suggest putting it in a reporting tool, like SSRS that will group for you. Having said that,...

T-SQL does allow the use of != as well as <> so I don't think it's a big...

Since you are SQL Server 2008 you should use a server-side trace (ignore the section about the rowset provider) to capture what the application is trying to do on the...