Viewing 15 posts - 751 through 765 (of 9,641 total)
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
Unfortunately there isn't a way to do this natively. If you have rights to see the report in the list you can run the report. I can see...
August 22, 2014 at 12:35 pm
Lynn Pettis (8/22/2014)
mario17 (8/22/2014)
you actually got Q#4.:-)
But I understand what my query is doing easier than Chris's Q4. The parens make the order of the joins visually apparent. ...
August 22, 2014 at 12:27 pm
Viewing 15 posts - 751 through 765 (of 9,641 total)