Viewing 15 posts - 751 through 765 (of 9,643 total)
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...
August 27, 2014 at 10:56 am
I'm not aware of any issues with this DMV. What makes you think the procedures weren't executed?
August 27, 2014 at 10:48 am
Just replace TODAY() with Parameters!StartDate.Value in each of the other calculations.
August 25, 2014 at 1:48 pm
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...
August 25, 2014 at 11:39 am
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...
August 25, 2014 at 10:47 am
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...
August 22, 2014 at 2:24 pm
DennisPost (8/22/2014)
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...
August 22, 2014 at 1:19 pm
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...
August 22, 2014 at 1:16 pm
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...
August 22, 2014 at 1:09 pm
Luis Cazares (8/22/2014)
If you want one column for each benefit, check the following articles about Cross Tabs and Pivots:
Yeah, this is right, my first answer was wrong because...
August 22, 2014 at 1:05 pm
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...
August 22, 2014 at 1:04 pm
Duplicate post, please post answers here, http://www.sqlservercentral.com/Forums/Topic1606251-1632-1.aspx
August 22, 2014 at 12:57 pm
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,...
August 22, 2014 at 12:55 pm
CELKO (8/22/2014)
Did you know that SQL uses “<>” and not “!=” ?
T-SQL does allow the use of != as well as <> so I don't think it's a big...
August 22, 2014 at 12:44 pm
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...
August 22, 2014 at 12:41 pm
Viewing 15 posts - 751 through 765 (of 9,643 total)